DBA Data[Home] [Help]

APPS.IGS_EN_ELGBL_PERSON dependencies on IGS_LOOKUPS_VIEW

Line 611: igs_lookups_view lkup

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'
615: AND eru.s_enrolment_step_type = uact.validation (+)

Line 631: igs_lookups_view lkup

627: SELECT eru.s_enrolment_step_type, eru.enrolment_cat, eru.s_student_comm_type, eru.enr_method_type, lkup.step_group_type,
628: eru.s_rule_call_cd,
629: eru.rul_sequence_number
630: FROM igs_en_cpd_ext eru,
631: igs_lookups_view lkup
632: WHERE eru.s_enrolment_step_type = lkup.lookup_code
633: AND lkup.lookup_type = 'ENROLMENT_STEP_TYPE_EXT'
634: AND lkup.step_group_type = 'PERSON'
635: AND eru.enrolment_cat = p_enrollment_category