APPS.PAY_SG_DEDUCTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 159: from per_all_assignments_f paf

155: , to_date(per_information11, 'YYYY/MM/DD HH24:MI:SS')
156: , effective_start_date
157: from per_all_people_f per
158: where per.person_id = (select max(paf.person_id)
159: from per_all_assignments_f paf
160: where paf.assignment_id = p_assignment_id)
161: and per.per_information6 = 'WP'
162: and per.per_information8 not like 'SP%'
163: and nvl(per.current_employee_flag,'N') = 'Y' /* Bug 6158284 */

Line 397: from per_all_assignments_f paf

393: , to_date(per_information11, 'YYYY/MM/DD HH24:MI:SS')
394: , effective_start_date
395: from per_all_people_f per
396: where per.person_id = (select max(paf.person_id)
397: from per_all_assignments_f paf
398: where paf.assignment_id = p_assignment_id)
399: and per.per_information6 = 'SP'
400: and nvl(per.current_employee_flag,'N') = 'Y' /* Bug 6158284 */
401: and per.effective_start_date <= p_end_date

Line 620: per_all_assignments_f target

616: c_pay_proc_end_date date)
617: is
618: select min(pap.effective_start_date),max(pap.effective_end_date) /*bug 2772106 */
619: from per_all_people_f pap,
620: per_all_assignments_f target
621: where target.assignment_id = c_assignment_id
622: and pap.person_id = target.person_id
623: and nvl(pap.current_employee_flag,'N') = 'Y';
624:

Line 632: from per_all_assignments_f paf

628: select target.PER_INFORMATION6,
629: target.EFFECTIVE_START_DATE
630: from per_all_people_f target
631: where target.person_id = (select paf.person_id
632: from per_all_assignments_f paf
633: where paf.assignment_id = c_assignment_id
634: and c_date between paf.effective_start_date and paf.effective_end_date )
635: and c_date between target.effective_start_date and target.effective_end_date;
636: