APPS.PY_GB_ASG dependencies on PER_ALL_ASSIGNMENTS_F

Line 13: from per_all_assignments_f

9: --
10: -- Use sysdate to get single datetrack row.
11: cursor csr_person_details (c_assignment_id in number) is
12: select person_id
13: from per_all_assignments_f
14: where assignment_id = c_assignment_id
15: and sysdate between
16: effective_start_date and effective_end_date;
17: --

Line 70: from per_all_assignments_f paf

66: --
67: cursor csr_multi_assignments (c_person_id in number,
68: c_effective_date in date) is
69: select count(paf.assignment_id)
70: from per_all_assignments_f paf
71: where person_id = c_person_id
72: and c_effective_date between
73: paf.effective_start_date and paf.effective_end_date;
74: --