DBA Data[Home] [Help]

APPS.PER_PSH_BUS dependencies on PER_ALL_PEOPLE_F

Line 32: , per_all_people_f ppf

28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , per_scorecard_sharing psh
32: , per_all_people_f ppf
33: where psh.sharing_instance_id = p_sharing_instance_id
34: and psh.person_id = ppf.person_id
35: and ppf.business_group_id = pbg.business_group_id;
36: --

Line 104: , per_all_people_f ppf

100: cursor csr_leg_code is
101: select pbg.legislation_code
102: from per_business_groups_perf pbg
103: , per_scorecard_sharing psh
104: , per_all_people_f ppf
105: where psh.sharing_instance_id = p_sharing_instance_id
106: and psh.person_id = ppf.person_id
107: and ppf.business_group_id = pbg.business_group_id;
108: --

Line 479: from per_all_people_f

475: --
476: Cursor csr_person_valid
477: is
478: select 'Y'
479: from per_all_people_f
480: where person_id = p_person_id
481: and trunc(sysdate) between
482: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
483: --