APPS.ARP_DET_DIST_PKG dependencies on PSA_TRX_TYPES_ALL

Line 17526: psa_trx_types_all tt

17522: AND NVL(app.upgrade_method,'NULL') IN ('11I_MFAR_UPG','NULL')
17523: AND NVL(p_app_id,-9) <> app.receivable_application_id -- excluded the current app record
17524: AND rownum = 1) cmapp11i
17525: FROM ra_customer_trx trx,
17526: psa_trx_types_all tt
17527: WHERE trx.customer_trx_id = p_trx_id
17528: AND trx.cust_trx_type_id = tt.psa_trx_type_id(+);
17529:
17530: l_record c%ROWTYPE;

Line 17628: FROM psa_trx_types_all

17624: x_out_res OUT NOCOPY VARCHAR2)
17625: IS
17626: CURSOR c1 IS
17627: SELECT 'Y'
17628: FROM psa_trx_types_all
17629: WHERE psa_trx_type_id = p_cust_trx_type_id;
17630: is_mf_trx VARCHAR2(1);
17631: BEGIN
17632: OPEN c1;