APPS.INV_INVSTMVT_XMLP_PKG dependencies on HZ_PARTIES

Line 612: HZ_PARTIES HP,

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

Line 706: HZ_PARTIES HP,

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