APPS.ARP_PROCESS_APPLICATION dependencies on RA_CUST_TRX_TYPES

Line 2345: ra_cust_trx_types ctt

2341: l_over_appln_flag,
2342: l_bal_org
2343: FROM ar_receivable_applications ra,
2344: ar_payment_schedules ps,
2345: ra_cust_trx_types ctt
2346: WHERE ra.receivable_application_id = p_ra_id
2347: AND ps.payment_schedule_id(+) = ra.applied_payment_schedule_id
2348: AND ctt.cust_trx_type_id = ps.cust_trx_type_id;
2349: --

Line 2383: ra_cust_trx_types ctt

2379: l_over_appln_flag,
2380: l_bal_org
2381: FROM ar_receivable_applications ra,
2382: ar_payment_schedules ps,
2383: ra_cust_trx_types ctt
2384: WHERE ra.receivable_application_id = p_ra_id
2385: AND ps.customer_trx_id(+) = ra.application_ref_id
2386: AND ctt.cust_trx_type_id = ps.cust_trx_type_id
2387: AND ra.application_ref_type = 'CHARGEBACK';

Line 3406: from ra_cust_trx_types ctt, ar_payment_schedules ps

3402: the transaction type does not allow overapplication */
3403:
3404: select ps.amount_due_remaining,ps.amount_due_original,ctt.allow_overapplication_flag
3405: into l_inv_bal_amount, l_inv_orig_amount, l_allow_over_application
3406: from ra_cust_trx_types ctt, ar_payment_schedules ps
3407: where ps.payment_schedule_id = p_invoice_ps_id
3408: and ps.cust_trx_type_id = ctt.cust_trx_type_id;
3409:
3410: l_effective_amount_applied := NVL(p_amount_applied,0) +

Line 4481: from ra_cust_trx_types ctt, ar_payment_schedules ps

4477: the transaction type does not allow overapplication */
4478:
4479: select ps.amount_due_remaining,ps.amount_due_original,ctt.allow_overapplication_flag
4480: into l_inv_bal_amount, l_inv_orig_amount, l_allow_over_application
4481: from ra_cust_trx_types ctt, ar_payment_schedules ps
4482: where ps.payment_schedule_id = p_invoice_ps_id
4483: and ps.cust_trx_type_id = ctt.cust_trx_type_id;
4484:
4485: l_effective_amount_applied := NVL(p_amount_applied,0) ;

Line 4585: from ra_cust_trx_types ctt,

4581: /* Added the following code for bug 2318048. If CM is postable then only make
4582: the APP row postable */
4583:
4584: select NVL(ctt.post_to_gl,'N') into l_flag
4585: from ra_cust_trx_types ctt,
4586: ar_payment_schedules ps
4587: where ctt.cust_trx_type_id = ps.cust_trx_type_id
4588: and ps.payment_schedule_id = p_cm_ps_id;
4589:

Line 8332: from ra_cust_trx_types ctt,

8328: l_cm_ps_rec,
8329: 'Y' );
8330:
8331: select NVL(ctt.post_to_gl,'N') into l_flag
8332: from ra_cust_trx_types ctt,
8333: ar_payment_schedules ps
8334: where ctt.cust_trx_type_id = ps.cust_trx_type_id
8335: and ps.payment_schedule_id = p_cm_ps_id;
8336: