APPS.PQP_GB_SS_ABSENCE_TEMPLATE dependencies on FF_FORMULA_TYPES

Line 50: ff_formula_types fty,

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
54: AND spr.assignment_status_type_id IS NULL

Line 69: ff_formula_types fty

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:
73: l_ff_id ff_formulas_f.formula_id%TYPE;

Line 74: l_ftype_id ff_formula_types.formula_type_id%TYPE;

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;
78: l_ben_formulas pqp_gb_gap_ben_formulas.t_formulas;

Line 76: l_ftype_name ff_formula_types.formula_type_name%TYPE;

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;
80: l_err_msg VARCHAR2(100);