APPS.PQP_CANDM_UPG dependencies on PAY_SHADOW_FORMULAS

Line 20: l_sh_formula_name pay_shadow_formulas.formula_name%TYPE;

16: l_temp LONG;--varchar2(32000);
17: l_temp_addl LONG;
18: l_result_name VARCHAR2(80);
19: l_flag Varchar2(1):='N';
20: l_sh_formula_name pay_shadow_formulas.formula_name%TYPE;
21: l_sh_formula_text varchar2(32727);
22: l_object_version_number NUMBER;
23: l_suffix VARCHAR2(80);
24: l_error NUMBER:=0;

Line 41: FROM pay_shadow_formulas

37:
38: /*Gets Existing car mileage formula text*/
39: CURSOR c_sh_formula_text IS
40: SELECT formula_name,formula_text
41: FROM pay_shadow_formulas
42: where template_type='T'
43: AND formula_name
44: IN ( '_MILEAGE_CLAIM_PVT'
45: );