DBA Data[Home] [Help]

APPS.PER_PJO_BUS dependencies on PER_BUSINESS_GROUPS

Line 30: from per_business_groups pbg

26: -- Declare cursor
27: --
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

Line 97: from per_business_groups pbg

93: -- Declare cursor
94: --
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

Line 1486: from per_business_groups pbg,

1482: --
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(+)