1266: SELECT
1267: PARTY.PARTY_NAME
1268: INTO L_END_CUSTOMER
1269: FROM
1270: HZ_PARTIES PARTY,
1271: HZ_CUST_ACCOUNTS CUST_ACCT
1272: WHERE cust_acct.cust_account_id (+) = END_CUSTOMER_ID
1273: AND CUST_ACCT.PARTY_ID = party.party_id (+);
1274: RETURN (L_END_CUSTOMER);
1406: SELECT
1407: PARTY.PARTY_NUMBER
1408: INTO L_END_CUSTOMER
1409: FROM
1410: HZ_PARTIES PARTY,
1411: HZ_CUST_ACCOUNTS CUST_ACCT
1412: WHERE cust_acct.cust_account_id (+) = END_CUSTOMER_ID
1413: AND CUST_ACCT.PARTY_ID = party.party_id (+);
1414: RETURN (L_END_CUSTOMER);
1810: SELECT
1811: PARTY.PARTY_NAME
1812: INTO L_END_CUSTOMER
1813: FROM
1814: HZ_PARTIES PARTY,
1815: HZ_CUST_ACCOUNTS CUST_ACCT
1816: WHERE cust_acct.cust_account_id (+) = END_CUSTOMER_ID
1817: AND CUST_ACCT.PARTY_ID = party.party_id (+);
1818: RETURN (L_END_CUSTOMER);