APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on HZ_PARTY_SITES

Line 3568: l_party_site_id hz_party_sites.party_site_id%TYPE;

3564: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;
3565: l_address AR_ADDRESSES_V.concatenated_address%TYPE;
3566: l_address_phonenumber AR_ADDRESSES_V.concatenated_address%TYPE;
3567:
3568: l_party_site_id hz_party_sites.party_site_id%TYPE;
3569: l_customer_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
3570: l_customer_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
3571:
3572: -- modified by allen yang 17/Jun/2009 for bug 8605196 to display bank info in Chinese

Line 3909: , hz_party_sites party_site

3905: , l_party_site_id
3906: FROM
3907: hz_cust_site_uses_all hcsua
3908: , hz_cust_acct_sites_all addr
3909: , hz_party_sites party_site
3910: , hz_locations loc
3911: , fnd_territories_tl terr
3912: WHERE addr.party_site_id = party_site.party_site_id
3913: AND loc.location_id = party_site.location_id

Line 3941: WHERE owner_table_name='HZ_PARTY_SITES'

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'
3945: AND status = 'A'