APPS.IGS_DA_XML_PKG dependencies on IGS_EN_UNIT_SET

Line 1048: l_academicsubprogramcode1 igs_en_unit_set.unit_set_cd%TYPE;

1044: l_prog_comparison_type igs_da_rqst.program_comparison_type%TYPE;
1045: pos1 NUMBER ;
1046: pos2 NUMBER ;
1047: pos3 NUMBER ;
1048: l_academicsubprogramcode1 igs_en_unit_set.unit_set_cd%TYPE;
1049: l_academicsubprogramcode2 igs_en_unit_set.unit_set_cd%TYPE;
1050: l_academicsubprogramcode3 igs_en_unit_set.unit_set_cd%TYPE;
1051:
1052: CURSOR c_prog_comp IS

Line 1049: l_academicsubprogramcode2 igs_en_unit_set.unit_set_cd%TYPE;

1045: pos1 NUMBER ;
1046: pos2 NUMBER ;
1047: pos3 NUMBER ;
1048: l_academicsubprogramcode1 igs_en_unit_set.unit_set_cd%TYPE;
1049: l_academicsubprogramcode2 igs_en_unit_set.unit_set_cd%TYPE;
1050: l_academicsubprogramcode3 igs_en_unit_set.unit_set_cd%TYPE;
1051:
1052: CURSOR c_prog_comp IS
1053: SELECT dr.program_comparison_type

Line 1050: l_academicsubprogramcode3 igs_en_unit_set.unit_set_cd%TYPE;

1046: pos2 NUMBER ;
1047: pos3 NUMBER ;
1048: l_academicsubprogramcode1 igs_en_unit_set.unit_set_cd%TYPE;
1049: l_academicsubprogramcode2 igs_en_unit_set.unit_set_cd%TYPE;
1050: l_academicsubprogramcode3 igs_en_unit_set.unit_set_cd%TYPE;
1051:
1052: CURSOR c_prog_comp IS
1053: SELECT dr.program_comparison_type
1054: FROM igs_da_rqst dr

Line 1083: FROM igs_en_unit_set eus,igs_en_unit_set_stat euss, igs_da_setup ds

1079: AND drw.program_code = drs.wif_program_code
1080: AND drw.major_unit_set_cd1 = drs.major_unit_set_cd
1081: AND (drw.minor_unit_set_cd1 = RTRIM(LTRIM(l_academicsubprogramcode1))
1082: AND EXISTS (SELECT 'X'
1083: FROM igs_en_unit_set eus,igs_en_unit_set_stat euss, igs_da_setup ds
1084: WHERE eus.unit_set_status=euss.unit_set_status
1085: AND euss.s_unit_set_status = 'ACTIVE'
1086: AND eus.unit_set_cd = drw.minor_unit_set_cd1
1087: AND eus.unit_set_cat = ds.wif_minor_unit_set_cat

Line 1092: FROM igs_en_unit_set eus,igs_en_unit_set_stat euss, igs_da_setup ds

1088: AND ds.s_control_num =1)
1089: OR drw.minor_unit_set_cd1 IS NULL)
1090: AND (drw.track_unit_set_cd1 = RTRIM(LTRIM(l_academicsubprogramcode2))
1091: AND EXISTS (SELECT 'X'
1092: FROM igs_en_unit_set eus,igs_en_unit_set_stat euss, igs_da_setup ds
1093: WHERE eus.unit_set_status=euss.unit_set_status
1094: AND euss.s_unit_set_status = 'ACTIVE'
1095: AND eus.unit_set_cd = drw.track_unit_set_cd1
1096: AND eus.unit_set_cat = ds.wif_track_unit_set_cat

Line 1127: FROM igs_en_unit_set eus,igs_en_unit_set_stat euss, igs_da_setup ds

1123: AND drw.wif_id = drs.wif_id
1124: AND drw.program_code = drs.wif_program_code
1125: AND (drw.major_unit_set_cd1 = RTRIM(LTRIM(l_academicsubprogramcode1))
1126: AND EXISTS (SELECT 'X'
1127: FROM igs_en_unit_set eus,igs_en_unit_set_stat euss, igs_da_setup ds
1128: WHERE eus.unit_set_status=euss.unit_set_status
1129: AND euss.s_unit_set_status = 'ACTIVE'
1130: AND eus.unit_set_cd = drw.major_unit_set_cd1
1131: AND eus.unit_set_cat = ds.wif_major_unit_set_cat

Line 1136: FROM igs_en_unit_set eus,igs_en_unit_set_stat euss, igs_da_setup ds

1132: AND ds.s_control_num =1)
1133: OR drw.major_unit_set_cd1 IS NULL)
1134: AND (drw.minor_unit_set_cd1 = RTRIM(LTRIM(l_academicsubprogramcode2))
1135: AND EXISTS (SELECT 'X'
1136: FROM igs_en_unit_set eus,igs_en_unit_set_stat euss, igs_da_setup ds
1137: WHERE eus.unit_set_status=euss.unit_set_status
1138: AND euss.s_unit_set_status = 'ACTIVE'
1139: AND eus.unit_set_cd = drw.minor_unit_set_cd1
1140: AND eus.unit_set_cat = ds.wif_minor_unit_set_cat

Line 1145: FROM igs_en_unit_set eus,igs_en_unit_set_stat euss, igs_da_setup ds

1141: AND ds.s_control_num =1)
1142: OR drw.minor_unit_set_cd1 IS NULL)
1143: AND (drw.track_unit_set_cd1 = RTRIM(LTRIM(l_academicsubprogramcode3))
1144: AND EXISTS (SELECT 'X'
1145: FROM igs_en_unit_set eus,igs_en_unit_set_stat euss, igs_da_setup ds
1146: WHERE eus.unit_set_status=euss.unit_set_status
1147: AND euss.s_unit_set_status = 'ACTIVE'
1148: AND eus.unit_set_cd = drw.track_unit_set_cd1
1149: AND eus.unit_set_cat = ds.wif_track_unit_set_cat