APPS.ARP_PROCESS_ADJUSTMENT dependencies on RA_CUST_TRX_TYPES

Line 67: ra_cust_trx_types ctt

63: l_amount_due_remaining,
64: l_creation_sign,
65: l_allow_overapp_flag
66: FROM
67: ra_cust_trx_types ctt
68: , ar_payment_schedules ps
69: WHERE ps.payment_schedule_id = p_payment_schedule_id
70: AND ps.cust_trx_type_id = ctt.cust_trx_type_id;
71:

Line 195: ra_cust_trx_types ctt

191: l_amount_due_original,
192: l_creation_sign,
193: l_allow_overapp_flag
194: FROM ar_payment_schedules ps,
195: ra_cust_trx_types ctt
196: WHERE ps.payment_schedule_id = p_payment_schedule_id
197: AND ps.cust_trx_type_id = ctt.cust_trx_type_id;
198:
199: IF ( p_type = 'INVOICE' )

Line 1599: l_adj_post_to_gl ra_cust_trx_types.adj_post_to_gl%TYPE := 'Y' ;

1595: /* 6888581 */
1596: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1597: l_event_id NUMBER;
1598: l_security xla_events_pub_pkg.t_security;
1599: l_adj_post_to_gl ra_cust_trx_types.adj_post_to_gl%TYPE := 'Y' ;
1600:
1601: BEGIN
1602: arp_util.debug('ar_process_adjustment.update_adjustment()+',
1603: pg_msg_level_debug);

Line 1756: from ra_customer_trx ct, ra_cust_trx_types ctt

1752: BEGIN
1753:
1754: Select decode (nvl(ctt.post_to_gl,'N'),'Y', 'Y', nvl(ctt.adj_post_to_gl,'N'))
1755: into l_adj_post_to_gl
1756: from ra_customer_trx ct, ra_cust_trx_types ctt
1757: where ct.customer_trx_id = l_adj_rec.customer_trx_id
1758: and ct.cust_trx_type_id = ctt.cust_trx_type_id ;
1759:
1760: IF PG_DEBUG in ('Y', 'C') THEN