DBA Data[Home] [Help]

APPS.IGF_SL_DL_ORIG dependencies on IGF_AP_ISIR_MATCHED

Line 185: igf_ap_isir_matched isr

181: igf_aw_award awd,
182: igf_aw_fund_mast fmast,
183: igf_aw_fund_cat fcat,
184: igf_ap_fa_base_rec fabase,
185: igf_ap_isir_matched isr
186: WHERE
187: fabase.ci_cal_type = cp_cal_type AND
188: fabase.ci_sequence_number = cp_seq_number AND
189: fabase.base_id = awd.base_id AND

Line 599: IGF_AP_ISIR_MATCHED isr

595:
596: CURSOR c_fabase IS
597: SELECT isr.dependency_status dependency_status
598: FROM IGF_AP_FA_BASE_REC fabase,
599: IGF_AP_ISIR_MATCHED isr
600: WHERE
601: fabase.base_id = isr.base_id
602: AND isr.payment_isir = 'Y'
603: AND isr.system_record_type = 'ORIGINAL'