APPS.IGS_EN_ELGBL_PERSON dependencies on IGS_PE_USR_AVAL

Line 101: CURSOR c_chkencumb_override (cp_person_type igs_pe_usr_aval.person_type%TYPE) IS

97:
98: --
99: -- cursor to check whether the CHKENCUMB is overridden or not
100: --
101: CURSOR c_chkencumb_override (cp_person_type igs_pe_usr_aval.person_type%TYPE) IS
102: SELECT 'Y'
103: FROM igs_pe_usr_aval
104: WHERE validation = 'CHKENCUMB'
105: AND override_ind = 'Y'

Line 103: FROM igs_pe_usr_aval

99: -- cursor to check whether the CHKENCUMB is overridden or not
100: --
101: CURSOR c_chkencumb_override (cp_person_type igs_pe_usr_aval.person_type%TYPE) IS
102: SELECT 'Y'
103: FROM igs_pe_usr_aval
104: WHERE validation = 'CHKENCUMB'
105: AND override_ind = 'Y'
106: AND person_type = cp_person_type;
107: l_chkencumb_override VARCHAR2(1) ;

Line 348: CURSOR c_chkencumb_override (cp_person_type igs_pe_usr_aval.person_type%TYPE) IS

344:
345: --
346: -- cursor to check whether the CHKENCUMB is overridden or not
347: --
348: CURSOR c_chkencumb_override (cp_person_type igs_pe_usr_aval.person_type%TYPE) IS
349: SELECT 'Y'
350: FROM igs_pe_usr_aval
351: WHERE validation = 'CHKENCUMB'
352: AND override_ind = 'Y'

Line 350: FROM igs_pe_usr_aval

346: -- cursor to check whether the CHKENCUMB is overridden or not
347: --
348: CURSOR c_chkencumb_override (cp_person_type igs_pe_usr_aval.person_type%TYPE) IS
349: SELECT 'Y'
350: FROM igs_pe_usr_aval
351: WHERE validation = 'CHKENCUMB'
352: AND override_ind = 'Y'
353: AND person_type = cp_person_type;
354: l_chkencumb_override VARCHAR2(1) ;

Line 610: igs_pe_usr_aval_all uact,

606: SELECT eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkup.step_group_type,
607: eru.s_rule_call_cd,
608: eru.rul_sequence_number
609: FROM igs_en_cpd_ext eru,
610: igs_pe_usr_aval_all uact,
611: igs_lookups_view lkup
612: WHERE eru.s_enrolment_step_type = lkup.lookup_code
613: AND lkup.lookup_type = 'ENROLMENT_STEP_TYPE_EXT'
614: AND lkup.step_group_type = 'PERSON'