APPS.AR_AUTOREC_API dependencies on HZ_CUST_ACCOUNTS

Line 1570: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688

1566: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
1567: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
1568: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
1569: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,
1570: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1571: p_customer_number_h IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1572: p_customer_name_l IN hz_parties.party_name%TYPE, --Bug6734688
1573: p_customer_name_h IN hz_parties.party_name%TYPE, --Bug6734688
1574: p_batch_id IN ar_batches.batch_id%TYPE,

Line 1571: p_customer_number_h IN hz_cust_accounts.account_number%TYPE, --Bug6734688

1567: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
1568: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
1569: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,
1570: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1571: p_customer_number_h IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1572: p_customer_name_l IN hz_parties.party_name%TYPE, --Bug6734688
1573: p_customer_name_h IN hz_parties.party_name%TYPE, --Bug6734688
1574: p_batch_id IN ar_batches.batch_id%TYPE,
1575: p_approve_only_flag IN VARCHAR2 ,--Bug5344405

Line 1699: l_sel_stmt := l_sel_stmt|| ', hz_cust_accounts cust_acct ';

1695:
1696: --Bug6734688
1697: IF p_customer_number_l IS NOT NULL OR p_customer_number_h IS NOT NULL
1698: OR p_customer_name_l IS NOT NULL OR p_customer_name_h IS NOT NULL THEN
1699: l_sel_stmt := l_sel_stmt|| ', hz_cust_accounts cust_acct ';
1700:
1701: IF p_customer_name_l IS NOT NULL OR p_customer_name_h IS NOT NULL THEN
1702: l_sel_stmt := l_sel_stmt|| ', hz_parties party ';
1703: END IF;

Line 3369: hz_cust_accounts hca,

3365: MAX(gt.cust_min_amount) cust_min_amount,
3366: null cash_receipt_id
3367: from ar_receipts_gt gt,
3368: iby_fndcpt_tx_extensions ext,
3369: hz_cust_accounts hca,
3370: ar_payment_schedules ps
3371: where ext.trxn_extension_id = gt.payment_trxn_extension_id
3372: and hca.cust_account_id = gt.paying_customer_id
3373: and ps.payment_schedule_id = gt.payment_schedule_id

Line 3425: from hz_cust_accounts hca,

3421: hca.party_id,
3422: null trx_number,
3423: gt.cust_min_amount,
3424: null cash_receipt_id
3425: from hz_cust_accounts hca,
3426: iby_fndcpt_tx_extensions ext,
3427: ( select paying_customer_id,
3428: payment_instrument,
3429: MIN(payment_trxn_extension_id) payment_trxn_extension_id,

Line 3480: from hz_cust_accounts hca,

3476: hca.party_id,
3477: null trx_number,
3478: gt.cust_min_amount,
3479: null cash_receipt_id
3480: from hz_cust_accounts hca,
3481: iby_fndcpt_tx_extensions ext,
3482: ( select paying_customer_id,
3483: paying_site_use_id,
3484: payment_instrument,

Line 3559: from hz_cust_accounts hca,

3555: hca.party_id,
3556: null trx_number,
3557: gt.cust_min_amount,
3558: null cash_receipt_id
3559: from hz_cust_accounts hca,
3560: iby_fndcpt_tx_extensions ext,
3561: ( select paying_customer_id,
3562: paying_site_use_id,
3563: payment_instrument,

Line 3639: from hz_cust_accounts hca,

3635: hca.party_id,
3636: null trx_number,
3637: gt.cust_min_amount,
3638: null cash_receipt_id
3639: from hz_cust_accounts hca,
3640: iby_fndcpt_tx_extensions ext,
3641: ( select paying_customer_id,
3642: payment_instrument,
3643: due_date,

Line 3676: from hz_cust_accounts hca,

3672: hca.party_id,
3673: null trx_number,
3674: gt.cust_min_amount,
3675: null cash_receipt_id
3676: from hz_cust_accounts hca,
3677: iby_fndcpt_tx_extensions ext,
3678: ( select paying_customer_id,
3679: payment_trxn_extension_id,
3680: sum(amount_due_remaining) amount,

Line 3714: from hz_cust_accounts hca,

3710: hca.party_id,
3711: null trx_number,
3712: gt.cust_min_amount,
3713: null cash_receipt_id
3714: from hz_cust_accounts hca,
3715: iby_fndcpt_tx_extensions ext,
3716: ( select paying_customer_id,
3717: payment_trxn_extension_id,
3718: sum(amount_due_remaining) amount,

Line 3749: from hz_cust_accounts hca,

3745: hca.party_id,
3746: null trx_number,
3747: gt.cust_min_amount,
3748: null cash_receipt_id
3749: from hz_cust_accounts hca,
3750: iby_fndcpt_tx_extensions ext,
3751: ( select paying_customer_id,
3752: payment_trxn_extension_id,
3753: sum(amount_due_remaining) amount,