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.

[Home] [Help]

APPS.IGF_AW_PACKAGING dependencies on IGF_AW_DP_TERMS

Line 367: igf_aw_dp_terms terms,

363: ) IS
364: SELECT COUNT(tp.adteach_id) tp,
365: COUNT(DISTINCT terms.adterms_id) terms
366: FROM igf_aw_dp_teach_prds tp,
367: igf_aw_dp_terms terms,
368: igf_aw_awd_dist_plans dp,
369: igf_aw_awd_prd_term aprd
370: WHERE terms.adterms_id = tp.adterms_id
371: AND terms.adplans_id = cp_adplans_id

Line 387: igf_aw_dp_terms terms,

383: ) IS
384: SELECT COUNT(tp.adteach_id) tp,
385: COUNT(DISTINCT terms.adterms_id) terms
386: FROM igf_aw_dp_teach_prds tp,
387: igf_aw_dp_terms terms,
388: (SELECT base_id,
389: ld_cal_type,
390: ld_sequence_number
391: FROM igf_aw_coa_itm_terms

Line 5742: FROM igf_aw_dp_terms

5738: SELECT 'x'
5739: FROM dual
5740: WHERE EXISTS (
5741: SELECT DISTINCT ld_cal_type,ld_sequence_number
5742: FROM igf_aw_dp_terms
5743: WHERE adplans_id = cp_adplans_id
5744:
5745: MINUS
5746:

Line 6652: igf_aw_dp_terms adterms,

6648: ) IS
6649: SELECT COUNT(awdt.fund_id) ftotal
6650: FROM igf_aw_award_t awdt,
6651: igf_aw_fund_mast_all fmast,
6652: igf_aw_dp_terms adterms,
6653: igf_aw_awd_prd_term aprd
6654: WHERE fmast.fund_code = x_fund_code
6655: AND awdt.base_id = x_base_id
6656: AND awdt.process_id = x_process_id

Line 8678: FROM igf_aw_dp_terms terms

8674: ) IS
8675: SELECT terms.ld_perct_num,
8676: terms.ld_cal_type,
8677: terms.ld_sequence_number
8678: FROM igf_aw_dp_terms terms
8679: WHERE terms.adplans_id = cp_adplans_id
8680: AND EXISTS (SELECT ld_cal_type,
8681: ld_sequence_number
8682: FROM igf_aw_coa_itm_terms coat

Line 11905: FROM igf_aw_dp_terms terms,

11901: teach_periods.start_date start_dt,
11902: teach_periods.date_offset_cd tp_offset_da,
11903: teach_periods.credit_points_num min_credit_points,
11904: teach_periods.attendance_type_code
11905: FROM igf_aw_dp_terms terms,
11906: igf_aw_dp_teach_prds_v teach_periods,
11907: (SELECT base_id,
11908: ld_cal_type,
11909: ld_sequence_number

Line 11937: FROM igf_aw_dp_terms terms,

11933: teach_periods.start_date start_dt,
11934: teach_periods.date_offset_cd tp_offset_da,
11935: teach_periods.credit_points_num min_credit_points,
11936: teach_periods.attendance_type_code attendance_type_code
11937: FROM igf_aw_dp_terms terms,
11938: igf_aw_dp_teach_prds_v teach_periods
11939: WHERE terms.adplans_id = cp_adplans_id
11940: AND terms.adterms_id = teach_periods.adterms_id
11941: ORDER BY 1;

Line 11959: FROM igf_aw_dp_terms terms,

11955: teach_periods.start_date start_dt,
11956: teach_periods.date_offset_cd tp_offset_da,
11957: teach_periods.credit_points_num min_credit_points,
11958: teach_periods.attendance_type_code
11959: FROM igf_aw_dp_terms terms,
11960: igf_aw_dp_teach_prds_v teach_periods,
11961: (SELECT base_id,
11962: ld_cal_type,
11963: ld_sequence_number

Line 11990: FROM igf_aw_dp_terms terms,

11986: teach_periods.start_date start_dt,
11987: teach_periods.date_offset_cd tp_offset_da,
11988: teach_periods.credit_points_num min_credit_points,
11989: teach_periods.attendance_type_code attendance_type_code
11990: FROM igf_aw_dp_terms terms,
11991: igf_aw_dp_teach_prds_v teach_periods
11992: WHERE terms.adplans_id = cp_adplans_id
11993: AND terms.adterms_id = teach_periods.adterms_id
11994: ORDER BY 1;

Line 12002: FROM igf_aw_dp_terms terms,

11998: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
11999: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
12000: ) IS
12001: SELECT COUNT(*)
12002: FROM igf_aw_dp_terms terms,
12003: (SELECT base_id,
12004: ld_cal_type,
12005: ld_sequence_number
12006: FROM igf_aw_coa_itm_terms

Line 12039: FROM igf_aw_dp_terms terms,

12035: teach_periods.start_date start_dt,
12036: teach_periods.date_offset_cd tp_offset_da,
12037: teach_periods.credit_points_num min_credit_points,
12038: teach_periods.attendance_type_code
12039: FROM igf_aw_dp_terms terms,
12040: igf_aw_dp_teach_prds_v teach_periods,
12041: (SELECT base_id,
12042: ld_cal_type,
12043: ld_sequence_number,

Line 12061: igf_aw_dp_terms terms,

12057: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
12058: ) IS
12059: SELECT SUM(amount) coa
12060: FROM igf_aw_coa_itm_terms coa_terms,
12061: igf_aw_dp_terms terms,
12062: igf_aw_awd_dist_plans adplans,
12063: igf_aw_awd_prd_term aprd
12064: WHERE terms.ld_cal_type = coa_terms.ld_cal_type
12065: AND terms.ld_sequence_number = coa_terms.ld_sequence_number