APPS.ARP_PROCESS_CHARGEBACK dependencies on AR_RECEIVABLE_APPLICATIONS

Line 379: FROM ar_receivable_applications ra

375: arp_standard.debug('before BEGIN SELECT NVL in app_delete' );
376: END IF;
377: SELECT NVL( sum( ra.amount_applied), 0 )
378: INTO l_sum
379: FROM ar_receivable_applications ra
380: WHERE ra.applied_customer_trx_id in (
381: SELECT a.chargeback_customer_trx_id
382: FROM ar_adjustments b,
383: ar_adjustments a

Line 540: FROM ar_receivable_applications

536: arp_standard.debug( 'inside BEGIN SELECT NVL in app_delete' );
537: END IF;
538: SELECT NVL( sum( amount_applied), 0 )
539: INTO l_sum
540: FROM ar_receivable_applications
541: WHERE applied_customer_trx_id = p_ct_id;
542: --
543: EXCEPTION
544: WHEN NO_DATA_FOUND THEN

Line 976: p_app_rec IN OUT NOCOPY AR_RECEIVABLE_APPLICATIONS%ROWTYPE) IS

972: 4/2/1996 Harri Kaukovuo Created
973: ===========================================================================
974: */
975: PROCEDURE init_app_struct (
976: p_app_rec IN OUT NOCOPY AR_RECEIVABLE_APPLICATIONS%ROWTYPE) IS
977: BEGIN
978: IF PG_DEBUG in ('Y', 'C') THEN
979: arp_standard.debug ('arp_process_chargeback.init_app_struct()+');
980: END IF;

Line 1240: l_cr_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;

1236: error_defaulting_gl_date EXCEPTION;
1237: l_receivables_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
1238: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1239: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1240: l_cr_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
1241: l_inv_rec_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1242: l_id_dummy ar_receivable_applications.code_combination_id%TYPE;
1243: l_bill_to_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1244: l_cb_activity_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;

Line 1242: l_id_dummy ar_receivable_applications.code_combination_id%TYPE;

1238: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1239: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1240: l_cr_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
1241: l_inv_rec_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1242: l_id_dummy ar_receivable_applications.code_combination_id%TYPE;
1243: l_bill_to_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1244: l_cb_activity_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1245: l_actual_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1246: --Bug2979254