APPS.PAY_KW_PIFSS_REPORT dependencies on PER_PEOPLE_F

Line 37: ,per_people_f pef

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
40: AND pos.period_of_service_id = asg.period_of_service_id
41: AND ppa.action_type in ('R','Q')

Line 89: ,per_people_f pef

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')
93: AND ppa.action_status = 'C'

Line 146: ,per_people_f pef

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
149: AND pos.period_of_service_id = asg.period_of_service_id
150: AND ppa.action_type in ('R','Q')

Line 169: ,per_people_f pef

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
172: and asg.person_id = p_person_id
173: and paa.payroll_action_id = ppa.payroll_action_id

Line 192: ,per_people_f pef

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
195: and asg.person_id = p_person_id
196: and paa.payroll_action_id = ppa.payroll_action_id

Line 283: ,per_people_f pef

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
286: AND pos.period_of_service_id = asg.period_of_service_id
287: AND ppa.action_type in ('R','Q')

Line 533: From per_people_f

529: order by asg.person_id;
530:
531: CURSOR csr_get_start_date(l_person_id number , l_effective_date date) IS
532: Select start_date
533: From per_people_f
534: Where person_id = l_person_id
535: And l_effective_date between effective_start_date and effective_end_date;
536:
537: CURSOR csr_soc_bal_id(l_employer_id number) IS