APPS.PER_JGR_BUS dependencies on HR_ORGANIZATION_INFORMATION

Line 382: from hr_organization_information

378: and internal_name = 'HR_'||to_char(business_group_id);
379: --
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: --

Line 452: from fnd_id_flex_structures_vl fnd, hr_organization_information hoi

448: l_job_structure varchar2(30);
449: --
450: cursor csr_job_structure is
451: select 'X'
452: from fnd_id_flex_structures_vl fnd, hr_organization_information hoi
453: where fnd.id_flex_code = 'JOB'
454: and hoi.org_information_context = 'Business Group Information'
455: and fnd.id_flex_num = p_id_flex_num;
456: --