APPS.PQP_GB_OMP_TEMPLATE dependencies on PAY_SHADOW_FORMULAS

Line 106: l_formula_name pay_shadow_formulas.formula_name%TYPE;

102: l_eei_info_id NUMBER;
103: l_ovn_eei NUMBER;
104: l_abs_ele_correction_pp NUMBER := p_pri_ele_processing_priority - 50;
105: l_pay_ele_correction_pp NUMBER := p_pay_ele_processing_priority - 50;
106: l_formula_name pay_shadow_formulas.formula_name%TYPE;
107: l_formula_id NUMBER;
108: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
109: l_lookup_meaning fnd_lookup_types_vl.meaning%TYPE;
110: l_abse_days_def VARCHAR2(1);

Line 374: FROM pay_shadow_formulas

370: RETURN NUMBER IS
371:
372: CURSOR csr_get_formula_id IS
373: SELECT formula_id
374: FROM pay_shadow_formulas
375: WHERE formula_name = p_formula_name
376: AND template_type = 'T';
377:
378: l_proc_name VARCHAR2(72) := g_proc_name || 'get_formula_id';