DBA Data[Home] [Help]

APPS.IGR_IMP_003 dependencies on IGS_CA_INST_ALT_V

Line 543: igs_ca_inst_alt_v ciav,

539:
540: SELECT
541: 'X'
542: FROM
543: igs_ca_inst_alt_v ciav,
544: igs_lookups_view lkupv,
545: igs_lookups_view lkupv1
546: WHERE
547: (ciav.s_cal_cat = 'ACADEMIC' AND ciav.s_cal_status IN ('ACTIVE')

Line 573: igs_ca_inst_alt_v ciav1,

569: p_adm_ci_sequence_number igr_i_appl_int.adm_ci_sequence_number%TYPE) IS
570: SELECT
571: 'X'
572: FROM
573: igs_ca_inst_alt_v ciav1,
574: igs_lookups_view lkupv,
575: igs_lookups_view lkupv1
576: WHERE
577: (ciav1.s_cal_cat = 'ADMISSION' and ciav1.s_cal_status in ('ACTIVE')