APPS.PAY_US_ACTION_ARCH dependencies on PER_ALL_ASSIGNMENTS_F

Line 2776: ,per_all_assignments_f assign

2772: select nvl(ADDR.add_information19,ADDR.region_1),
2773: nvl(ADDR.add_information17,ADDR.region_2),
2774: nvl(addr.add_information18,addr.town_or_city)
2775: from per_addresses addr
2776: ,per_all_assignments_f assign
2777: where cp_run_effective_date between assign.effective_start_date
2778: and assign.effective_end_date
2779: and assign.assignment_id = cp_assignment_id
2780: and addr.person_id = assign.person_id

Line 4874: (select person_id from per_all_assignments_f paf

4870: upper(substr(middle_names,1,1)) || '. ' ) ||
4871: pre_name_adjunct || last_name || ' '|| suffix))
4872: from per_all_people_f ppf
4873: where ppf.person_id =
4874: (select person_id from per_all_assignments_f paf
4875: where assignment_id = cp_assignment_id
4876: and cp_effective_date between paf.effective_start_date
4877: and paf.effective_end_date)
4878: and cp_effective_date between ppf.effective_start_date

Line 4969: from per_all_assignments_f paf

4965:
4966: cursor c_get_asg_work_at_home (cp_assignment_id in number
4967: ,p_run_effective_date in date) is
4968: select nvl(paf.work_at_home, 'N')
4969: from per_all_assignments_f paf
4970: where paf.assignment_id = cp_assignment_id
4971: and p_run_effective_date between paf.effective_start_date
4972: and paf.effective_end_date;
4973:

Line 5692: from per_all_assignments_f paf1

5688: cp_prepay_action_id in number) is
5689: select /*+ ORDERED */
5690: paf1.assignment_id,
5691: paa.assignment_action_id
5692: from per_all_assignments_f paf1
5693: ,pay_assignment_actions paa
5694: ,pay_payroll_actions ppa
5695: where paf1.person_id = (select /*+ PUSH_SUBQ */ person_id
5696: from per_all_assignments_f START_ASS

Line 5696: from per_all_assignments_f START_ASS

5692: from per_all_assignments_f paf1
5693: ,pay_assignment_actions paa
5694: ,pay_payroll_actions ppa
5695: where paf1.person_id = (select /*+ PUSH_SUBQ */ person_id
5696: from per_all_assignments_f START_ASS
5697: where START_ASS.assignment_id = cp_assignment_id
5698: and rownum = 1)
5699: and paf1.effective_end_date >= trunc(cp_effective_date,'Y')
5700: and paf1.effective_start_date <= cp_effective_date