APPS.AR_AUTOREM_API dependencies on HZ_CUST_ACCOUNTS

Line 1334: hz_cust_accounts hca,

1330: FROM ar_rem_cr_id_gtt gtt,
1331: ar_cash_receipts cr,
1332: ar_receipt_methods rm,
1333: ar_receipt_classes rc,
1334: hz_cust_accounts hca,
1335: hz_parties party,
1336: /*ar_remit_gt g,*/
1337: ar_cash_receipt_history crh,
1338: ar_batches bat,

Line 3358: p_customer_number_l IN hz_cust_accounts.account_number%TYPE,

3354: | 06-DEC-2012 riqi Fixed bug 14798599 |
3355: *=========================================================================*/
3356:
3357: PROCEDURE select_update_rec(
3358: p_customer_number_l IN hz_cust_accounts.account_number%TYPE,
3359: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
3360: p_customer_name_l IN hz_parties.party_name%type,
3361: p_customer_name_h IN hz_parties.party_name%type,
3362: p_doc_num_l IN ar_cash_receipts.doc_sequence_value%type,

Line 3359: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,

3355: *=========================================================================*/
3356:
3357: PROCEDURE select_update_rec(
3358: p_customer_number_l IN hz_cust_accounts.account_number%TYPE,
3359: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
3360: p_customer_name_l IN hz_parties.party_name%type,
3361: p_customer_name_h IN hz_parties.party_name%type,
3362: p_doc_num_l IN ar_cash_receipts.doc_sequence_value%type,
3363: p_doc_num_h IN ar_cash_receipts.doc_sequence_value%type,

Line 3564: from hz_cust_accounts rc

3560: IF p_customer_number_l IS NOT NULL OR p_customer_number_h IS NOT NULL THEN
3561:
3562: l_sel_stmt := l_sel_stmt || '
3563: AND EXISTS ( select ''x''
3564: from hz_cust_accounts rc
3565: where rc.cust_account_id = cr.pay_from_customer ' ;
3566:
3567: IF p_customer_number_l IS NOT NULL THEN
3568: l_sel_stmt := l_sel_stmt || ' and rc.account_number >= :customer_number_l ';

Line 3585: from hz_cust_accounts rc, HZ_PARTIES party

3581: IF p_customer_name_l IS NOT NULL OR p_customer_name_h IS NOT NULL THEN
3582:
3583: l_sel_stmt := l_sel_stmt || '
3584: AND EXISTS ( select ''x''
3585: from hz_cust_accounts rc, HZ_PARTIES party
3586: where rc.cust_account_id = cr.pay_from_customer
3587: and rc.party_id = party.party_id ' ;
3588:
3589: IF p_customer_name_l IS NOT NULL THEN

Line 3930: hz_cust_accounts hca,

3926: pr.home_country
3927: FROM ar_cash_receipts cr,
3928: ar_receipt_methods rm,
3929: ar_receipt_classes rc,
3930: hz_cust_accounts hca,
3931: hz_parties party,
3932: ar_remit_gt g,
3933: /* Need to pass country code for SEPA specific receipts */
3934: ce_bank_acct_uses bau,