APPS.PER_ASG_AGGR dependencies on PER_ALL_PEOPLE_F

Line 42: from per_all_people_f

38: -- Changed the cursor to fecth PAYE agg flag effective end date
39: cursor cur_get_aggr_flag(c_person_id in number,
40: c_effective_date in date) is
41: select per_information10,effective_end_date
42: from per_all_people_f
43: where person_id = c_person_id
44: and c_effective_date between effective_start_date and effective_end_date;
45: -- End of Bug 5671777-9
46:

Line 51: per_all_people_f ppf

47: cursor cur_person_type (c_person_id in number,
48: c_effective_date in date) is
49: select typ.system_person_type
50: from per_person_types typ,
51: per_all_people_f ppf
52: where ppf.person_id = c_person_id
53: and ppf.person_type_id = typ.person_type_id
54: and c_effective_date between
55: ppf.effective_start_date and ppf.effective_end_date;