APPS.PQP_GB_SS_ABSENCE_TEMPLATE dependencies on FF_FORMULAS_F

Line 49: ff_formulas_f fra,

45: fra.formula_name,
46: fty.formula_type_id,
47: fty.formula_type_name
48: FROM
49: ff_formulas_f fra,
50: ff_formula_types fty,
51: pay_status_processing_rules_f spr
52: WHERE fty.formula_type_id = fra.formula_type_id
53: AND fra.formula_id = spr.formula_id

Line 68: ff_formulas_f fra,

64: fra.formula_name,
65: fty.formula_type_id,
66: fty.formula_type_name
67: FROM
68: ff_formulas_f fra,
69: ff_formula_types fty
70: WHERE fty.formula_type_id = fra.formula_type_id
71: AND fra.formula_id = p_formula_id;
72:

Line 73: l_ff_id ff_formulas_f.formula_id%TYPE;

69: ff_formula_types fty
70: WHERE fty.formula_type_id = fra.formula_type_id
71: AND fra.formula_id = p_formula_id;
72:
73: l_ff_id ff_formulas_f.formula_id%TYPE;
74: l_ftype_id ff_formula_types.formula_type_id%TYPE;
75: l_ff_name ff_formulas_f.formula_name%TYPE;
76: l_ftype_name ff_formula_types.formula_type_name%TYPE;
77: l_request_id number;

Line 75: l_ff_name ff_formulas_f.formula_name%TYPE;

71: AND fra.formula_id = p_formula_id;
72:
73: l_ff_id ff_formulas_f.formula_id%TYPE;
74: l_ftype_id ff_formula_types.formula_type_id%TYPE;
75: l_ff_name ff_formulas_f.formula_name%TYPE;
76: l_ftype_name ff_formula_types.formula_type_name%TYPE;
77: l_request_id number;
78: l_ben_formulas pqp_gb_gap_ben_formulas.t_formulas;
79: l_error_code number;