APPS.HR_ORD_BUS dependencies on HR_DE_ORG_LINK_TYPES_MAPPING

Line 274: -- HR_DE_ORG_LINK_TYPES_MAPPING table.

270: -- 1. It is mandatory.
271: -- 2. It belongs to the business group.
272: -- 3. It exists at the effective date.
273: -- 4. It is classified correctly according to the rules held in the
274: -- HR_DE_ORG_LINK_TYPES_MAPPING table.
275: --
276: -- Pre-conditions:
277: -- None
278: --

Line 308: ,hr_de_org_link_types_mapping map

304: (p_organization_id in number
305: ,p_org_link_type in varchar2) is
306: select organization_id
307: from hr_organization_information inf
308: ,hr_de_org_link_types_mapping map
309: where inf.organization_id = p_organization_id
310: and inf.org_information_context = 'CLASS'
311: and inf.org_information2 = 'Y'
312: and inf.org_information1 = map.org_class

Line 354: -- table HR_DE_ORG_LINK_TYPES_MAPPING and it is currently enabled.

350: hr_utility.set_location(l_proc, 30);
351: --
352: --
353: -- Check that the organization is classified correctly as per the rules held in the
354: -- table HR_DE_ORG_LINK_TYPES_MAPPING and it is currently enabled.
355: --
356: open c_valid_org_class
357: (p_organization_id => p_child_organization_id
358: ,p_org_link_type => p_org_link_type);