APPS.JL_ZZ_AR_LIBRARY_1_PKG dependencies on RA_CUST_TRX_TYPES

Line 326: FROM ra_customer_trx rct, ra_cust_trx_types rctt

322: BEGIN
323: Errcd := 0;
324: SELECT COUNT (rct.complete_flag)
325: INTO total_records
326: FROM ra_customer_trx rct, ra_cust_trx_types rctt
327: WHERE rct.complete_flag = 'Y'
328: AND NVL (rct.printing_count,0) = 0
329: AND NVL (rct.status_trx, 'VD') <> 'VD'
330: AND rctt.cust_trx_type_id = rct.cust_trx_type_id

Line 347: FROM ra_cust_trx_types_all

343: BEGIN
344: Errcd := 0;
345: SELECT type, default_status
346: INTO class, dfstatus
347: FROM ra_cust_trx_types_all
348: WHERE cust_trx_type_id = p_cust_trx_type_id
349: AND rownum = row_number;
350: EXCEPTION
351: WHEN OTHERS THEN

Line 567: ra_cust_trx_types_all rctt

563: rctt.type
564: INTO status,
565: typ_class
566: FROM ra_customer_trx_all rct,
567: ra_cust_trx_types_all rctt
568: WHERE rct.cust_trx_type_id = rctt.cust_trx_type_id
569: AND rct.customer_trx_id = cust_trx_id
570: AND rownum = row_number;
571: EXCEPTION

Line 893: FROM ra_cust_trx_types ct

889: END IF;
890:
891: SELECT cust_trx_type_id
892: INTO p_void_trx_type_id
893: FROM ra_cust_trx_types ct
894: WHERE ct.global_attribute_category = l_category
895: AND ct.global_attribute6 = 'Y';
896:
897: EXCEPTION