DBA Data[Home] [Help]

APPS.IGF_AP_GEN dependencies on IGF_AW_COA_ITM_TERMS

Line 624: igf_aw_coa_itm_terms coa

620: 12, PRIMARY_ALTERNATE_MONTH_12 ) ) efc
621: FROM igf_ap_isir_matched_all isir,
622: igf_ap_fa_base_rec_all fa,
623: igs_ca_inst_all ca,
624: igf_aw_coa_itm_terms coa
625: WHERE coa.base_id = fa.base_id
626: AND coa.base_id = isir.base_id
627: AND fa.base_id = cp_base_id
628: AND isir.isir_id = cp_isir_id

Line 680: FROM igf_aw_coa_itm_terms coait,

676: cp_ld_start_dt IN DATE,
677: cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
678: )IS
679: SELECT SUM(coait.amount) coa
680: FROM igf_aw_coa_itm_terms coait,
681: igs_ca_inst ca
682: WHERE ca.cal_type = coait.ld_cal_type
683: AND ca.sequence_number = coait.ld_sequence_number
684: AND ca.start_dt <= cp_ld_start_dt

Line 732: FROM igf_aw_coa_itm_terms coait,

728: cp_ld_start_dt IN DATE,
729: cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
730: )IS
731: SELECT SUM(coait.amount) coa
732: FROM igf_aw_coa_itm_terms coait,
733: igs_ca_inst ca
734: WHERE ca.cal_type = coait.ld_cal_type
735: AND ca.sequence_number = coait.ld_sequence_number
736: AND ca.start_dt = cp_ld_start_dt