APPS.JMF_GTA_TRX_UTIL dependencies on HZ_CUST_SITE_USES

Line 1993: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;

1989: l_procedure_name VARCHAR2(30) := 'Get_Bank_Info';
1990:
1991: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
1992:
1993: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
1994: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
1995: l_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
1996: l_error_string VARCHAR2(500);
1997:

Line 2807: l_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;

2803: l_reg_tax_regime_code zx_registrations.tax_regime_code%TYPE;
2804: l_reg_tax zx_registrations.tax%TYPE;
2805: l_reg_tax_jursidiction_code zx_registrations.tax_jurisdiction_code%TYPE;
2806:
2807: l_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
2808: l_party_site_id hz_cust_acct_sites_all.party_site_id%TYPE;
2809:
2810: l_tax_registration_count NUMBER;
2811: l_tax_profile_status NUMBER;

Line 2884: hz_cust_site_uses_all

2880: cust_acct_site_id
2881: INTO
2882: l_cust_acct_site_id
2883: FROM
2884: hz_cust_site_uses_all
2885: WHERE SITE_USE_ID = l_bill_to_site_use_id;
2886:
2887: --get party_site_id by cust_acct_site_id
2888: SELECT