APPS.PAY_KW_PIFSS_REPORT dependencies on HR_SOFT_CODING_KEYFLEX

Line 35: ,hr_soft_coding_keyflex hscl

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
38: WHERE asg.assignment_id = paa.assignment_id
39: AND paa.payroll_action_id = ppa.payroll_action_id

Line 88: ,hr_soft_coding_keyflex hscl

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
91: AND paa.payroll_action_id = ppa.payroll_action_id
92: AND ppa.action_type in ('R','Q')

Line 144: ,hr_soft_coding_keyflex hscl

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
147: WHERE asg.assignment_id = paa.assignment_id
148: AND paa.payroll_action_id = ppa.payroll_action_id

Line 167: ,hr_soft_coding_keyflex hscl

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
170: where rownum < 2
171: and asg.assignment_id = paa.assignment_id

Line 190: ,hr_soft_coding_keyflex hscl

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
193: where rownum < 2
194: and asg.assignment_id = paa.assignment_id

Line 281: ,hr_soft_coding_keyflex hscl

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
284: WHERE asg.assignment_id = paa.assignment_id
285: AND paa.payroll_action_id = ppa.payroll_action_id

Line 516: ,hr_soft_coding_keyflex hscl

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
519: and asg.assignment_id = paa.assignment_id
520: and asg.person_id = l_person_id