APPS.HR_JOB_API dependencies on PER_JOB_GROUPS

Line 364: from per_job_groups pjg

360: --
361: -- bug 2436606 Use job_group job KFF structure
362: cursor idsel is
363: select pjg.ID_FLEX_NUM
364: from per_job_groups pjg
365: where pjg.job_group_id = p_job_group_id;
366:
367: --
368: --

Line 1038: from per_job_groups pjg

1034: -- bug 2436606 Use job_group job KFF structure
1035: --
1036: cursor idsel is
1037: select pjg.ID_FLEX_NUM
1038: from per_job_groups pjg
1039: where pjg.JOB_GROUP_ID = (select job_group_id
1040: from per_jobs
1041: where JOB_ID = p_job_id);
1042:

Line 1768: from per_job_groups_v

1764: l_struct varchar2(30);
1765: l_proc varchar2(72) := g_package||'get_job_flex_structure';
1766: --
1767: cursor csr_job is select to_char(id_flex_num)
1768: from per_job_groups_v
1769: where p_job_group_id = job_group_id;
1770: --
1771: v_not_found boolean := FALSE;
1772: --