APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_HE_CODE_MAP_VAL

Line 2320: CURSOR cur_ucas_oss_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,

2316: FROM igs_he_ad_dtl_all had
2317: WHERE person_id = l_per_id;
2318:
2319: -- UCAS Association mapping
2320: CURSOR cur_ucas_oss_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,
2321: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS
2322: SELECT map2
2323: FROM IGS_HE_CODE_MAP_VAL
2324: WHERE association_code = cp_assoc

Line 2321: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS

2317: WHERE person_id = l_per_id;
2318:
2319: -- UCAS Association mapping
2320: CURSOR cur_ucas_oss_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,
2321: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS
2322: SELECT map2
2323: FROM IGS_HE_CODE_MAP_VAL
2324: WHERE association_code = cp_assoc
2325: AND map1 = cp_map1;

Line 2323: FROM IGS_HE_CODE_MAP_VAL

2319: -- UCAS Association mapping
2320: CURSOR cur_ucas_oss_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,
2321: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS
2322: SELECT map2
2323: FROM IGS_HE_CODE_MAP_VAL
2324: WHERE association_code = cp_assoc
2325: AND map1 = cp_map1;
2326:
2327: l_dom_cd igs_he_ad_dtl_all.domicile_cd%TYPE;