APPS.PAY_US_ACTION_ARCH dependencies on PER_ALL_ASSIGNMENTS_F

Line 3348: ,per_all_assignments_f assign

3344: select nvl(ADDR.add_information19,ADDR.region_1),
3345: nvl(ADDR.add_information17,ADDR.region_2),
3346: nvl(addr.add_information18,addr.town_or_city)
3347: from per_addresses addr
3348: ,per_all_assignments_f assign
3349: where cp_run_effective_date between assign.effective_start_date
3350: and assign.effective_end_date
3351: and assign.assignment_id = cp_assignment_id
3352: and addr.person_id = assign.person_id

Line 5871: (select person_id from per_all_assignments_f paf

5867: upper(substr(middle_names,1,1)) || '. ' ) ||
5868: pre_name_adjunct || last_name || ' '|| suffix))
5869: from per_all_people_f ppf
5870: where ppf.person_id =
5871: (select person_id from per_all_assignments_f paf
5872: where assignment_id = cp_assignment_id
5873: and cp_effective_date between paf.effective_start_date
5874: and paf.effective_end_date)
5875: and cp_effective_date between ppf.effective_start_date

Line 5967: from per_all_assignments_f paf

5963:
5964: cursor c_get_asg_work_at_home (cp_assignment_id in number
5965: ,p_run_effective_date in date) is
5966: select nvl(paf.work_at_home, 'N')
5967: from per_all_assignments_f paf
5968: where paf.assignment_id = cp_assignment_id
5969: and p_run_effective_date between paf.effective_start_date
5970: and paf.effective_end_date;
5971:

Line 7752: from per_all_assignments_f paf1

7748: cp_prepay_action_id in number) is
7749: select /*+ ORDERED */
7750: paf1.assignment_id,
7751: paa.assignment_action_id
7752: from per_all_assignments_f paf1
7753: ,pay_assignment_actions paa
7754: ,pay_payroll_actions ppa
7755: where paf1.person_id = (select /*+ PUSH_SUBQ */ person_id
7756: from per_all_assignments_f START_ASS

Line 7756: from per_all_assignments_f START_ASS

7752: from per_all_assignments_f paf1
7753: ,pay_assignment_actions paa
7754: ,pay_payroll_actions ppa
7755: where paf1.person_id = (select /*+ PUSH_SUBQ */ person_id
7756: from per_all_assignments_f START_ASS
7757: where START_ASS.assignment_id = cp_assignment_id
7758: and rownum = 1)
7759: and paf1.effective_end_date >= trunc(cp_effective_date,'Y')
7760: and paf1.effective_start_date <= cp_effective_date