APPS.PQP_NL_ABP_TEMPLATE dependencies on PAY_SHADOW_FORMULAS

Line 135: l_formula_name pay_shadow_formulas.formula_name%TYPE;

131: l_bal_obj_ver_NUMBER NUMBER;
132: i NUMBER;
133: l_eei_info_id NUMBER;
134: l_ovn_eei NUMBER;
135: l_formula_name pay_shadow_formulas.formula_name%TYPE;
136: l_formula_id NUMBER;
137: l_formula_id1 NUMBER;
138: y NUMBER := 0;
139: l_exists VARCHAR2(1);

Line 196: FROM pay_shadow_formulas

192: r_pty_rec pqp_pension_types_f%ROWTYPE;
193:
194: CURSOR csr_get_formula_txt (c_formula_id NUMBER) IS
195: SELECT formula_text
196: FROM pay_shadow_formulas
197: WHERE formula_id = c_formula_id
198: AND template_type = 'U';
199:
200: CURSOR csr_get_dbi_user_name (c_bal_type_id NUMBER) IS

Line 1306: UPDATE pay_shadow_formulas

1302: l_formula_text := REPLACE(l_formula_text,
1303: 'REPLACE_PT_EE_BAL_PER_YTD',
1304: l_dbi_user_name);
1305:
1306: UPDATE pay_shadow_formulas
1307: SET formula_text = l_formula_text
1308: WHERE formula_id = l_shad_formula_id
1309: AND business_group_id = p_business_group_id;
1310:

Line 1328: UPDATE pay_shadow_formulas

1324: END LOOP;
1325: l_formula_text := REPLACE(l_formula_text,'REPLACE_TAX_SI_TEXT',
1326: l_tax_si_text);
1327:
1328: UPDATE pay_shadow_formulas
1329: SET formula_text = l_formula_text
1330: WHERE formula_id = l_shad_formula_id
1331: AND business_group_id = p_business_group_id;
1332:

Line 1352: UPDATE pay_shadow_formulas

1348:
1349: l_formula_text := REPLACE(l_formula_text,'REPLACE_ABSENCE_TEXT',
1350: l_abs_text);
1351:
1352: UPDATE pay_shadow_formulas
1353: SET formula_text = l_formula_text
1354: WHERE formula_id = l_shad_formula_id
1355: AND business_group_id = p_business_group_id;
1356:

Line 1381: UPDATE pay_shadow_formulas

1377: l_formula_text1 := REPLACE(l_formula_text1,
1378: 'REPLACE_PT_ER_BAL_PER_YTD',
1379: l_dbi_user_name);
1380:
1381: UPDATE pay_shadow_formulas
1382: SET formula_text = l_formula_text1
1383: WHERE formula_id = l_shad_formula_id1
1384: AND business_group_id = p_business_group_id;
1385:

Line 1406: UPDATE pay_shadow_formulas

1402: END LOOP;
1403: l_formula_text1 := REPLACE(l_formula_text1,'REPLACE_ABSENCE_TEXT',
1404: l_abs_text);
1405:
1406: UPDATE pay_shadow_formulas
1407: SET formula_text = l_formula_text1
1408: WHERE formula_id = l_shad_formula_id1
1409: AND business_group_id = p_business_group_id;
1410: