DBA Data[Home] [Help]

APPS.INV_INVSTMVT_XMLP_PKG dependencies on HZ_CUST_ACCOUNTS

Line 613: HZ_CUST_ACCOUNTS HCA

609: HP.PARTY_NAME
610: INTO L_TRADER_NAME
611: FROM
612: HZ_PARTIES HP,
613: HZ_CUST_ACCOUNTS HCA
614: WHERE HP.PARTY_ID = HCA.PARTY_ID
615: AND HCA.CUST_ACCOUNT_ID = C_SHIP_TO_CUSTOMER_ID;
616: EXCEPTION
617: WHEN NO_DATA_FOUND THEN

Line 707: HZ_CUST_ACCOUNTS HCA

703: HCA.ACCOUNT_NUMBER
704: INTO L_TRADER_NUMBER
705: FROM
706: HZ_PARTIES HP,
707: HZ_CUST_ACCOUNTS HCA
708: WHERE HP.PARTY_ID = HCA.PARTY_ID
709: AND HCA.CUST_ACCOUNT_ID = C_SHIP_TO_CUSTOMER_ID;
710: EXCEPTION
711: WHEN NO_DATA_FOUND THEN