DBA Data[Home] [Help]

APPS.INV_INVSTMVT_XMLP_PKG dependencies on HZ_CUST_ACCOUNTS

Line 617: HZ_CUST_ACCOUNTS HCA

613: HP.PARTY_NAME
614: INTO L_TRADER_NAME
615: FROM
616: HZ_PARTIES HP,
617: HZ_CUST_ACCOUNTS HCA
618: WHERE HP.PARTY_ID = HCA.PARTY_ID
619: AND HCA.CUST_ACCOUNT_ID = C_SHIP_TO_CUSTOMER_ID;
620: EXCEPTION
621: WHEN NO_DATA_FOUND THEN

Line 711: HZ_CUST_ACCOUNTS HCA

707: HCA.ACCOUNT_NUMBER
708: INTO L_TRADER_NUMBER
709: FROM
710: HZ_PARTIES HP,
711: HZ_CUST_ACCOUNTS HCA
712: WHERE HP.PARTY_ID = HCA.PARTY_ID
713: AND HCA.CUST_ACCOUNT_ID = C_SHIP_TO_CUSTOMER_ID;
714: EXCEPTION
715: WHEN NO_DATA_FOUND THEN