DBA Data[Home] [Help]

APPS.PER_ROL_BUS dependencies on PER_JOB_GROUPS

Line 361: ,per_job_groups j

357: cursor csr_bg is
358: select p.business_group_id
359: ,j.business_group_id
360: from per_all_people_f p
361: ,per_job_groups j
362: where p.person_id = p_person_id
363: and j.job_group_id = p_job_group_id;
364: --
365: cursor csr_valid_job_group is

Line 367: from per_job_groups

363: and j.job_group_id = p_job_group_id;
364: --
365: cursor csr_valid_job_group is
366: select 'X'
367: from per_job_groups
368: where job_group_id = p_job_group_id
369: and internal_name <> 'HR_'||business_group_id;
370: --
371: cursor csr_job_in_jgr is