APPS.PQP_PENSION_EXTRACTS dependencies on FF_FORMULAS_F

Line 2011: CURSOR csr_ff_type ( c_formula_type_id IN ff_formulas_f.formula_id%TYPE

2007: AND b.data_elmt_typ_cd = 'R'
2008: AND a.ext_rcd_id = c_ext_rcd_id
2009: ORDER BY a.seq_num;
2010:
2011: CURSOR csr_ff_type ( c_formula_type_id IN ff_formulas_f.formula_id%TYPE
2012: ,c_effective_date IN DATE) IS
2013: SELECT formula_type_id
2014: FROM ff_formulas_f
2015: WHERE formula_id = c_formula_type_id

Line 2014: FROM ff_formulas_f

2010:
2011: CURSOR csr_ff_type ( c_formula_type_id IN ff_formulas_f.formula_id%TYPE
2012: ,c_effective_date IN DATE) IS
2013: SELECT formula_type_id
2014: FROM ff_formulas_f
2015: WHERE formula_id = c_formula_type_id
2016: AND c_effective_date BETWEEN effective_start_date
2017: AND effective_end_date;
2018: --

Line 2035: l_foumula_type_id ff_formulas_f.formula_id%TYPE;

2031: AND dfn.ext_dfn_id = c_ext_dfn_id;
2032: --
2033: l_ben_params csr_ben%ROWTYPE;
2034: l_proc_name CONSTANT VARCHAR2(150) := g_proc_name ||'Process_Ext_Rslt_Dtl_Rec';
2035: l_foumula_type_id ff_formulas_f.formula_id%TYPE;
2036: l_outputs Ff_Exec.outputs_t;
2037: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;
2038: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;
2039: l_max_len NUMBER;