DBA Data[Home] [Help]

APPS.PER_JGR_BUS dependencies on FND_ID_FLEX_STRUCTURES_VL

Line 426: -- Validates that the job structure is valid in the fnd_id_flex_structures_vl table.

422: -- ---------------------------------------------------------------------------
423: --
424: -- Description:
425: --
426: -- Validates that the job structure is valid in the fnd_id_flex_structures_vl table.
427: --
428: -- Pre-requisites:
429: -- None
430: --

Line 435: -- Where the job structure exists in fnd_id_flex_structures_vl processing

431: -- In parameters:
432: -- p_id_flex_num
433: --
434: -- Post Success:
435: -- Where the job structure exists in fnd_id_flex_structures_vl processing
436: -- continues.
437: --
438: -- Post Failure:
439: -- An application error is raised and processing is terminated if id_flex_num

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: --