APPS.JMF_GTA_TRX_UTIL dependencies on HZ_CUST_ACCOUNTS

Line 1451: hz_cust_accounts_all

1447: AND hcp.owner_table_name = 'HZ_PARTIES'
1448: AND hcp.owner_table_id = (SELECT
1449: party_id
1450: FROM
1451: hz_cust_accounts_all
1452: WHERE cust_account_id=l_customer_id
1453: )
1454: AND hcp.primary_flag = 'Y';
1455:

Line 1584: ,hz_cust_accounts a

1580: SELECT
1581: p.party_name
1582: FROM
1583: hz_parties p
1584: ,hz_cust_accounts a
1585: WHERE a.cust_account_id = p_customer_id
1586: AND p.party_id = a.party_id;
1587:
1588: BEGIN

Line 2001: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;

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;
2005: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;

Line 2158: HZ_CUST_ACCOUNTS

2154: party_id
2155: INTO
2156: l_paying_party_id
2157: FROM
2158: HZ_CUST_ACCOUNTS
2159: WHERE
2160: CUST_ACCOUNT_ID = l_paying_customer_id ;
2161:
2162: -- get ext_payer_id by party id , site account id , site use id and org id.