APPS.IGS_EN_VAL_SCA dependencies on IGS_PS_TYPE

Line 90: v_cty_res_typ_ind IGS_PS_TYPE.research_type_ind%TYPE;

86: (p_parent = cst_ACAI and
87: ca.acai_admission_appl_number = p_acai_admission_appl_number AND
88: ca.acai_nominated_course_cd = p_acai_nominated_course_cd AND
89: ca.acai_sequence_number = p_acai_sequence_number));
90: v_cty_res_typ_ind IGS_PS_TYPE.research_type_ind%TYPE;
91: CURSOR c_crv_cty IS
92: SELECT cty.research_type_ind
93: FROM IGS_PS_VER crv,
94: IGS_PS_TYPE cty

Line 94: IGS_PS_TYPE cty

90: v_cty_res_typ_ind IGS_PS_TYPE.research_type_ind%TYPE;
91: CURSOR c_crv_cty IS
92: SELECT cty.research_type_ind
93: FROM IGS_PS_VER crv,
94: IGS_PS_TYPE cty
95: WHERE crv.course_cd = p_course_cd AND
96: crv.version_number = p_crv_version_number AND
97: crv.course_type = cty.course_type;
98: v_aa_apcs_exists VARCHAR2(1);

Line 681: v_cty_research_type_ind IGS_PS_TYPE.research_type_ind%TYPE;

677: -- Validations are:
678: -- . The course attempted is defined as a research course and no research
679: -- candidature details exist, or the research candidature is incomplete.
680: DECLARE
681: v_cty_research_type_ind IGS_PS_TYPE.research_type_ind%TYPE;
682: v_message_name varchar2(30);
683: CURSOR c_cty IS
684: SELECT cty.research_type_ind
685: FROM IGS_PS_VER crv,

Line 686: IGS_PS_TYPE cty

682: v_message_name varchar2(30);
683: CURSOR c_cty IS
684: SELECT cty.research_type_ind
685: FROM IGS_PS_VER crv,
686: IGS_PS_TYPE cty
687: WHERE crv.course_cd = p_course_cd AND
688: crv.version_number = p_crv_version_number AND
689: crv.course_type = cty.course_type;
690: BEGIN