APPS.IGS_AD_VAL_ACAIU dependencies on IGS_PS_UNIT_STAT

Line 928: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;

924: BEGIN -- admp_val_acaiu_uv
925: -- This module validate IGS_AD_PS_APLINSTUNT unit version.
926: DECLARE
927: v_award_course_only_ind IGS_PS_UNIT_VER.award_course_only_ind%TYPE;
928: v_s_unit_status IGS_PS_UNIT_STAT.s_unit_status%TYPE;
929: CURSOR c_val_unit_version IS
930: SELECT uv.award_course_only_ind,
931: us.s_unit_status
932: FROM IGS_PS_UNIT_VER uv,

Line 933: IGS_PS_UNIT_STAT us

929: CURSOR c_val_unit_version IS
930: SELECT uv.award_course_only_ind,
931: us.s_unit_status
932: FROM IGS_PS_UNIT_VER uv,
933: IGS_PS_UNIT_STAT us
934: WHERE uv.unit_cd = p_unit_cd AND
935: uv.version_number = p_uv_version_number AND
936: us.unit_status = uv.unit_status;
937: BEGIN