DBA Data[Home] [Help]

APPS.JMF_GTA_TRX_UTIL dependencies on HZ_CUST_SITE_USES_ALL

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