APPS.PAY_NL_LIFE_SAVINGS_TEMPLATE dependencies on PAY_SHADOW_FORMULAS

Line 154: l_formula_name pay_shadow_formulas.formula_name%TYPE;

150: i NUMBER;
151: li NUMBER;
152: l_eei_info_id NUMBER;
153: l_ovn_eei NUMBER;
154: l_formula_name pay_shadow_formulas.formula_name%TYPE;
155: l_formula_id NUMBER;
156: l_formula_id1 NUMBER;
157: y NUMBER := 0;
158: l_exists VARCHAR2(1);

Line 239: FROM pay_shadow_formulas

235: r_pty_rec pqp_pension_types_f%ROWTYPE;
236:
237: CURSOR csr_get_formula_txt (c_formula_id NUMBER) IS
238: SELECT formula_text
239: FROM pay_shadow_formulas
240: WHERE formula_id = c_formula_id
241: AND template_type = 'U';
242:
243: CURSOR csr_get_dbi_user_name (c_bal_type_id NUMBER) IS

Line 1205: UPDATE pay_shadow_formulas

1201: l_formula_text := REPLACE(l_formula_text,
1202: 'REPLACE_PT_EE_CUSTOM_BAL_ASG_RUN',
1203: l_dbi_user_name);
1204:
1205: UPDATE pay_shadow_formulas
1206: SET formula_text = l_formula_text
1207: WHERE formula_id = l_shad_formula_id
1208: AND business_group_id = p_business_group_id;
1209:

Line 1223: UPDATE pay_shadow_formulas

1219: l_formula_text := REPLACE(l_formula_text,
1220: 'REPLACE_PT_EE_CUSTOM_BAL_ASG_RUN',
1221: '0');
1222:
1223: UPDATE pay_shadow_formulas
1224: SET formula_text = l_formula_text
1225: WHERE formula_id = l_shad_formula_id
1226: AND business_group_id = p_business_group_id;
1227:

Line 1253: UPDATE pay_shadow_formulas

1249: END LOOP;
1250: l_formula_text := REPLACE(l_formula_text,'REPLACE_TAX_ZVW_TEXT',
1251: l_tax_si_text);
1252:
1253: UPDATE pay_shadow_formulas
1254: SET formula_text = l_formula_text
1255: WHERE formula_id = l_shad_formula_id
1256: AND business_group_id = p_business_group_id;
1257:

Line 1273: UPDATE pay_shadow_formulas

1269:
1270: l_formula_text := REPLACE(l_formula_text,'REPLACE_TAX_ZVW_TEXT',
1271: l_tax_si_text);
1272:
1273: UPDATE pay_shadow_formulas
1274: SET formula_text = l_formula_text
1275: WHERE formula_id = l_shad_formula_id1
1276: AND business_group_id = p_business_group_id;
1277:

Line 1297: UPDATE pay_shadow_formulas

1293: l_formula_text := REPLACE(l_formula_text,
1294: 'REPLACE_PT_ER_CUSTOM_BAL_ASG_RUN',
1295: l_dbi_user_name);
1296:
1297: UPDATE pay_shadow_formulas
1298: SET formula_text = l_formula_text
1299: WHERE formula_id = l_shad_formula_id1
1300: AND business_group_id = p_business_group_id;
1301:

Line 1314: UPDATE pay_shadow_formulas

1310: l_formula_text := REPLACE(l_formula_text,
1311: 'REPLACE_PT_ER_CUSTOM_BAL_ASG_RUN',
1312: '0');
1313:
1314: UPDATE pay_shadow_formulas
1315: SET formula_text = l_formula_text
1316: WHERE formula_id = l_shad_formula_id1
1317: AND business_group_id = p_business_group_id;
1318: END LOOP;

Line 1379: UPDATE pay_shadow_formulas

1375: END LOOP;
1376: l_formula_text := REPLACE(l_formula_text,'REPLACE_ZVW_TEXT',
1377: l_zvw_text);
1378:
1379: UPDATE pay_shadow_formulas
1380: SET formula_text = l_formula_text
1381: WHERE formula_id = l_shad_formula_id
1382: AND business_group_id = p_business_group_id;
1383:

Line 1391: UPDATE pay_shadow_formulas

1387:
1388: l_formula_text := REPLACE(l_formula_text,'REPLACE_ZVW_TEXT',
1389: l_zvw_text);
1390:
1391: UPDATE pay_shadow_formulas
1392: SET formula_text = l_formula_text
1393: WHERE formula_id = l_shad_formula_id1
1394: AND business_group_id = p_business_group_id;
1395: END LOOP;