DBA Data[Home] [Help]

APPS.PER_JBT_BUS dependencies on PER_JOBS

Line 31: , per_jobs_tl jbt

27: --
28: cursor csr_sec_grp is
29: select pbg.security_group_id
30: from per_business_groups pbg
31: , per_jobs_tl jbt
32: , per_jobs job
33: where jbt.job_id = p_job_id
34: and jbt.job_id = job.job_id
35: and pbg.business_group_id = job.business_group_id;

Line 32: , per_jobs job

28: cursor csr_sec_grp is
29: select pbg.security_group_id
30: from per_business_groups pbg
31: , per_jobs_tl jbt
32: , per_jobs job
33: where jbt.job_id = p_job_id
34: and jbt.job_id = job.job_id
35: and pbg.business_group_id = job.business_group_id;
36: --

Line 99: , per_jobs_tl jbt

95: --
96: cursor csr_leg_code is
97: select pbg.legislation_code
98: from per_business_groups pbg
99: , per_jobs_tl jbt
100: , per_jobs job
101: where jbt.job_id = p_job_id
102: and jbt.job_id = job.job_id
103: and pbg.business_group_id = job.business_group_id;

Line 100: , per_jobs job

96: cursor csr_leg_code is
97: select pbg.legislation_code
98: from per_business_groups pbg
99: , per_jobs_tl jbt
100: , per_jobs job
101: where jbt.job_id = p_job_id
102: and jbt.job_id = job.job_id
103: and pbg.business_group_id = job.business_group_id;
104: --