APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on SO_LOOKUPS

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

1195: location_id = p_loc_id AND
1196: register_id IN (SELECT register_id FROM JAI_OM_OE_BOND_REG_DTLS
1197: WHERE order_type_id = p_batch_source_id AND order_flag ='N');
1198:
1199: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2, cp_lookup_type So_lookups.lookup_type%TYPE ) IS
1200: SELECT meaning
1201: FROM So_lookups
1202: WHERE lookup_code = p_register_code
1203: AND lookup_type = cp_lookup_type; /* 'REGISTER_TYPE'; Ramananda for removal of SQL LITERALs */

Line 1201: FROM So_lookups

1197: WHERE order_type_id = p_batch_source_id AND order_flag ='N');
1198:
1199: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2, cp_lookup_type So_lookups.lookup_type%TYPE ) IS
1200: SELECT meaning
1201: FROM So_lookups
1202: WHERE lookup_code = p_register_code
1203: AND lookup_type = cp_lookup_type; /* 'REGISTER_TYPE'; Ramananda for removal of SQL LITERALs */
1204:
1205: v_meaning VARCHAR2(80);