APPS.ARP_CMREQ_WF dependencies on HZ_PARTIES

Line 783: hz_parties party,

779: into p_bill_to_site_use_id, p_customer_id,
780: p_bill_to_customer_name, p_bill_to_customer_number,
781: p_trx_number
782: from hz_cust_accounts bill_to_cust,
783: hz_parties party,
784: ra_customer_trx rct
785: where rct.customer_trx_id = p_customer_trx_id
786: and rct.bill_to_customer_id = bill_to_cust.cust_account_id
787: and bill_to_cust.party_id = party.party_id ;

Line 810: hz_parties party,

806: ship_to_cust.account_number
807: into p_ship_to_customer_name,
808: p_ship_to_customer_number
809: from hz_cust_accounts ship_to_cust,
810: hz_parties party,
811: ra_customer_trx rct
812: where rct.customer_trx_id = p_customer_trx_id
813: and rct.ship_to_customer_id = ship_to_cust.cust_account_id
814: and ship_to_cust.party_id = party.party_id;