APPS.PAY_KW_PIFSS_REPORT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 33: ,pay_assignment_actions paa

29: l_temp_pid number;
30: CURSOR csr_get_new_emp (l_employer_id number,l_effective_date date , l_nationality varchar2) IS
31: SELECT distinct asg.person_id
32: FROM per_assignments_f asg
33: ,pay_assignment_actions paa
34: ,pay_payroll_actions ppa
35: ,hr_soft_coding_keyflex hscl
36: ,per_periods_of_service pos
37: ,per_people_f pef

Line 86: ,pay_assignment_actions paa

82: l_temp_pid number;
83: CURSOR csr_get_tot_emp (l_employer_id number,l_effective_date date , l_nationality varchar2) IS
84: SELECT distinct asg.person_id
85: FROM per_assignments_f asg
86: ,pay_assignment_actions paa
87: ,pay_payroll_actions ppa
88: ,hr_soft_coding_keyflex hscl
89: ,per_people_f pef
90: WHERE asg.assignment_id = paa.assignment_id

Line 142: ,pay_assignment_actions paa

138: -- Cursor to get person ids of employees neither new nor terminated.
139: CURSOR csr_get_change_emp(l_employer_id number, l_effective_date date , l_nationality varchar2) IS
140: SELECT distinct asg.person_id
141: FROM per_assignments_f asg
142: ,pay_assignment_actions paa
143: ,pay_payroll_actions ppa
144: ,hr_soft_coding_keyflex hscl
145: ,per_periods_of_service pos
146: ,per_people_f pef

Line 165: ,pay_assignment_actions paa

161: AND pef.nationality = l_nationality;
162: --Cursor to get assignment_action_id of total employees
163: cursor get_assact_id_tot (p_org_id number,p_date date,p_person_id number , l_nationality varchar2) is
164: select paa.assignment_action_id from per_assignments_f asg
165: ,pay_assignment_actions paa
166: ,pay_payroll_actions ppa
167: ,hr_soft_coding_keyflex hscl
168: ,per_periods_of_service pos
169: ,per_people_f pef

Line 188: ,pay_assignment_actions paa

184: order by asg.person_id;
185: --Cursor to get assignment_action_id of employees' previous month
186: cursor get_assact_id_tot_prev_month (p_org_id number,p_prev_month_date date,p_person_id number , l_nationality varchar2) is
187: select paa.assignment_action_id from per_assignments_f asg
188: ,pay_assignment_actions paa
189: ,pay_payroll_actions ppa
190: ,hr_soft_coding_keyflex hscl
191: ,per_periods_of_service pos
192: ,per_people_f pef

Line 279: ,pay_assignment_actions paa

275: l_temp_pid number;
276: CURSOR csr_get_term_emp(l_employer_id number,l_effective_date date , l_nationality varchar2) IS
277: SELECT distinct asg.person_id
278: FROM per_assignments_f asg
279: ,pay_assignment_actions paa
280: ,pay_payroll_actions ppa
281: ,hr_soft_coding_keyflex hscl
282: ,per_periods_of_service pos
283: ,per_people_f pef

Line 514: ,pay_assignment_actions paa

510:
511: CURSOR csr_get_first_assact_id (l_employer_id number, l_date date ,l_person_id number) IS
512: select paa.assignment_action_id
513: from per_assignments_f asg
514: ,pay_assignment_actions paa
515: ,pay_payroll_actions ppa
516: ,hr_soft_coding_keyflex hscl
517: ,per_periods_of_service pos
518: where rownum < 2