APPS.AR_AUTOREM_API dependencies on HZ_CUST_ACCOUNTS

Line 1270: hz_cust_accounts hca,

1266: FROM ar_rem_cr_id_gtt gtt,
1267: ar_cash_receipts cr,
1268: ar_receipt_methods rm,
1269: ar_receipt_classes rc,
1270: hz_cust_accounts hca,
1271: hz_parties party,
1272: /*ar_remit_gt g,*/
1273: ar_cash_receipt_history crh,
1274: ar_batches bat,

Line 3280: p_customer_number_l IN hz_cust_accounts.account_number%TYPE,

3276: | 16-JUL-2005 bichatte Created |
3277: *=========================================================================*/
3278:
3279: PROCEDURE select_update_rec(
3280: p_customer_number_l IN hz_cust_accounts.account_number%TYPE,
3281: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
3282: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
3283: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
3284: p_due_date_l IN ar_payment_schedules.due_date%TYPE,

Line 3281: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,

3277: *=========================================================================*/
3278:
3279: PROCEDURE select_update_rec(
3280: p_customer_number_l IN hz_cust_accounts.account_number%TYPE,
3281: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
3282: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
3283: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
3284: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
3285: p_due_date_h IN ar_payment_schedules.due_date%TYPE,

Line 3437: from hz_cust_accounts rc

3433: IF p_customer_number_l IS NOT NULL OR p_customer_number_h IS NOT NULL THEN
3434:
3435: l_sel_stmt := l_sel_stmt || '
3436: AND EXISTS ( select ''x''
3437: from hz_cust_accounts rc
3438: where rc.cust_account_id = cr.pay_from_customer ' ;
3439:
3440: IF p_customer_number_l IS NOT NULL THEN
3441: l_sel_stmt := l_sel_stmt || ' and rc.account_number >= :customer_number_l ';

Line 3645: hz_cust_accounts hca,

3641: cr.receipt_date
3642: FROM ar_cash_receipts cr,
3643: ar_receipt_methods rm,
3644: ar_receipt_classes rc,
3645: hz_cust_accounts hca,
3646: hz_parties party,
3647: ar_remit_gt g
3648: WHERE cr.selected_remittance_batch_id = p_batch_id
3649: AND g.cash_receipt_id = cr.cash_receipt_id