APPS.PQP_NL_PENSION_TEMPLATE dependencies on PAY_SHADOW_FORMULAS

Line 156: from pay_shadow_formulas

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

Line 285: l_formula_name pay_shadow_formulas.formula_name%type;

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

Line 444: from pay_shadow_formulas

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

Line 980: update pay_shadow_formulas

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

Line 1006: update pay_shadow_formulas

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

Line 1020: update pay_shadow_formulas

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

Line 1039: update pay_shadow_formulas

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

Line 1114: update pay_shadow_formulas

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

Line 1235: update pay_shadow_formulas

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

Line 1260: update pay_shadow_formulas

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

Line 1274: update pay_shadow_formulas

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

Line 1293: update pay_shadow_formulas

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

Line 1354: update pay_shadow_formulas

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