DBA Data[Home] [Help]

APPS.IGF_AP_PROCESS_CORRECTIONS dependencies on IGF_FC_SAR_CD_MST

Line 417: l_sar_number igf_fc_sar_cd_mst.sar_field_number%TYPE ) IS

413: */
414:
415:
416: CURSOR cur_get_sar_name (cp_base_id igf_ap_fa_base_rec.base_id%TYPE ,
417: l_sar_number igf_fc_sar_cd_mst.sar_field_number%TYPE ) IS
418: SELECT sar.sar_field_name
419: FROM igf_ap_batch_aw_map map,
420: igf_ap_fa_base_rec_all fabase ,
421: igf_fc_sar_cd_mst sar

Line 421: igf_fc_sar_cd_mst sar

417: l_sar_number igf_fc_sar_cd_mst.sar_field_number%TYPE ) IS
418: SELECT sar.sar_field_name
419: FROM igf_ap_batch_aw_map map,
420: igf_ap_fa_base_rec_all fabase ,
421: igf_fc_sar_cd_mst sar
422: WHERE fabase.base_id = cp_base_id
423: AND map.ci_cal_type = fabase.ci_cal_type
424: AND map.ci_sequence_number = fabase.ci_sequence_number
425: AND sar.sys_award_year = map.sys_award_year