eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AW_GEN_003 dependencies on IGF_AW_DP_TERMS

Line 27: FROM igf_aw_dp_terms terms,

23: -------------------------------------------------------------------
24: --
25: CURSOR cur_check_terms IS
26: SELECT COUNT(*) common_terms
27: FROM igf_aw_dp_terms terms,
28: igf_aw_dp_teach_prds teach_periods
29: WHERE terms.adplans_id = p_adplans_id
30: AND terms.adterms_id = teach_periods.adterms_id;
31: ln_result NUMBER;

Line 36: igf_aw_dp_terms terms,

32:
33: CURSOR cur_check_terms_awd IS
34: SELECT COUNT(*) common_terms
35: FROM igf_aw_awd_dist_plans adplans,
36: igf_aw_dp_terms terms,
37: igf_aw_dp_teach_prds teach_periods,
38: igf_aw_awd_prd_term aprd
39: WHERE terms.adplans_id = p_adplans_id
40: AND terms.adterms_id = teach_periods.adterms_id

Line 1076: FROM igf_aw_dp_terms terms,

1072: teach_periods.start_date start_dt,
1073: teach_periods.date_offset_cd tp_offset_da,
1074: teach_periods.credit_points_num min_credit_points,
1075: teach_periods.attendance_type_code attendance_type_code
1076: FROM igf_aw_dp_terms terms,
1077: igf_aw_dp_teach_prds_v teach_periods,
1078: (SELECT base_id,
1079: ld_cal_type,
1080: ld_sequence_number

Line 1121: FROM igf_aw_dp_terms terms,

1117: teach_periods.start_date start_dt,
1118: teach_periods.date_offset_cd tp_offset_da,
1119: teach_periods.credit_points_num min_credit_points,
1120: teach_periods.attendance_type_code attendance_type_code
1121: FROM igf_aw_dp_terms terms,
1122: igf_aw_dp_teach_prds_v teach_periods,
1123: igf_aw_awd_prd_term aprd,
1124: igf_aw_awd_dist_plans dp
1125: WHERE terms.adplans_id = cp_adplans_id

Line 1156: FROM igf_aw_dp_terms terms,

1152: teach_periods.start_date start_dt,
1153: teach_periods.date_offset_cd tp_offset_da,
1154: teach_periods.credit_points_num min_credit_points,
1155: teach_periods.attendance_type_code attendance_type_code
1156: FROM igf_aw_dp_terms terms,
1157: igf_aw_dp_teach_prds_v teach_periods,
1158: (SELECT base_id,
1159: ld_cal_type,
1160: ld_sequence_number

Line 1198: FROM igf_aw_dp_terms terms,

1194: teach_periods.start_date start_dt,
1195: teach_periods.date_offset_cd tp_offset_da,
1196: teach_periods.credit_points_num min_credit_points,
1197: teach_periods.attendance_type_code attendance_type_code
1198: FROM igf_aw_dp_terms terms,
1199: igf_aw_dp_teach_prds_v teach_periods,
1200: igf_aw_awd_dist_plans dp,
1201: igf_aw_awd_prd_term aprd
1202: WHERE terms.adplans_id = cp_adplans_id

Line 1230: FROM igf_aw_dp_terms terms,

1226: teach_periods.start_date start_dt,
1227: teach_periods.date_offset_cd tp_offset_da,
1228: teach_periods.credit_points_num min_credit_points,
1229: teach_periods.attendance_type_code attendance_type_code
1230: FROM igf_aw_dp_terms terms,
1231: igf_aw_dp_teach_prds_v teach_periods,
1232: (SELECT base_id,
1233: ld_cal_type,
1234: ld_sequence_number,

Line 1267: FROM igf_aw_dp_terms terms,

1263: teach_periods.start_date start_dt,
1264: teach_periods.date_offset_cd tp_offset_da,
1265: teach_periods.credit_points_num min_credit_points,
1266: teach_periods.attendance_type_code attendance_type_code
1267: FROM igf_aw_dp_terms terms,
1268: igf_aw_dp_teach_prds_v teach_periods,
1269: (SELECT base_id,
1270: ld_cal_type,
1271: ld_sequence_number

Line 1301: FROM igf_aw_dp_terms terms,

1297: teach_periods.start_date start_dt,
1298: teach_periods.date_offset_cd tp_offset_da,
1299: teach_periods.credit_points_num min_credit_points,
1300: teach_periods.attendance_type_code attendance_type_code
1301: FROM igf_aw_dp_terms terms,
1302: igf_aw_dp_teach_prds_v teach_periods
1303: WHERE terms.adplans_id = cp_adplans_id
1304: AND terms.adterms_id = teach_periods.adterms_id
1305: ORDER BY 1;

Line 1327: FROM igf_aw_dp_terms terms,

1323: teach_periods.start_date start_dt,
1324: teach_periods.date_offset_cd tp_offset_da,
1325: teach_periods.credit_points_num min_credit_points,
1326: teach_periods.attendance_type_code attendance_type_code
1327: FROM igf_aw_dp_terms terms,
1328: igf_aw_dp_teach_prds_v teach_periods,
1329: (SELECT base_id,
1330: ld_cal_type,
1331: ld_sequence_number

Line 1358: FROM igf_aw_dp_terms terms,

1354: teach_periods.start_date start_dt,
1355: teach_periods.date_offset_cd tp_offset_da,
1356: teach_periods.credit_points_num min_credit_points,
1357: teach_periods.attendance_type_code attendance_type_code
1358: FROM igf_aw_dp_terms terms,
1359: igf_aw_dp_teach_prds_v teach_periods
1360: WHERE terms.adplans_id = cp_adplans_id
1361: AND terms.adterms_id = teach_periods.adterms_id
1362: ORDER BY 1;

Line 1381: FROM igf_aw_dp_terms terms,

1377: teach_periods.start_date start_dt,
1378: teach_periods.date_offset_cd tp_offset_da,
1379: teach_periods.credit_points_num min_credit_points,
1380: teach_periods.attendance_type_code attendance_type_code
1381: FROM igf_aw_dp_terms terms,
1382: igf_aw_dp_teach_prds_v teach_periods,
1383: (SELECT base_id,
1384: ld_cal_type,
1385: ld_sequence_number,

Line 1401: FROM igf_aw_dp_terms terms,

1397: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1398: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
1399: ) IS
1400: SELECT COUNT(*)
1401: FROM igf_aw_dp_terms terms,
1402: (SELECT base_id,
1403: ld_cal_type,
1404: ld_sequence_number
1405: FROM igf_aw_coa_itm_terms

Line 1417: FROM igf_aw_dp_terms terms

1413: CURSOR cur_terms_count_wcoa_pell(
1414: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
1415: ) IS
1416: SELECT COUNT(*)
1417: FROM igf_aw_dp_terms terms
1418: WHERE terms.adplans_id = cp_adplans_id;
1419:
1420: CURSOR c_coa_pell(
1421: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

Line 1428: FROM igf_aw_dp_terms

1424: SELECT SUM(amount) coa
1425: FROM igf_aw_coa_itm_terms coa_terms,
1426: (SELECT ld_cal_type,
1427: ld_sequence_number
1428: FROM igf_aw_dp_terms
1429: WHERE adplans_id = cp_adplans_id
1430: )dist_terms
1431: WHERE dist_terms.ld_cal_type = coa_terms.ld_cal_type
1432: AND dist_terms.ld_sequence_number = coa_terms.ld_sequence_number

Line 1446: FROM igf_aw_dp_terms

1442: SELECT SUM(amount) coa
1443: FROM igf_aw_coa_itm_terms coa_terms,
1444: (SELECT ld_cal_type,
1445: ld_sequence_number
1446: FROM igf_aw_dp_terms
1447: WHERE adplans_id = cp_adplans_id
1448: )dist_terms,
1449: igf_ap_fa_base_rec_all fa,
1450: igf_aw_awd_prd_term aprd

Line 1472: FROM igf_aw_dp_terms terms,

1468: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1469: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1470: ) IS
1471: SELECT COUNT(*)
1472: FROM igf_aw_dp_terms terms,
1473: (SELECT base_id,
1474: ld_cal_type,
1475: ld_sequence_number
1476: FROM igf_aw_coa_itm_terms

Line 1500: FROM igf_aw_dp_terms terms,

1496: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1497: )
1498: IS
1499: SELECT COUNT(*)
1500: FROM igf_aw_dp_terms terms,
1501: igf_aw_awd_dist_plans dp,
1502: igf_aw_awd_prd_term aprd
1503: WHERE terms.adplans_id = cp_adplans_id
1504: AND terms.adplans_id = dp.adplans_id

Line 4380: FROM igf_aw_dp_terms terms,

4376:
4377: --Get common COA terms %
4378: CURSOR cur_get_perct IS
4379: SELECT SUM((teach_periods.tp_perct_num * terms.ld_perct_num)/100) perct
4380: FROM igf_aw_dp_terms terms,
4381: igf_aw_dp_teach_prds teach_periods,
4382: (SELECT base_id,
4383: ld_cal_type,
4384: ld_sequence_number

Line 4396: FROM igf_aw_dp_terms terms,

4392: AND coaterms.base_id = p_base_id;
4393:
4394: CURSOR cur_get_perct_awd IS
4395: SELECT SUM((teach_periods.tp_perct_num * terms.ld_perct_num)/100) perct
4396: FROM igf_aw_dp_terms terms,
4397: igf_aw_dp_teach_prds teach_periods,
4398: igf_aw_awd_prd_term aprd,
4399: igf_ap_fa_base_rec_all fa,
4400: (SELECT base_id,

Line 4457: FROM igf_aw_dp_terms terms,

4453: -------------------------------------------------------------------
4454:
4455: CURSOR cur_check_terms IS
4456: SELECT COUNT(*) common_terms
4457: FROM igf_aw_dp_terms terms,
4458: igf_aw_dp_teach_prds teach_periods,
4459: (SELECT base_id,
4460: ld_cal_type,
4461: ld_sequence_number

Line 4473: FROM igf_aw_dp_terms terms,

4469: AND coaterms.base_id = p_base_id;
4470:
4471: CURSOR cur_check_terms_awd IS
4472: SELECT COUNT(*) common_terms
4473: FROM igf_aw_dp_terms terms,
4474: igf_aw_dp_teach_prds teach_periods,
4475: (SELECT base_id,
4476: ld_cal_type,
4477: ld_sequence_number