DBA Data[Home] [Help]

APPS.IGS_AD_VAL_ACAI_STATUS dependencies on IGS_PS_TYPE

Line 2186: v_cty_res_typ_ind IGS_PS_TYPE.research_type_ind%TYPE;

2182: sca.adm_nominated_course_cd = p_nominated_course_cd AND
2183: sca.adm_sequence_number = p_acai_sequence_number;
2184:
2185:
2186: v_cty_res_typ_ind IGS_PS_TYPE.research_type_ind%TYPE;
2187:
2188: CURSOR c_crv_cty IS
2189: SELECT cty.research_type_ind
2190: FROM IGS_PS_VER crv,

Line 2191: IGS_PS_TYPE cty

2187:
2188: CURSOR c_crv_cty IS
2189: SELECT cty.research_type_ind
2190: FROM IGS_PS_VER crv,
2191: IGS_PS_TYPE cty
2192: WHERE crv.course_cd = p_course_cd AND
2193: crv.version_number = p_crv_version_number AND
2194: crv.course_type = cty.course_type;
2195: