[Home] [Help]
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:
1998: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
1996: l_error_string VARCHAR2(500);
1997:
1998: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
1999: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;
2000: l_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2001: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
2002: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
2003: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
2004: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%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:
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)