APPS.PAY_NL_REM_REPORT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1007: ,pay_assignment_actions asg_act

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
1011: ,hr_all_organization_units hou1

Line 1138: ,pay_assignment_actions paa

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')
1142: AND ppa.effective_date BETWEEN l_reporting_start_date

Line 1160: c_assact_id pay_assignment_actions.assignment_action_id%TYPE

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
1164: ,ppa.effective_date eff_date

Line 1169: ,pay_assignment_actions paa

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
1173: AND paa.source_action_id IS NOT NULL

Line 1188: FROM pay_assignment_actions paa1

1184: AND ptp.end_date
1185: AND paa.assignment_action_id IN
1186: (
1187: SELECT paa1.assignment_action_id
1188: FROM pay_assignment_actions paa1
1189: WHERE paa1.payroll_action_id = ppa.payroll_action_id
1190: AND paa1.assignment_id = paa.assignment_id
1191: )
1192: AND paa.assignment_id = c_assignment_id

Line 1836: ,pay_assignment_actions asg_act

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
1840: ,ppf.prl_information1) = p_org_id

Line 1897: ,pay_assignment_actions asg_act

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
1901: AND papf.effective_start_date <= l_reporting_end_date