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 244: ra_cust_trx_types ctt

240: l_amount_due_original,
241: l_creation_sign,
242: l_allow_overapp_flag
243: FROM ar_payment_schedules ps,
244: ra_cust_trx_types ctt
245: WHERE ps.payment_schedule_id = p_payment_schedule_id
246: AND ps.cust_trx_type_id = ctt.cust_trx_type_id;
247:
248: IF ( p_type = 'INVOICE' )

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

1878: /* 6888581 */
1879: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1880: l_event_id NUMBER;
1881: l_security xla_events_pub_pkg.t_security;
1882: l_adj_post_to_gl ra_cust_trx_types.adj_post_to_gl%TYPE := 'Y' ;
1883: /* Added local variables to be used in Update_Adjustment procedure, manishri, Bug 9708599 */
1884: l_mode VARCHAR2(20);
1885: l_gt_id NUMBER := 0;
1886: l_line_amt NUMBER;

Line 2179: from ra_customer_trx ct, ra_cust_trx_types ctt

2175: BEGIN
2176:
2177: Select decode (nvl(ctt.post_to_gl,'N'),'Y', 'Y', nvl(ctt.adj_post_to_gl,'N'))
2178: into l_adj_post_to_gl
2179: from ra_customer_trx ct, ra_cust_trx_types ctt
2180: where ct.customer_trx_id = l_adj_rec.customer_trx_id
2181: and ct.cust_trx_type_id = ctt.cust_trx_type_id ;
2182:
2183: IF PG_DEBUG in ('Y', 'C') THEN

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

3053: /* 7699796 */
3054: l_event_source_info xla_events_pub_pkg.t_event_source_info;
3055: l_event_id NUMBER;
3056: l_security xla_events_pub_pkg.t_security;
3057: l_adj_post_to_gl ra_cust_trx_types.adj_post_to_gl%TYPE := 'Y' ;
3058:
3059: BEGIN
3060: IF PG_DEBUG in ('Y', 'C') THEN
3061: arp_standard.debug( 'arp_process_adjustment.reverse_adjustment()+' );

Line 3100: from ra_customer_trx ct, ra_cust_trx_types ctt

3096: /* 7699796 */
3097:
3098: Select decode (nvl(ctt.post_to_gl,'N'),'Y', 'Y', nvl(ctt.adj_post_to_gl,'N'))
3099: into l_adj_post_to_gl
3100: from ra_customer_trx ct, ra_cust_trx_types ctt
3101: where ct.customer_trx_id = l_adj_rec.customer_trx_id
3102: and ct.cust_trx_type_id = ctt.cust_trx_type_id ;
3103:
3104: IF PG_DEBUG in ('Y', 'C') THEN

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

3446: /* 7699796 */
3447: l_event_source_info xla_events_pub_pkg.t_event_source_info;
3448: l_event_id NUMBER;
3449: l_security xla_events_pub_pkg.t_security;
3450: l_adj_post_to_gl ra_cust_trx_types.adj_post_to_gl%TYPE := 'Y' ;
3451: l_adj_status VARCHAR2(1);
3452:
3453:
3454: BEGIN

Line 3617: from ra_customer_trx ct, ra_cust_trx_types ctt

3613: BEGIN
3614:
3615: Select decode (nvl(ctt.post_to_gl,'N'),'Y', 'Y', nvl(ctt.adj_post_to_gl,'N'))
3616: into l_adj_post_to_gl
3617: from ra_customer_trx ct, ra_cust_trx_types ctt
3618: where ct.customer_trx_id = p_adj_rec.customer_trx_id
3619: and ct.cust_trx_type_id = ctt.cust_trx_type_id ;
3620:
3621: IF PG_DEBUG in ('Y', 'C') THEN