APPS.AR_GTA_ARTRX_PROC dependencies on HZ_CONTACT_POINTS

Line 2090: l_phone_number Hz_Contact_Points.Phone_Number%TYPE;

2086:
2087: l_raa_bill_to_concat_address VARCHAR2(500);
2088: l_cust_addr_excep VARCHAR2(20); --added by subba for R12.1
2089: l_cust_phone_exp VARCHAR2(20);
2090: l_phone_number Hz_Contact_Points.Phone_Number%TYPE;
2091: l_apb_customer_bank_name CE_Bank_Branches_V.Bank_Name%TYPE;
2092: l_apb_bank_branch_name CE_Bank_Branches_V.Bank_Branch_Name%TYPE;
2093:
2094: -- Start bug 12589431, change the bank account num and name from CE_BANK_ACCOUNTS column type

Line 2594: FROM Hz_Contact_Points p

2590: -- select phone number
2591: BEGIN
2592: SELECT p.phone_number
2593: INTO l_phone_number
2594: FROM Hz_Contact_Points p
2595: --Yao delete for bug#8769687 begin
2596: --,Hz_Cust_Accounts RAC_BILL
2597: --,Hz_Parties RAC_BILL_PARTY
2598: --Yao delete end for bug#8769687