APPS.ONT_OEXOECOD_XMLP_PKG dependencies on HZ_PARTIES

Line 1274: HZ_PARTIES PARTY,

1270: SELECT
1271: PARTY.PARTY_NAME
1272: INTO L_END_CUSTOMER
1273: FROM
1274: HZ_PARTIES PARTY,
1275: HZ_CUST_ACCOUNTS CUST_ACCT
1276: WHERE cust_acct.cust_account_id (+) = END_CUSTOMER_ID
1277: AND CUST_ACCT.PARTY_ID = party.party_id (+);
1278: RETURN (L_END_CUSTOMER);

Line 1414: HZ_PARTIES PARTY,

1410: SELECT
1411: PARTY.PARTY_NUMBER
1412: INTO L_END_CUSTOMER
1413: FROM
1414: HZ_PARTIES PARTY,
1415: HZ_CUST_ACCOUNTS CUST_ACCT
1416: WHERE cust_acct.cust_account_id (+) = END_CUSTOMER_ID
1417: AND CUST_ACCT.PARTY_ID = party.party_id (+);
1418: RETURN (L_END_CUSTOMER);

Line 1818: HZ_PARTIES PARTY,

1814: SELECT
1815: PARTY.PARTY_NAME
1816: INTO L_END_CUSTOMER
1817: FROM
1818: HZ_PARTIES PARTY,
1819: HZ_CUST_ACCOUNTS CUST_ACCT
1820: WHERE cust_acct.cust_account_id (+) = END_CUSTOMER_ID
1821: AND CUST_ACCT.PARTY_ID = party.party_id (+);
1822: RETURN (L_END_CUSTOMER);