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