APPS.ARP_PROCESS_APPLICATION dependencies on RA_CUST_TRX_TYPES

Line 2433: ra_cust_trx_types ctt

2429: l_over_appln_flag,
2430: l_bal_org
2431: FROM ar_receivable_applications ra,
2432: ar_payment_schedules ps,
2433: ra_cust_trx_types ctt
2434: WHERE ra.receivable_application_id = p_ra_id
2435: AND ps.payment_schedule_id(+) = ra.applied_payment_schedule_id
2436: AND ctt.cust_trx_type_id = ps.cust_trx_type_id;
2437: --

Line 2471: ra_cust_trx_types ctt

2467: l_over_appln_flag,
2468: l_bal_org
2469: FROM ar_receivable_applications ra,
2470: ar_payment_schedules ps,
2471: ra_cust_trx_types ctt
2472: WHERE ra.receivable_application_id = p_ra_id
2473: AND ps.customer_trx_id(+) = ra.application_ref_id
2474: AND ctt.cust_trx_type_id = ps.cust_trx_type_id
2475: AND ra.application_ref_type = 'CHARGEBACK';

Line 3532: from ra_cust_trx_types ctt, ar_payment_schedules ps

3528:
3529: ELSE
3530: select ps.amount_due_remaining,ps.amount_due_original,ctt.allow_overapplication_flag
3531: into l_inv_bal_amount, l_inv_orig_amount, l_allow_over_application
3532: from ra_cust_trx_types ctt, ar_payment_schedules ps
3533: where ps.payment_schedule_id = p_invoice_ps_id
3534: and ps.cust_trx_type_id = ctt.cust_trx_type_id;
3535: END IF;
3536:

Line 4779: from ra_cust_trx_types ctt, ar_payment_schedules ps

4775: the transaction type does not allow overapplication */
4776:
4777: select ps.amount_due_remaining,ps.amount_due_original,ctt.allow_overapplication_flag
4778: into l_inv_bal_amount, l_inv_orig_amount, l_allow_over_application
4779: from ra_cust_trx_types ctt, ar_payment_schedules ps
4780: where ps.payment_schedule_id = p_invoice_ps_id
4781: and ps.cust_trx_type_id = ctt.cust_trx_type_id;
4782:
4783: l_effective_amount_applied := NVL(p_amount_applied,0) ;

Line 4884: from ra_cust_trx_types ctt,

4880: /* Added the following code for bug 2318048. If CM is postable then only make
4881: the APP row postable */
4882:
4883: select NVL(ctt.post_to_gl,'N') into l_flag
4884: from ra_cust_trx_types ctt,
4885: ar_payment_schedules ps
4886: where ctt.cust_trx_type_id = ps.cust_trx_type_id
4887: and ps.payment_schedule_id = p_cm_ps_id;
4888:

Line 8843: from ra_cust_trx_types ctt,

8839: l_cm_ps_rec,
8840: 'Y' );
8841:
8842: select NVL(ctt.post_to_gl,'N') into l_flag
8843: from ra_cust_trx_types ctt,
8844: ar_payment_schedules ps
8845: where ctt.cust_trx_type_id = ps.cust_trx_type_id
8846: and ps.payment_schedule_id = p_cm_ps_id;
8847: