APPS.PAY_SG_DEDUCTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 144: from per_all_assignments_f paf

140: , to_date(per_information11, 'YYYY/MM/DD HH24:MI:SS')
141: , effective_start_date
142: from per_all_people_f per
143: where per.person_id = (select max(paf.person_id)
144: from per_all_assignments_f paf
145: where paf.assignment_id = p_assignment_id)
146: and per.per_information6 = 'WP'
147: and nvl(per.current_employee_flag,'N') = 'Y' /* Bug 6158284 */
148: and per.effective_start_date <= p_end_date

Line 373: from per_all_assignments_f paf

369: , to_date(per_information10, 'YYYY/MM/DD HH24:MI:SS')
370: , to_date(per_information11, 'YYYY/MM/DD HH24:MI:SS')
371: from per_all_people_f per
372: where per.person_id = (select max(paf.person_id)
373: from per_all_assignments_f paf
374: where paf.assignment_id = p_assignment_id)
375: and per.per_information6 = 'SP'
376: and per.effective_start_date <= p_end_date
377: and per.effective_end_date >= p_start_date

Line 509: per_all_assignments_f target

505: c_pay_proc_end_date date)
506: is
507: select min(pap.effective_start_date),max(pap.effective_end_date) /*bug 2772106 */
508: from per_all_people_f pap,
509: per_all_assignments_f target
510: where target.assignment_id = c_assignment_id
511: and pap.person_id = target.person_id
512: and nvl(pap.current_employee_flag,'N') = 'Y';
513:

Line 521: from per_all_assignments_f paf

517: select target.PER_INFORMATION6,
518: target.EFFECTIVE_START_DATE
519: from per_all_people_f target
520: where target.person_id = (select paf.person_id
521: from per_all_assignments_f paf
522: where paf.assignment_id = c_assignment_id
523: and c_date between paf.effective_start_date and paf.effective_end_date )
524: and c_date between target.effective_start_date and target.effective_end_date;
525: