APPS.ARP_DET_DIST_PKG dependencies on PSA_TRX_TYPES_ALL

Line 15814: psa_trx_types_all tt

15810: AND app.upgrade_method IS NULL
15811: AND NVL(p_app_id,-9) <> app.receivable_application_id -- excluded the current app record
15812: AND rownum = 1) cmapp11i
15813: FROM ra_customer_trx trx,
15814: psa_trx_types_all tt
15815: WHERE trx.customer_trx_id = p_trx_id
15816: AND trx.cust_trx_type_id = tt.psa_trx_type_id(+);
15817:
15818: l_record c%ROWTYPE;

Line 15916: FROM psa_trx_types_all

15912: x_out_res OUT NOCOPY VARCHAR2)
15913: IS
15914: CURSOR c1 IS
15915: SELECT 'Y'
15916: FROM psa_trx_types_all
15917: WHERE psa_trx_type_id = p_cust_trx_type_id;
15918: is_mf_trx VARCHAR2(1);
15919: BEGIN
15920: OPEN c1;