APPS.PQP_NL_PENSION_TEMPLATE dependencies on PAY_SHADOW_FORMULAS

Line 154: from pay_shadow_formulas

150: return Number is
151:
152: cursor csr_get_formula_id is
153: select formula_id
154: from pay_shadow_formulas
155: where formula_name = p_formula_name
156: and business_group_id = p_business_group_id
157: and template_type = 'U';
158:

Line 283: l_formula_name pay_shadow_formulas.formula_name%type;

279: l_bal_obj_ver_number Number;
280: i Number;
281: l_eei_info_id Number;
282: l_ovn_eei Number;
283: l_formula_name pay_shadow_formulas.formula_name%type;
284: l_formula_id Number;
285: l_formula_id1 Number;
286: y Number := 0;
287: l_exists Varchar2(1);

Line 442: from pay_shadow_formulas

438:
439:
440: cursor csr_get_formula_txt (c_formula_id number) is
441: select formula_text
442: from pay_shadow_formulas
443: where formula_id = c_formula_id
444: and template_type = 'U';
445:
446: cursor csr_get_dbi_user_name (c_bal_type_id NUMBER) IS

Line 978: update pay_shadow_formulas

974: l_dbi_user_name := temp_rec.user_name;
975: l_formula_text := replace(l_formula_text,'REPLACE_PT_EE_BAL_PER_YTD',
976: l_dbi_user_name);
977:
978: update pay_shadow_formulas
979: set formula_text = l_formula_text
980: where formula_id = l_shad_formula_id
981: and business_group_id = p_business_group_id;
982:

Line 1004: update pay_shadow_formulas

1000: l_balance_name := temp_rec.balance_name;
1001: l_formula_text := replace(l_formula_text,'REPLACE_PENSION_SALARY_BAL_NAME',
1002: l_balance_name);
1003:
1004: update pay_shadow_formulas
1005: set formula_text = l_formula_text
1006: where formula_id = l_shad_formula_id
1007: and business_group_id = p_business_group_id;
1008:

Line 1018: update pay_shadow_formulas

1014: l_balance_dbi_name := temp_rec.user_name;
1015: l_formula_text := replace(l_formula_text,'REPLACE_PENSION_SALARY_BAL_DBI',
1016: l_balance_dbi_name);
1017:
1018: update pay_shadow_formulas
1019: set formula_text = l_formula_text
1020: where formula_id = l_shad_formula_id
1021: and business_group_id = p_business_group_id;
1022:

Line 1037: update pay_shadow_formulas

1033:
1034: l_formula_text := replace(l_formula_text,'REPLACE_PENSION_SALARY_BAL_NAME',
1035: p_scheme_prefix||' Pension Salary');
1036:
1037: update pay_shadow_formulas
1038: set formula_text = l_formula_text
1039: where formula_id = l_shad_formula_id
1040: and business_group_id = p_business_group_id;
1041:

Line 1112: update pay_shadow_formulas

1108: l_formula_text := replace(l_formula_text,
1109: 'REPLACE_OHT_TEXT',
1110: l_oht_text);
1111:
1112: update pay_shadow_formulas
1113: set formula_text = l_formula_text
1114: where formula_id = l_shad_formula_id
1115: and business_group_id = p_business_group_id;
1116:

Line 1233: update pay_shadow_formulas

1229: l_formula_text1 := replace(l_formula_text1,'REPLACE_PREM_AMT_FORMULA_TEXT',
1230: l_prem_replace_string);
1231:
1232:
1233: update pay_shadow_formulas
1234: set formula_text = l_formula_text1
1235: where formula_id = l_shad_formula_id1
1236: and business_group_id = p_business_group_id;
1237:

Line 1258: update pay_shadow_formulas

1254: l_balance_name := temp_rec.balance_name;
1255: l_formula_text1 := replace(l_formula_text1,'REPLACE_PENSION_SALARY_BAL_NAME',
1256: l_balance_name);
1257:
1258: update pay_shadow_formulas
1259: set formula_text = l_formula_text1
1260: where formula_id = l_shad_formula_id1
1261: and business_group_id = p_business_group_id;
1262:

Line 1272: update pay_shadow_formulas

1268: l_balance_dbi_name := temp_rec.user_name;
1269: l_formula_text1 := replace(l_formula_text1,'REPLACE_PENSION_SALARY_BAL_DBI',
1270: l_balance_dbi_name);
1271:
1272: update pay_shadow_formulas
1273: set formula_text = l_formula_text1
1274: where formula_id = l_shad_formula_id1
1275: and business_group_id = p_business_group_id;
1276:

Line 1291: update pay_shadow_formulas

1287:
1288: l_formula_text1 := replace(l_formula_text1,'REPLACE_PENSION_SALARY_BAL_NAME',
1289: p_scheme_prefix||' Pension Salary');
1290:
1291: update pay_shadow_formulas
1292: set formula_text = l_formula_text1
1293: where formula_id = l_shad_formula_id1
1294: and business_group_id = p_business_group_id;
1295:

Line 1352: update pay_shadow_formulas

1348: l_formula_text1 := replace(l_formula_text1,
1349: 'REPLACE_OHT_TEXT',
1350: l_oht_text);
1351:
1352: update pay_shadow_formulas
1353: set formula_text = l_formula_text1
1354: where formula_id = l_shad_formula_id1
1355: and business_group_id = p_business_group_id;
1356: