APPS.PER_JGR_BUS dependencies on PER_JOB_GROUPS

Line 29: , per_job_groups jgr

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , per_job_groups jgr
30: where jgr.job_group_id = p_job_group_id
31: and pbg.business_group_id = jgr.business_group_id;
32: --
33: -- Declare local variables

Line 125: from per_job_groups

121: l_job_Group_id number;
122: --
123: cursor csr_int_name_exists is
124: select internal_name
125: from per_job_groups
126: where business_group_id = p_business_group_id
127: and internal_name = p_internal_name
128: and job_group_id <> nvl(p_job_group_id,-999);
129: --

Line 132: from per_job_groups

128: and job_group_id <> nvl(p_job_group_id,-999);
129: --
130: cursor csr_disp_name_exists is
131: select displayed_name
132: from per_job_groups
133: where business_group_id = p_business_group_id
134: and displayed_name = p_displayed_name
135: and job_group_id <> nvl(p_job_group_id,-999);
136: --

Line 139: from per_job_groups

135: and job_group_id <> nvl(p_job_group_id,-999);
136: --
137: cursor csr_int_name_no_bg is
138: select internal_name
139: from per_job_groups
140: where internal_name = p_internal_name
141: and job_group_id <> nvl(p_job_group_id,-999);
142: --
143: cursor csr_disp_name_no_bg is

Line 145: from per_job_groups

141: and job_group_id <> nvl(p_job_group_id,-999);
142: --
143: cursor csr_disp_name_no_bg is
144: select displayed_name
145: from per_job_groups
146: where displayed_name = p_displayed_name
147: and job_group_id <> nvl(p_job_group_id,-999);
148: --
149: begin

Line 237: from per_job_groups

233: ) is
234: --
235: cursor csr_master_flag_bg is
236: select master_flag
237: from per_job_groups
238: where p_business_group_id = business_group_id
239: and job_group_id <> p_job_group_id -- bug fix 3879133
240: and master_flag = 'Y';
241: --

Line 244: from per_job_groups

240: and master_flag = 'Y';
241: --
242: cursor csr_master_flag_no_bg is
243: select master_flag
244: from per_job_groups
245: where master_flag = 'Y'
246: and job_group_id <> p_job_group_id; -- bug fix 3879133.
247: --
248: l_flag_bg varchar2(1);

Line 317: p_object_version_number in per_job_groups.object_version_number%TYPE

313: --
314: -- ---------------------------------------------------------------------------
315: procedure chk_object_version_number
316: (
317: p_object_version_number in per_job_groups.object_version_number%TYPE
318: ) is
319: --
320: l_proc varchar2(72) := g_package||'chk_object_version_number';
321: --

Line 376: from per_job_groups

372: where job_group_id = p_job_group_id;
373: --
374: cursor csr_hr_jobgroup is
375: select 'Y'
376: from per_job_groups
377: where job_group_id = p_job_group_id
378: and internal_name = 'HR_'||to_char(business_group_id);
379: --
380: cursor csr_rep_body is

Line 384: (select to_char(job_group_id) from per_job_groups

380: cursor csr_rep_body is
381: select 'X'
382: from hr_organization_information
383: where org_information1 in
384: (select to_char(job_group_id) from per_job_groups
385: where job_group_id = p_job_group_id);
386: --
387: l_jobs_exist varchar2(30);
388: l_hr_jobgroup varchar2(30);

Line 491: , per_job_groups jgr

487: --
488: cursor csr_leg_code is
489: select pbg.legislation_code
490: from per_business_groups pbg
491: , per_job_groups jgr
492: where jgr.job_group_id = p_job_group_id
493: and pbg.business_group_id = jgr.business_group_id;
494: --
495: -- Declare local variables