DBA Data[Home] [Help]

APPS.PQH_RNK_BUS dependencies on PER_ALL_PEOPLE_F

Line 32: , per_all_people_f per

28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , pqh_rank_processes rnk
32: , per_all_people_f per
33: where rnk.rank_process_id = p_rank_process_id
34: and rnk.person_id = per.person_id
35: and pbg.business_group_id = per.business_group_id
36: and rnk.process_date between per.effective_start_date and per.effective_end_date;

Line 105: , per_all_people_f per

101: cursor csr_leg_code is
102: select pbg.legislation_code
103: from per_business_groups_perf pbg
104: , pqh_rank_processes rnk
105: , per_all_people_f per
106: where rnk.rank_process_id = p_rank_process_id
107: and rnk.person_id = per.person_id
108: and pbg.business_group_id = per.business_group_id
109: and rnk.process_date between per.effective_start_date and per.effective_end_date;