[Home] [Help]
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
40: AND pos.period_of_service_id = asg.period_of_service_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
149: AND pos.period_of_service_id = asg.period_of_service_id
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
172: and asg.person_id = p_person_id
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
195: and asg.person_id = p_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
286: AND pos.period_of_service_id = asg.period_of_service_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
521: and paa.payroll_action_id = ppa.payroll_action_id