APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on SO_LOOKUPS

Line 1270: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2, cp_lookup_type So_lookups.lookup_type%TYPE ) IS

1266: location_id = p_loc_id AND
1267: register_id IN (SELECT register_id FROM JAI_OM_OE_BOND_REG_DTLS
1268: WHERE order_type_id = p_batch_source_id AND order_flag ='N');
1269:
1270: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2, cp_lookup_type So_lookups.lookup_type%TYPE ) IS
1271: SELECT meaning
1272: FROM So_lookups
1273: WHERE lookup_code = p_register_code
1274: AND lookup_type = cp_lookup_type; /* 'REGISTER_TYPE'; Ramananda for removal of SQL LITERALs */

Line 1272: FROM So_lookups

1268: WHERE order_type_id = p_batch_source_id AND order_flag ='N');
1269:
1270: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2, cp_lookup_type So_lookups.lookup_type%TYPE ) IS
1271: SELECT meaning
1272: FROM So_lookups
1273: WHERE lookup_code = p_register_code
1274: AND lookup_type = cp_lookup_type; /* 'REGISTER_TYPE'; Ramananda for removal of SQL LITERALs */
1275:
1276: v_meaning VARCHAR2(80);