APPS.AR_BILLS_CREATION_VAL_PVT dependencies on RA_CUST_TRX_TYPES

Line 266: FROM RA_CUST_TRX_TYPES

262: END IF;
263:
264: SELECT status, start_date, end_date
265: INTO l_status, l_start_date, l_end_date
266: FROM RA_CUST_TRX_TYPES
267: WHERE cust_trx_type_id = p_cust_trx_type_id
268: AND TYPE = 'BR';
269:
270:

Line 643: FROM RA_CUST_TRX_TYPES

639: +-----------------------------------------------*/
640:
641: SELECT signed_flag , format_program_id
642: INTO l_signed_flag, l_format_program_id
643: FROM RA_CUST_TRX_TYPES
644: WHERE cust_trx_type_id = p_cust_trx_type_id;
645:
646: IF PG_DEBUG in ('Y', 'C') THEN
647: arp_util.debug('Validate_Drawee: ' || 'Signed Flag : ' || l_signed_flag);

Line 1392: FROM RA_CUST_TRX_TYPES

1388: END IF;
1389:
1390: SELECT type
1391: INTO l_type
1392: FROM RA_CUST_TRX_TYPES
1393: WHERE cust_trx_type_id = p_cust_trx_type_id;
1394:
1395: IF (l_type = 'BR')
1396: THEN

Line 1583: FROM RA_CUST_TRX_TYPES

1579:
1580:
1581: SELECT type
1582: INTO l_type
1583: FROM RA_CUST_TRX_TYPES
1584: WHERE cust_trx_type_id = p_ps_rec.cust_trx_type_id;
1585:
1586: /*----------------------------------------------+
1587: | Validate that the assignment is not a |