APPS.AR_GTA_TRX_UTIL dependencies on HZ_CUST_ACCOUNTS

Line 241: Hz_Cust_Accounts RAC_BILL,

237: SELECT HCA.CLASS_CODE
238: INTO l_class_code
239: FROM ra_customer_trx_all h,
240: Hz_Parties RAC_BILL_PARTY,
241: Hz_Cust_Accounts RAC_BILL,
242: zx_party_tax_profile ZPTP,
243: hz_code_assignments HCA
244: WHERE h.bill_to_customer_id = RAC_BILL.CUST_ACCOUNT_ID
245: AND rac_bill.party_id = RAC_BILL_PARTY.Party_Id

Line 1658: hz_cust_accounts_all

1654: AND hcp.owner_table_name = 'HZ_PARTIES'
1655: AND hcp.owner_table_id = (SELECT
1656: party_id
1657: FROM
1658: hz_cust_accounts_all
1659: WHERE cust_account_id=l_customer_id
1660: )
1661: AND hcp.primary_flag = 'Y';
1662:

Line 1791: ,hz_cust_accounts a

1787: SELECT
1788: p.party_name
1789: FROM
1790: hz_parties p
1791: ,hz_cust_accounts a
1792: WHERE a.cust_account_id = p_customer_id
1793: AND p.party_id = a.party_id;
1794:
1795: BEGIN

Line 2214: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;

2210:
2211: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
2212: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;
2213: l_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2214: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
2215: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
2216: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
2217: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
2218: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;

Line 2404: HZ_CUST_ACCOUNTS

2400: party_id
2401: INTO
2402: l_paying_party_id
2403: FROM
2404: HZ_CUST_ACCOUNTS
2405: WHERE
2406: CUST_ACCOUNT_ID = l_valid_customer_id ;--Yao Zhang modified for bug#8404856
2407:
2408: -- get ext_payer_id by party id , site account id , site use id and org id.

Line 2568: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;

2564:
2565: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
2566: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;
2567: l_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2568: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
2569: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
2570: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
2571: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
2572: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;

Line 2869: HZ_CUST_ACCOUNTS

2865: party_id
2866: INTO
2867: l_paying_party_id
2868: FROM
2869: HZ_CUST_ACCOUNTS
2870: WHERE
2871: CUST_ACCOUNT_ID = l_valid_customer_id ;--Yao Zhang modified for bug#8404856
2872: -- get ext_payer_id by party id , site account id , site use id and org id.
2873: SELECT

Line 3532: l_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;

3528: l_reg_tax_jursidiction_code zx_registrations.tax_jurisdiction_code%TYPE;
3529:
3530: l_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
3531: l_party_site_id hz_cust_acct_sites_all.party_site_id%TYPE;
3532: l_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
3533:
3534: l_tax_registration_count NUMBER;
3535: l_tax_profile_status NUMBER;
3536:

Line 3809: FROM HZ_CUST_ACCOUNTS acct, hz_cust_acct_sites_all acct_site

3805: THEN
3806: BEGIN
3807: SELECT party_id
3808: INTO l_party_id
3809: FROM HZ_CUST_ACCOUNTS acct, hz_cust_acct_sites_all acct_site
3810: WHERE acct.CUST_ACCount_ID = acct_site.CUST_ACCount_ID
3811: AND acct_site.party_site_id = l_party_site_id;
3812:
3813: SELECT reg.registration_number,