APPS.IGS_AD_VAL_ACAIU dependencies on IGS_PS_UNIT_VER

Line 927: v_award_course_only_ind IGS_PS_UNIT_VER.award_course_only_ind%TYPE;

923: RETURN BOOLEAN AS
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

Line 932: FROM IGS_PS_UNIT_VER uv,

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,
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;

Line 1077: FROM IGS_PS_UNIT_VER uv

1073: cst_warn CONSTANT VARCHAR2(1) := 'W';
1074: cst_readmit CONSTANT VARCHAR2(9) := 'RE-ADMIT';
1075: CURSOR c_uv IS
1076: SELECT 'X'
1077: FROM IGS_PS_UNIT_VER uv
1078: WHERE uv.unit_cd = p_unit_cd AND
1079: uv.version_number = p_uv_version_number AND
1080: uv.research_unit_ind = 'Y';
1081: CURSOR c_can IS

Line 1164: v_expiry_dt IGS_PS_UNIT_VER.expiry_dt%TYPE;

1160: BEGIN -- admp_val_acaiu_uv_ci
1161: -- Validate the admission course application instance unit version against
1162: -- the teaching calendar
1163: DECLARE
1164: v_expiry_dt IGS_PS_UNIT_VER.expiry_dt%TYPE;
1165: v_start_dt IGS_CA_INST.start_dt%TYPE;
1166: CURSOR c_uv IS
1167: SELECT uv.expiry_dt
1168: FROM IGS_PS_UNIT_VER uv

Line 1168: FROM IGS_PS_UNIT_VER uv

1164: v_expiry_dt IGS_PS_UNIT_VER.expiry_dt%TYPE;
1165: v_start_dt IGS_CA_INST.start_dt%TYPE;
1166: CURSOR c_uv IS
1167: SELECT uv.expiry_dt
1168: FROM IGS_PS_UNIT_VER uv
1169: WHERE uv.unit_cd = p_unit_cd AND
1170: uv.version_number = p_uv_version_number AND
1171: uv.expiry_dt IS NOT NULL;
1172: CURSOR c_ci IS