DBA Data[Home] [Help]

APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_HE_CODE_MAP_VAL

Line 589: CURSOR cur_map (p_assoc igs_he_code_map_val.association_code%TYPE ,

585: AND p_appno BETWEEN appno_first AND appno_maximum;
586:
587:
588: -- To get the OSS eqvivalent value for UCAS Value.
589: CURSOR cur_map (p_assoc igs_he_code_map_val.association_code%TYPE ,
590: p_map1 igs_he_code_map_val.map1%TYPE ) IS
591: SELECT map2
592: FROM igs_he_code_map_val
593: WHERE association_code = p_assoc

Line 590: p_map1 igs_he_code_map_val.map1%TYPE ) IS

586:
587:
588: -- To get the OSS eqvivalent value for UCAS Value.
589: CURSOR cur_map (p_assoc igs_he_code_map_val.association_code%TYPE ,
590: p_map1 igs_he_code_map_val.map1%TYPE ) IS
591: SELECT map2
592: FROM igs_he_code_map_val
593: WHERE association_code = p_assoc
594: AND map1 = p_map1;

Line 592: FROM igs_he_code_map_val

588: -- To get the OSS eqvivalent value for UCAS Value.
589: CURSOR cur_map (p_assoc igs_he_code_map_val.association_code%TYPE ,
590: p_map1 igs_he_code_map_val.map1%TYPE ) IS
591: SELECT map2
592: FROM igs_he_code_map_val
593: WHERE association_code = p_assoc
594: AND map1 = p_map1;
595:
596: -- TITLE validation