APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on FF_FORMULAS_F

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

1273: AND a.ext_rcd_id = c_ext_rcd_id
1274: -- AND a.hide_flag = 'N'
1275: ORDER BY a.seq_num;
1276:
1277: CURSOR csr_ff_type ( c_formula_type_id IN ff_formulas_f.formula_id%TYPE
1278: ,c_effective_date IN Date) IS
1279: SELECT formula_type_id
1280: FROM ff_formulas_f
1281: WHERE formula_id = c_formula_type_id

Line 1280: FROM ff_formulas_f

1276:
1277: CURSOR csr_ff_type ( c_formula_type_id IN ff_formulas_f.formula_id%TYPE
1278: ,c_effective_date IN Date) IS
1279: SELECT formula_type_id
1280: FROM ff_formulas_f
1281: WHERE formula_id = c_formula_type_id
1282: AND c_effective_date BETWEEN effective_start_date
1283: AND effective_end_date;
1284:

Line 1296: l_formula_type_id ff_formulas_f.formula_id%TYPE;

1292:
1293:
1294:
1295: l_proc_name Varchar2(150) := g_proc_name ||'Process_Ext_Rslt_Dtl_Rec';
1296: l_formula_type_id ff_formulas_f.formula_id%TYPE;
1297: l_outputs Ff_Exec.outputs_t;
1298: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;
1299: l_ff_value_fmt ben_ext_rslt_dtl.val_01%TYPE;
1300: l_org_id per_all_assignments_f.organization_id%TYPE;