APPS.PQP_NL_SAVINGS_TEMPLATE dependencies on PAY_SHADOW_FORMULAS

Line 332: l_formula_name pay_shadow_formulas.formula_name%type;

328: l_bal_obj_ver_number Number;
329: i Number;
330: l_eei_info_id Number;
331: l_ovn_eei Number;
332: l_formula_name pay_shadow_formulas.formula_name%type;
333: l_formula_id Number;
334: l_formula_id1 Number;
335: y Number := 0;
336: l_exists Varchar2(1);

Line 492: from pay_shadow_formulas

488:
489:
490: cursor csr_get_formula_txt (c_formula_id number) is
491: select formula_text
492: from pay_shadow_formulas
493: where formula_id = c_formula_id
494: and template_type = 'U';
495:
496: cursor csr_get_dbi_user_name (c_bal_type_id NUMBER) IS

Line 1276: update pay_shadow_formulas

1272: l_dbi_user_name := temp_rec.user_name;
1273: l_formula_text := replace(l_formula_text,'REPLACE_PT_EE_BAL_PER_YTD',
1274: l_dbi_user_name);
1275:
1276: update pay_shadow_formulas
1277: set formula_text = l_formula_text
1278: where formula_id = l_shad_formula_id
1279: and business_group_id = p_business_group_id;
1280:

Line 1298: update pay_shadow_formulas

1294: END LOOP;
1295: l_formula_text := replace(l_formula_text,'REPLACE_TAX_SI_TEXT',
1296: l_tax_si_text);
1297:
1298: update pay_shadow_formulas
1299: set formula_text = l_formula_text
1300: where formula_id = l_shad_formula_id
1301: and business_group_id = p_business_group_id;
1302:

Line 1419: update pay_shadow_formulas

1415: l_formula_text1 := replace(l_formula_text1,'REPLACE_PREM_AMT_FORMULA_TEXT',
1416: l_prem_replace_string);
1417: hr_utility.set_location('leaving',80);
1418:
1419: update pay_shadow_formulas
1420: set formula_text = l_formula_text1
1421: where formula_id = l_shad_formula_id1
1422: and business_group_id = p_business_group_id;
1423: hr_utility.set_location('leaving',90);

Line 1488: UPDATE pay_shadow_formulas

1484: END LOOP;
1485: l_formula_text := REPLACE(l_formula_text,'REPLACE_ZVW_TEXT',
1486: l_zvw_text);
1487:
1488: UPDATE pay_shadow_formulas
1489: SET formula_text = l_formula_text
1490: WHERE formula_id = l_shad_formula_id
1491: AND business_group_id = p_business_group_id;
1492: