APPS.INV_INVSTMVT_XMLP_PKG dependencies on HZ_PARTIES

Line 616: HZ_PARTIES HP,

612: SELECT
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

Line 710: HZ_PARTIES HP,

706: SELECT
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