DBA Data[Home] [Help]

APPS.PER_PJO_BUS dependencies on PER_ALL_PEOPLE_F

Line 32: , per_all_people_f ppf

28: cursor csr_sec_grp is
29: select pbg.security_group_id
30: from per_business_groups pbg
31: , per_previous_jobs pjo
32: , per_all_people_f ppf
33: , per_previous_employers pem
34: where pjo.previous_job_id = p_previous_job_id
35: and pbg.business_group_id = ppf.business_group_id
36: and pem.person_id = ppf.person_id

Line 99: , per_all_people_f ppf

95: cursor csr_leg_code is
96: select pbg.legislation_code
97: from per_business_groups pbg
98: , per_previous_jobs pjo
99: , per_all_people_f ppf
100: , per_previous_employers pem
101: where pjo.previous_job_id = p_previous_job_id
102: and ppf.business_group_id = pbg.business_group_id(+)
103: and pem.person_id = ppf.person_id(+)

Line 1487: per_all_people_f ppf,

1483: -- Declare cursor
1484: cursor csr_leg_code is
1485: select pbg.legislation_code
1486: from per_business_groups pbg,
1487: per_all_people_f ppf,
1488: per_previous_employers pem
1489: where pem.previous_employer_id = p_previous_employer_id
1490: and ppf.business_group_id = pbg.business_group_id(+)
1491: and pem.person_id = ppf.person_id(+);