APPS.HR_ORGANIZATION_API dependencies on HR_ORG_INFO_TYPES_BY_CLASS

Line 2223: -- HR_ORG_INFO_TYPES_BY_CLASS table.

2219: -- ----------------------------------------------------------------------------
2220: --
2221: -- Description:
2222: -- Validates that classification does not have mandatory info types in
2223: -- HR_ORG_INFO_TYPES_BY_CLASS table.
2224: --
2225: -- Pre-conditions:
2226: -- None.
2227: --

Line 2285: FROM hr_org_info_types_by_class class,

2281: INTO l_exists
2282: FROM sys.dual
2283: WHERE EXISTS
2284: (SELECT null
2285: FROM hr_org_info_types_by_class class,
2286: hr_org_information_types type
2287: WHERE class.org_classification = p_org_classif_code
2288: AND class.org_information_type = type.org_information_type
2289: AND ( type.legislation_code is null

Line 2460: -- HR_ORG_INFO_TYPES_BY_CLASS table.

2456: -- ----------------------------------------------------------------------------
2457: --
2458: -- Description:
2459: -- Validates that classification does not have mandatory info types in
2460: -- HR_ORG_INFO_TYPES_BY_CLASS table.
2461: --
2462: -- Pre-conditions:
2463: -- None.
2464: --