APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on HZ_CONTACT_POINTS

Line 3561: l_phone_num Hz_Contact_Points.Phone_Number%TYPE;

3557: l_customer_name_phonetic HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3558: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
3559: l_alternate_name HZ_PARTIES.ORGANIZATION_NAME_PHONETIC%TYPE;
3560:
3561: l_phone_num Hz_Contact_Points.Phone_Number%TYPE;
3562: l_currency_code AR_GTA_SYSTEM_PARAMETERS_ALL.Gt_Currency_Code%TYPE;
3563: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NAME%TYPE;
3564: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;
3565: l_address AR_ADDRESSES_V.concatenated_address%TYPE;

Line 3940: Hz_Contact_Points

3936: phone_number
3937: INTO
3938: l_phone_num
3939: FROM
3940: Hz_Contact_Points
3941: WHERE owner_table_name='HZ_PARTY_SITES'
3942: AND owner_table_id=l_party_site_id
3943: AND phone_line_type='GEN'
3944: AND primary_flag='Y'