APPS.IGF_AP_LG_VER_IMP dependencies on IGF_FC_SAR_CD_MST

Line 492: CURSOR c_get_sar_num ( cp_sys_award_year igf_fc_sar_cd_mst.sys_award_year%TYPE,

488: WHERE cal_type = cp_ci_cal_type
489: AND sequence_number = cp_ci_sequence_number ;
490:
491: -- check SAR Field Number done
492: CURSOR c_get_sar_num ( cp_sys_award_year igf_fc_sar_cd_mst.sys_award_year%TYPE,
493: cp_sar_name igf_fc_sar_cd_mst.sar_field_name%TYPE) IS
494: SELECT sar_field_number
495: FROM igf_fc_sar_cd_mst
496: WHERE sys_award_year = cp_sys_award_year

Line 493: cp_sar_name igf_fc_sar_cd_mst.sar_field_name%TYPE) IS

489: AND sequence_number = cp_ci_sequence_number ;
490:
491: -- check SAR Field Number done
492: CURSOR c_get_sar_num ( cp_sys_award_year igf_fc_sar_cd_mst.sys_award_year%TYPE,
493: cp_sar_name igf_fc_sar_cd_mst.sar_field_name%TYPE) IS
494: SELECT sar_field_number
495: FROM igf_fc_sar_cd_mst
496: WHERE sys_award_year = cp_sys_award_year
497: AND sar_field_name = cp_sar_name ;

Line 495: FROM igf_fc_sar_cd_mst

491: -- check SAR Field Number done
492: CURSOR c_get_sar_num ( cp_sys_award_year igf_fc_sar_cd_mst.sys_award_year%TYPE,
493: cp_sar_name igf_fc_sar_cd_mst.sar_field_name%TYPE) IS
494: SELECT sar_field_number
495: FROM igf_fc_sar_cd_mst
496: WHERE sys_award_year = cp_sys_award_year
497: AND sar_field_name = cp_sar_name ;
498: l_sar_num igf_fc_sar_cd_mst.sar_field_number%TYPE;
499:

Line 498: l_sar_num igf_fc_sar_cd_mst.sar_field_number%TYPE;

494: SELECT sar_field_number
495: FROM igf_fc_sar_cd_mst
496: WHERE sys_award_year = cp_sys_award_year
497: AND sar_field_name = cp_sar_name ;
498: l_sar_num igf_fc_sar_cd_mst.sar_field_number%TYPE;
499:
500:
501: -- get active and payment ISIR
502: CURSOR c_act_pay_isir ( cp_base_id igf_ap_isir_matched.base_id%TYPE ) IS