APPS.IGF_AW_GEN_004 dependencies on IGF_AP_CSS_PROFILE_ALL

Line 342: FROM igf_ap_css_profile_all

338: cp_base_id igf_aw_award_all.base_id%TYPE
339: ) IS
340: SELECT coa_duration_num,
341: coa_duration_efc_amt
342: FROM igf_ap_css_profile_all
343: WHERE active_profile = 'Y'
344: AND base_id = cp_base_id;
345:
346: l_im_efc c_im_efc%ROWTYPE;

Line 347: l_im_efc_amt igf_ap_css_profile_all.coa_duration_efc_amt%TYPE := NULL;

343: WHERE active_profile = 'Y'
344: AND base_id = cp_base_id;
345:
346: l_im_efc c_im_efc%ROWTYPE;
347: l_im_efc_amt igf_ap_css_profile_all.coa_duration_efc_amt%TYPE := NULL;
348:
349: BEGIN
350: IF p_awd_prd_code IS NULL THEN
351: OPEN c_im_efc(l_base_id);