APPS.PQP_CANDM_UPG dependencies on PAY_SHADOW_FORMULAS

Line 11: function get_version(p_formula_text pay_shadow_formulas.formula_text%TYPE) RETURN VARCHAR2

7:
8: --
9: */
10:
11: function get_version(p_formula_text pay_shadow_formulas.formula_text%TYPE) RETURN VARCHAR2
12: as
13: l_ver_start_idx INTEGER;
14: l_ver_end_idx INTEGER;
15: l_version VARCHAR2(100);

Line 95: FROM pay_shadow_formulas

91: -- Get the shadow formula details
92: CURSOR c_sh_formula_details IS
93: SELECT formula_name
94: ,formula_text
95: FROM pay_shadow_formulas
96: WHERE template_type='T'
97: AND formula_name like p_formula_cat;
98:
99: -- Get the Actual formula details

Line 124: l_sh_formula_name pay_shadow_formulas.formula_name%TYPE;

120: AND SYSDATE BETWEEN fff.effective_start_date and fff.effective_end_date
121: ORDER BY fff.formula_id,fff.effective_start_date ;
122:
123:
124: l_sh_formula_name pay_shadow_formulas.formula_name%TYPE;
125: l_sh_formula_text pay_shadow_formulas.formula_text%TYPE;
126: l_sh_formula_ver VARCHAR2(50);
127:
128: l_formula c_formula_details%ROWTYPE;

Line 125: l_sh_formula_text pay_shadow_formulas.formula_text%TYPE;

121: ORDER BY fff.formula_id,fff.effective_start_date ;
122:
123:
124: l_sh_formula_name pay_shadow_formulas.formula_name%TYPE;
125: l_sh_formula_text pay_shadow_formulas.formula_text%TYPE;
126: l_sh_formula_ver VARCHAR2(50);
127:
128: l_formula c_formula_details%ROWTYPE;
129: l_formula_ver VARCHAR2(50);