260: END IF;
261:
262: SELECT status, start_date, end_date
263: INTO l_status, l_start_date, l_end_date
264: FROM RA_CUST_TRX_TYPES
265: WHERE cust_trx_type_id = p_cust_trx_type_id
266: AND TYPE = 'BR';
267:
268:
637: +-----------------------------------------------*/
638:
639: SELECT signed_flag , format_program_id
640: INTO l_signed_flag, l_format_program_id
641: FROM RA_CUST_TRX_TYPES
642: WHERE cust_trx_type_id = p_cust_trx_type_id;
643:
644: IF PG_DEBUG in ('Y', 'C') THEN
645: arp_util.debug('Validate_Drawee: ' || 'Signed Flag : ' || l_signed_flag);
1386: END IF;
1387:
1388: SELECT type
1389: INTO l_type
1390: FROM RA_CUST_TRX_TYPES
1391: WHERE cust_trx_type_id = p_cust_trx_type_id;
1392:
1393: IF (l_type = 'BR')
1394: THEN
1577:
1578:
1579: SELECT type
1580: INTO l_type
1581: FROM RA_CUST_TRX_TYPES
1582: WHERE cust_trx_type_id = p_ps_rec.cust_trx_type_id;
1583:
1584: /*----------------------------------------------+
1585: | Validate that the assignment is not a |