DBA Data[Home] [Help]

APPS.ONT_OEXOECOD_XMLP_PKG dependencies on HZ_CUST_ACCOUNTS

Line 1275: HZ_CUST_ACCOUNTS CUST_ACCT

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);
1279: ELSE

Line 1415: HZ_CUST_ACCOUNTS CUST_ACCT

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);
1419: ELSE

Line 1819: HZ_CUST_ACCOUNTS CUST_ACCT

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);
1823: ELSE