DBA Data[Home] [Help]

APPS.IGS_EN_ELGBL_PROGRAM dependencies on IGS_PE_USR_AVAL_ALL

Line 145: igs_pe_usr_aval_all uact,

141: DECODE(uact.deny_warn,'WARN','WARN',eru.notification_flag) notification_flag,
142: eru.s_rule_call_cd,
143: eru.rul_sequence_number
144: FROM igs_en_cpd_ext eru,
145: igs_pe_usr_aval_all uact,
146: igs_lookups_view lkup
147: WHERE eru.s_enrolment_step_type = lkup.lookup_code AND
148: eru.enrolment_cat = p_enrollment_category AND
149: eru.enr_method_type = p_method_type AND

Line 759: igs_pe_usr_aval_all uact,

755: ORDER BY eru.step_order_num;
756: ELSE
757: OPEN cur_program_steps FOR SELECT eru.rul_sequence_number rul_sequence_number
758: FROM igs_en_cpd_ext eru,
759: igs_pe_usr_aval_all uact,
760: igs_lookups_view lkup
761: WHERE eru.s_enrolment_step_type = lkup.lookup_code AND
762: lkup.lookup_type = 'ENROLMENT_STEP_TYPE_EXT' AND
763: eru.s_enrolment_step_type = 'UNIT_EXCL' AND