APPS.PAY_KW_PIFSS_REPORT dependencies on PER_ASSIGNMENTS_F

Line 32: FROM per_assignments_f asg

28: l_new_count number;
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

Line 85: FROM per_assignments_f asg

81: l_total_count number;
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

Line 141: FROM per_assignments_f asg

137: l_n_c number;
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

Line 164: select paa.assignment_action_id from per_assignments_f asg

160: AND pef.person_id = asg.person_id
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

Line 187: select paa.assignment_action_id from per_assignments_f asg

183: and pef.nationality = l_nationality
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

Line 278: FROM per_assignments_f asg

274: l_term_count number;
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

Line 513: from per_assignments_f asg

509: FUNCTION get_amount_cont (p_employer_id number, p_assact_cur_id number , p_person_id number , p_effective_date date) return varchar2 IS
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