599: CURSOR cur_get_regime_regno
600: ( p_regime_id NUMBER ,
601: p_org_id NUMBER ,
602: p_loc_id NUMBER ,
603: p_att_code jai_rgm_registrations.attribute_code%TYPE , --rchandan for bug#4428980
604: p_att_type_code jai_rgm_registrations.attribute_type_code%TYPE--rchandan for bug#4428980
605: )
606: IS
607: SELECT attribute_value
600: ( p_regime_id NUMBER ,
601: p_org_id NUMBER ,
602: p_loc_id NUMBER ,
603: p_att_code jai_rgm_registrations.attribute_code%TYPE , --rchandan for bug#4428980
604: p_att_type_code jai_rgm_registrations.attribute_type_code%TYPE--rchandan for bug#4428980
605: )
606: IS
607: SELECT attribute_value
608: FROM JAI_RGM_ORG_REGNS_V jorrv