APPS.PAY_NL_REM_REPORT dependencies on PAY_PAYROLL_ACTIONS

Line 1006: FROM pay_payroll_actions ppa

1002: || papf.per_information1 employee_name
1003: ,papf.national_identifier sofi
1004: ,papf.date_of_birth dateofbirth
1005: ,paa.assignment_sequence assignment_sequence
1006: FROM pay_payroll_actions ppa
1007: ,pay_assignment_actions asg_act
1008: ,per_assignments_f paa
1009: ,pay_all_payrolls_f ppf
1010: ,per_periods_of_service pps

Line 1137: FROM pay_payroll_actions ppa

1133: ,paa.assignment_action_id assact_id
1134: ,paa.assignment_id asg_id
1135: ,concat(concat(ptp.period_num,' '),TO_CHAR(ptp.START_DATE,'YYYY')) period_name
1136: ,ptp.start_date start_date
1137: FROM pay_payroll_actions ppa
1138: ,pay_assignment_actions paa
1139: ,per_time_periods ptp
1140: WHERE paa.payroll_action_id = ppa.payroll_action_id
1141: AND paa.action_status IN ('C','S')

Line 1159: c_pact_id pay_payroll_actions.payroll_action_id%TYPE,

1155: ORDER BY period_name
1156: ,pact_id;
1157: --=============================================================================
1158: CURSOR cur_retro_period_det(c_assignment_id per_all_assignments_f.assignment_id%TYPE,
1159: c_pact_id pay_payroll_actions.payroll_action_id%TYPE,
1160: c_assact_id pay_assignment_actions.assignment_action_id%TYPE
1161: ) IS
1162: SELECT ptp.start_date retro_period
1163: ,ppa.payroll_action_id pact_id

Line 1168: FROM pay_payroll_actions ppa

1164: ,ppa.effective_date eff_date
1165: ,paa.assignment_action_id assact_id
1166: ,paa.assignment_id asg_id
1167: ,concat(concat('R '||ptp.period_num,' '),TO_CHAR(ptp.START_DATE,'YYYY')) period_name
1168: FROM pay_payroll_actions ppa
1169: ,pay_assignment_actions paa
1170: ,pay_run_results prr
1171: ,per_time_periods ptp
1172: WHERE paa.payroll_action_id = ppa.payroll_action_id

Line 1835: ,pay_payroll_actions ppa

1831: papf.national_identifier sofi_number
1832: FROM per_all_people_f papf
1833: ,per_all_assignments_f paa
1834: ,per_periods_of_service pps
1835: ,pay_payroll_actions ppa
1836: ,pay_assignment_actions asg_act
1837: ,pay_all_payrolls_f ppf
1838: WHERE ppa.business_group_id = p_business_group_id
1839: AND nvl (paa.establishment_id

Line 1896: ,pay_payroll_actions ppa

1892: , REPLACE(hou1.name,l_seperator,' ') employer_name
1893: FROM per_all_people_f papf
1894: ,per_all_assignments_f paa
1895: ,per_periods_of_service pps
1896: ,pay_payroll_actions ppa
1897: ,pay_assignment_actions asg_act
1898: ,pay_all_payrolls_f ppf
1899: ,hr_all_organization_units hou1
1900: WHERE ppa.business_group_id = p_business_group_id