APPS.EDW_GEN_VIEW dependencies on EDW_SV_FLEX_ASSIGNMENTS

Line 976: SELECT flex_field_prefix FROM edw_sv_flex_assignments

972:
973: sPrefix VARCHAR2(20) := NULL;
974:
975: CURSOR c1(pViewName VARCHAR2, pIdFlexCode VARCHAR2) IS
976: SELECT flex_field_prefix FROM edw_sv_flex_assignments
977: WHERE upper(flex_field_code) = upper(pIdFlexCode)
978: AND upper(flex_view_name) = upper(pViewName) ;
979:
980: BEGIN