APPS.PQP_US_SRS_EXTRACTS dependencies on FF_FORMULAS_F

Line 1391: Cursor csr_ff_type ( c_formula_type_id in ff_formulas_f.formula_id%TYPE

1387: and b.data_elmt_typ_cd = 'R'
1388: and a.ext_rcd_id = c_ext_rcd_id
1389: order by a.seq_num;
1390:
1391: Cursor csr_ff_type ( c_formula_type_id in ff_formulas_f.formula_id%TYPE
1392: ,c_effective_date in date) Is
1393: Select formula_type_id
1394: from ff_formulas_f
1395: where formula_id = c_formula_type_id

Line 1394: from ff_formulas_f

1390:
1391: Cursor csr_ff_type ( c_formula_type_id in ff_formulas_f.formula_id%TYPE
1392: ,c_effective_date in date) Is
1393: Select formula_type_id
1394: from ff_formulas_f
1395: where formula_id = c_formula_type_id
1396: and c_effective_date between effective_start_date
1397: and effective_end_date;
1398:

Line 1403: l_foumula_type_id ff_formulas_f.formula_id%TYPE;

1399: -- Variable Declaration
1400: l_rec_serial_num NUMBER(3);
1401: l_itr NUMBER(3);
1402: l_next_itr NUMBER(3);
1403: l_foumula_type_id ff_formulas_f.formula_id%TYPE;
1404: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1405: l_organization_id per_all_assignments_f.organization_id%TYPE;
1406: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1407: l_ff_value ben_ext_rslt_dtl.val_01%TYPE;