APPS.IGF_AP_EFC_CALC dependencies on IGF_FC_EFC_ALT_FAC

Line 282: CURSOR alt_fact_cur (cp_depend_stat igf_fc_efc_alt_fac.dependent_status%TYPE,

278: l_alternative VARCHAR2(30) ;
279: l_dep VARCHAR2(30) ;
280:
281: -- Cursor for Setup information
282: CURSOR alt_fact_cur (cp_depend_stat igf_fc_efc_alt_fac.dependent_status%TYPE,
283: cp_alternative igf_fc_efc_alt_fac.alternative_code%TYPE) IS
284: SELECT alt.*
285: FROM igf_fc_efc_alt_fac alt
286: WHERE alt.s_award_year = p_sys_award_year

Line 283: cp_alternative igf_fc_efc_alt_fac.alternative_code%TYPE) IS

279: l_dep VARCHAR2(30) ;
280:
281: -- Cursor for Setup information
282: CURSOR alt_fact_cur (cp_depend_stat igf_fc_efc_alt_fac.dependent_status%TYPE,
283: cp_alternative igf_fc_efc_alt_fac.alternative_code%TYPE) IS
284: SELECT alt.*
285: FROM igf_fc_efc_alt_fac alt
286: WHERE alt.s_award_year = p_sys_award_year
287: AND alt.dependent_status = cp_depend_stat

Line 285: FROM igf_fc_efc_alt_fac alt

281: -- Cursor for Setup information
282: CURSOR alt_fact_cur (cp_depend_stat igf_fc_efc_alt_fac.dependent_status%TYPE,
283: cp_alternative igf_fc_efc_alt_fac.alternative_code%TYPE) IS
284: SELECT alt.*
285: FROM igf_fc_efc_alt_fac alt
286: WHERE alt.s_award_year = p_sys_award_year
287: AND alt.dependent_status = cp_depend_stat
288: AND alt.alternative_code = cp_alternative ;
289: