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_COA_ITM_TERMS

Line 1081: FROM igf_aw_coa_itm_terms

1077: igf_aw_dp_teach_prds_v teach_periods,
1078: (SELECT base_id,
1079: ld_cal_type,
1080: ld_sequence_number
1081: FROM igf_aw_coa_itm_terms
1082: WHERE base_id = cp_base_id
1083: GROUP BY base_id,ld_cal_type, ld_sequence_number) coaterms,
1084: igf_aw_awd_dist_plans dp,
1085: igf_aw_awd_prd_term aprd

Line 1161: FROM igf_aw_coa_itm_terms

1157: igf_aw_dp_teach_prds_v teach_periods,
1158: (SELECT base_id,
1159: ld_cal_type,
1160: ld_sequence_number
1161: FROM igf_aw_coa_itm_terms
1162: WHERE base_id = cp_base_id
1163: GROUP BY base_id,ld_cal_type,ld_sequence_number) coaterms,
1164: igf_aw_awd_dist_plans dp,
1165: igf_aw_awd_prd_term aprd

Line 1272: FROM igf_aw_coa_itm_terms

1268: igf_aw_dp_teach_prds_v teach_periods,
1269: (SELECT base_id,
1270: ld_cal_type,
1271: ld_sequence_number
1272: FROM igf_aw_coa_itm_terms
1273: WHERE base_id = cp_base_id
1274: GROUP BY base_id,ld_cal_type, ld_sequence_number) coaterms
1275: WHERE terms.adplans_id = cp_adplans_id
1276: AND terms.adterms_id = teach_periods.adterms_id

Line 1332: FROM igf_aw_coa_itm_terms

1328: igf_aw_dp_teach_prds_v teach_periods,
1329: (SELECT base_id,
1330: ld_cal_type,
1331: ld_sequence_number
1332: FROM igf_aw_coa_itm_terms
1333: WHERE base_id = cp_base_id
1334: GROUP BY base_id,ld_cal_type,ld_sequence_number) coaterms
1335: WHERE terms.adplans_id = cp_adplans_id
1336: AND terms.adterms_id = teach_periods.adterms_id

Line 1405: FROM igf_aw_coa_itm_terms

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
1406: WHERE base_id = cp_base_id
1407: GROUP BY base_id,ld_cal_type,ld_sequence_number) coaterms
1408: WHERE terms.adplans_id = cp_adplans_id
1409: AND coaterms.ld_cal_type = terms.ld_cal_type

Line 1425: FROM igf_aw_coa_itm_terms coa_terms,

1421: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1422: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
1423: ) IS
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

Line 1443: FROM igf_aw_coa_itm_terms coa_terms,

1439: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1440: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1441: ) IS
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

Line 1476: FROM igf_aw_coa_itm_terms

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
1477: WHERE base_id = cp_base_id
1478: GROUP BY base_id,ld_cal_type,ld_sequence_number) coaterms,
1479: igf_aw_awd_prd_term aprd,
1480: igf_ap_fa_base_rec_all fa

Line 4385: FROM igf_aw_coa_itm_terms

4381: igf_aw_dp_teach_prds teach_periods,
4382: (SELECT base_id,
4383: ld_cal_type,
4384: ld_sequence_number
4385: FROM igf_aw_coa_itm_terms
4386: WHERE base_id = p_base_id
4387: GROUP BY base_id,ld_cal_type,ld_sequence_number) coaterms
4388: WHERE terms.adplans_id = p_adplans_id
4389: AND terms.adterms_id = teach_periods.adterms_id

Line 4403: FROM igf_aw_coa_itm_terms

4399: igf_ap_fa_base_rec_all fa,
4400: (SELECT base_id,
4401: ld_cal_type,
4402: ld_sequence_number
4403: FROM igf_aw_coa_itm_terms
4404: WHERE base_id = p_base_id
4405: GROUP BY base_id, ld_cal_type, ld_sequence_number) coaterms
4406: WHERE terms.adplans_id = p_adplans_id
4407: AND terms.adterms_id = teach_periods.adterms_id

Line 4462: FROM igf_aw_coa_itm_terms

4458: igf_aw_dp_teach_prds teach_periods,
4459: (SELECT base_id,
4460: ld_cal_type,
4461: ld_sequence_number
4462: FROM igf_aw_coa_itm_terms
4463: WHERE base_id = p_base_id
4464: GROUP BY base_id,ld_cal_type,ld_sequence_number) coaterms
4465: WHERE terms.adplans_id = p_adplans_id
4466: AND terms.adterms_id = teach_periods.adterms_id

Line 4478: FROM igf_aw_coa_itm_terms

4474: igf_aw_dp_teach_prds teach_periods,
4475: (SELECT base_id,
4476: ld_cal_type,
4477: ld_sequence_number
4478: FROM igf_aw_coa_itm_terms
4479: WHERE base_id = p_base_id
4480: GROUP BY base_id,ld_cal_type,ld_sequence_number) coaterms,
4481: igf_ap_fa_base_rec_all fa,
4482: igf_aw_awd_prd_term aprd