ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4714E51A9E05362FB09050512 SELECT &p_hint_clause, --SELECT &p_hint_clause pec.CLASSIFICATION_NAME, peo.FULL_NAME, paf.ASSIGNMENT_NUMBER, paa.TAX_UNIT_ID, ppa.EFFECTIVE_DATE, paa.ASSIGNMENT_ACTION_ID, pet.ELEMENT_NAME, pet.ELEMENT_INFORMATION_CATEGORY, pet.ELEMENT_INFORMATION1, rrs.JURISDICTION_CODE, rrsv.RESULT_VALUE, piv.NAME, PAY_PAYUSRRS_XMLP_PKG.gre_nameformula(paa.TAX_UNIT_ID) GRE_NAME, PAY_PAYUSRRS_XMLP_PKG.element_categoryformula(pet.ELEMENT_INFORMATION_CATEGORY, pet.ELEMENT_INFORMATION1) ELEMENT_CATEGORY, --&RESULT_VALUE RVALUE PAY_PAYUSRRS_XMLP_PKG.RVALUEFormula(rrsv.RESULT_VALUE) RVALUE FROM PAY_INPUT_VALUES_F piv, PAY_ELEMENT_CLASSIFICATIONS pec, PAY_ELEMENT_TYPES_F pet, PAY_RUN_RESULT_VALUES rrsv, PAY_RUN_RESULTS rrs, PAY_PAYROLL_ACTIONS ppa, PAY_ASSIGNMENT_ACTIONS paa, PER_ASSIGNMENTS_F paf, PER_PEOPLE_F peo &p_from_clause WHERE paf.ASSIGNMENT_ID = paa.ASSIGNMENT_ID AND paa.ASSIGNMENT_ACTION_ID = rrs.ASSIGNMENT_ACTION_ID AND ppa.PAYROLL_ACTION_ID = paa.PAYROLL_ACTION_ID AND ppa.EFFECTIVE_DATE BETWEEN :p_start_date AND :p_end_date AND ppa.EFFECTIVE_DATE BETWEEN paf.EFFECTIVE_START_DATE AND paf.EFFECTIVE_END_DATE AND ppa.DATE_EARNED BETWEEN piv.EFFECTIVE_START_DATE AND piv.EFFECTIVE_END_DATE AND ppa.EFFECTIVE_DATE BETWEEN peo.EFFECTIVE_START_DATE AND peo.EFFECTIVE_END_DATE AND ppa.DATE_EARNED BETWEEN pet.EFFECTIVE_START_DATE AND pet.EFFECTIVE_END_DATE AND rrs.RUN_RESULT_ID = rrsv.RUN_RESULT_ID AND rrs.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID AND pet.CLASSIFICATION_ID = pec.CLASSIFICATION_ID AND rrsv.INPUT_VALUE_ID = piv.INPUT_VALUE_ID AND EXISTS ( SELECT 'Y' FROM pay_balance_feeds_f pbff WHERE pbff.input_value_id = piv.input_value_id ) AND decode ( rrsv.result_value , null , 'N' , '0' , 'N' , 'Y' ) = 'Y' AND peo.BUSINESS_GROUP_ID = :p_business_group_id AND peo.PERSON_ID = paf.PERSON_ID &p_where_clause ORDER BY paa.TAX_UNIT_ID ASC, paf.ASSIGNMENT_NUMBER ASC, pec.CLASSIFICATION_NAME ASC, ELEMENT_CATEGORY,--ADDED AS A PART OF FIX pet.ELEMENT_NAME ASC, ppa.EFFECTIVE_DATE ASC, rrs.JURISDICTION_CODE ASC, paa.ASSIGNMENT_ACTION_ID Y PAY PAYUSRRS_XML US PAY Employee Run Results Imported from BI Publisher Description: Employee Run Results Report Application: Payroll Source: Employee Run Results Report (XML) Short Name: PAYUSRRS_XML DB package: PAY_PAYUSRRS_XMLP_PKG BI Publisher &p_from_clause &p_hint_clause &p_where_clause &result_value :c_business_group_name :c_classification_name :c_person_name :c_report_subtitle :cp_asg_set_name :cp_gre_name :lp_end_date :lp_start_date :p_asg_set_id :p_assignment_number :p_business_group_id :p_classification_id :p_conc_request_id :p_end_date :p_from_clause :p_hint_clause :p_person_id :p_report_subtitle :p_report_title :p_selection_criteria :p_session_date :p_start_date :p_tax_unit_id :p_where_clause 1 -50 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US PER_ID Business Group ID 2 -30 :p_is_asg_num Char select 'Y' from dual where :$flex$.selection_criterion:NULL = '16' US PER_CHAR Is Assignment Number? 3 -20 :p_is_asg_set Char select 'Y' from dual where :$flex$.selection_criterion:NULL = '18' US PER_CHAR Is Assignment Set? 4 -40 :p_is_person Char select 'Y' from dual where :$flex$.selection_criterion:NULL = '01' US PER_CHAR Is Person? 5 10 :p_start_date Date Y US Start Date Date From 6 20 :p_end_date Date Y US End Date Date To 7 30 :p_selection_criteria LOV Oracle HR_US_RRS_SELECT_CRITERIA Y select hl.lookup_code id, hl.meaning value, null description from hr_lookups hl where hl.lookup_type='REPORT_SELECT_SORT_CODE' and lookup_code in ('16','18','01') order by hl.meaning Y US Selection Criterion Selection Criterion 8 40 :p_person_id LOV Oracle HR_US_PERSON_COND Y Y select ppf.person_id id, ppf.full_name||' (Person ID='||ppf.person_id||')' value, null description from per_people_f ppf,per_person_types ppt where ppf.business_group_id+0= fnd_global.per_business_group_id and ppt.person_type_id=ppf.person_type_id+0 and ppt.system_person_type in ('EMP','EMP_APL','EX_EMP','EX_EMP_APL') and ppf.effective_start_date= (select max(effective_start_date) from per_people_f ppf1 where ppf1.person_id=ppf.person_id) and 'Y'=:$flex$.per_char order by nvl(ppf.order_name,ppf.full_name) Y US Employee Name Person ID 9 50 :p_assignment_number LOV Oracle HR_US_RUN_ASG_NUM_COND Y select pa.assignment_number id, pa.assignment_number value, pp.full_name description from per_assignments pa,per_people pp where pp.business_group_id+0=fnd_global.per_business_group_id and pa.person_id=pp.person_id and 'Y'=:$flex$.per_char order by assignment_number Select max(pa.assignment_number) from per_assignments pa where pa.person_id = :$flex$.employee_name Y US Assignment Number Assignment Number 10 60 :p_asg_set_id LOV Oracle PAY_US_ASSIGNMENT_SETS Y select assignment_set_id id, assignment_set_name value, null description from hr_assignment_sets where business_group_id=fnd_global.per_business_group_id and 'Y'=:$flex$.per_char order by assignment_set_name Y US Assignment Set Assignment Set ID 11 70 :p_tax_unit_id LOV Oracle HR_US_TAX_UNIT Y select txu.tax_unit_id id, txu.name value, null description from hr_tax_units_v txu where txu.business_group_id= fnd_global.per_business_group_id order by value,description US Government Reporting Entity Government Reporting Entity 12 80 :p_classification_id LOV Oracle HR_US_CLASSIFICATIONS Y select classification_id id, classification_name value, null description from pay_element_classifications where legislation_code=(select org_information9 from hr_organization_information where org_information_context='Business Group Information' and organization_id=:$flex$.per_id) and (business_group_id+0 is null or business_group_id+0=:$flex$.per_id) order by classification_name US Classification Element Classification ID :$flex$.employee_name Employee Name Assignment Number :$flex$.per_char PER_CHAR Assignment Number :$flex$.per_char PER_CHAR Assignment Set :$flex$.per_char PER_CHAR Employee Name :$flex$.per_id PER_ID Classification