APPS.IGF_AW_PACKAGING dependencies on IGF_AW_COA_ITM_TERMS

Line 391: FROM igf_aw_coa_itm_terms

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
392: WHERE base_id = cp_base_id
393: GROUP BY base_id, ld_cal_type, ld_sequence_number) coaterms,
394: igf_aw_awd_prd_term aprd,
395: igf_aw_awd_dist_plans dp

Line 8682: FROM igf_aw_coa_itm_terms coat

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
8683: WHERE coat.base_id = cp_base_id
8684: AND coat.ld_cal_type = terms.ld_cal_type
8685: AND coat.ld_sequence_number = terms.ld_sequence_number
8686: );

Line 11910: FROM igf_aw_coa_itm_terms

11906: igf_aw_dp_teach_prds_v teach_periods,
11907: (SELECT base_id,
11908: ld_cal_type,
11909: ld_sequence_number
11910: FROM igf_aw_coa_itm_terms
11911: WHERE base_id = cp_base_id
11912: GROUP BY base_id,ld_cal_type,ld_sequence_number) coaterms
11913: WHERE terms.adplans_id = cp_adplans_id
11914: AND terms.adterms_id = teach_periods.adterms_id

Line 11964: FROM igf_aw_coa_itm_terms

11960: igf_aw_dp_teach_prds_v teach_periods,
11961: (SELECT base_id,
11962: ld_cal_type,
11963: ld_sequence_number
11964: FROM igf_aw_coa_itm_terms
11965: WHERE base_id = cp_base_id
11966: GROUP BY base_id,ld_cal_type,ld_sequence_number) coaterms
11967: WHERE terms.adplans_id = cp_adplans_id
11968: AND terms.adterms_id = teach_periods.adterms_id

Line 12006: FROM igf_aw_coa_itm_terms

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
12007: WHERE base_id = cp_base_id
12008: GROUP BY base_id,ld_cal_type,ld_sequence_number) coaterms,
12009: igf_aw_awd_dist_plans adplans,
12010: igf_aw_awd_prd_term aprd

Line 12060: FROM igf_aw_coa_itm_terms coa_terms,

12056: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
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