APPS.ONT_OEXCEXP_XMLP_PKG dependencies on HZ_HIERARCHY_NODES
Line 314: HZ_HIERARCHY_NODES A
310: SELECT
311: A.PARENT_ID
312: INTO L_TOP_PARENT
313: FROM 314: HZ_HIERARCHY_NODES A 315: WHERE A.TOP_PARENT_FLAG = 'Y'
316: AND A.HIERARCHY_TYPE = L_REL_TYPE
317: AND A.CHILD_ID IN (
318: SELECT
Line 321: HZ_HIERARCHY_NODES B
317: AND A.CHILD_ID IN (
318: SELECT
319: B.PARENT_ID
320: FROM 321: HZ_HIERARCHY_NODES B 322: WHERE B.HIERARCHY_TYPE = L_REL_TYPE
323: AND B.CHILD_ID = NVL(P_SPECIFIC_PARTY_ID
324: ,P_SPEC_PARTY_NUM_ID) );
325: INSERT INTO OE_CREDIT_HIERARCHY_TEMP