APPS.JMF_GTA_ARTRX_PROC dependencies on HZ_CONTACT_POINTS

Line 2033: l_phone_number Hz_Contact_Points.Phone_Number%TYPE;

2029:
2030: l_raa_bill_to_concat_address VARCHAR2(500);
2031: l_cust_addr_excep VARCHAR2(20); --added by subba for R12.1
2032: l_cust_phone_exp VARCHAR2(20);
2033: l_phone_number Hz_Contact_Points.Phone_Number%TYPE;
2034: l_apb_customer_bank_name CE_Bank_Branches_V.Bank_Name%TYPE;
2035: l_apb_bank_branch_name CE_Bank_Branches_V.Bank_Branch_Name%TYPE;
2036: l_apba_bank_account_num CE_Bank_Accounts.Bank_Account_num%TYPE;
2037: l_apba_bank_account_name CE_Bank_Accounts.Bank_Account_Name%TYPE;

Line 2493: FROM Hz_Contact_Points p,

2489: -- select phone number
2490: BEGIN
2491: SELECT p.phone_number
2492: INTO l_phone_number
2493: FROM Hz_Contact_Points p,
2494: Hz_Cust_Accounts RAC_BILL,
2495: Hz_Parties RAC_BILL_PARTY,
2496: ra_customer_trx_all h
2497: WHERE -- h.bill_to_customer_id can find by customer trx id