DBA Data[Home] [Help]

APPS.PE_JEI_BUS dependencies on PER_BUSINESS_GROUPS

Line 28: -- per_job_extra_info and PER_BUSINESS_GROUPS

24: --
25: -- Declare cursor
26: --
27: -- In the following cursor statement add join(s) between
28: -- per_job_extra_info and PER_BUSINESS_GROUPS
29: -- so that the legislation_code for
30: -- the current business group context can be derived.
31: -- Remove this comment when the edit has been completed.
32: cursor csr_leg_code is

Line 34: from per_business_groups pbg

30: -- the current business group context can be derived.
31: -- Remove this comment when the edit has been completed.
32: cursor csr_leg_code is
33: select pbg.legislation_code
34: from per_business_groups pbg
35: , per_job_extra_info jei
36: , per_jobs pj
37: where jei.job_extra_info_id = p_job_extra_info_id
38: and jei.job_id = pj.job_id