DBA Data[Home] [Help]

APPS.JMF_GTA_TRX_UTIL dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2808: l_party_site_id hz_cust_acct_sites_all.party_site_id%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;
2812:

Line 2893: hz_cust_acct_sites_all

2889: party_site_id
2890: INTO
2891: l_party_site_id
2892: FROM
2893: hz_cust_acct_sites_all
2894: WHERE cust_acct_site_id = l_cust_acct_site_id;
2895: EXCEPTION
2896: WHEN no_data_found THEN
2897: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)