APPS.PQP_NL_PGGM_TEMPLATE dependencies on PAY_SHADOW_FORMULAS

Line 225: l_formula_name pay_shadow_formulas.formula_name%TYPE;

221: i NUMBER;
222: li NUMBER;
223: l_eei_info_id NUMBER;
224: l_ovn_eei NUMBER;
225: l_formula_name pay_shadow_formulas.formula_name%TYPE;
226: l_formula_id NUMBER;
227: l_formula_id1 NUMBER;
228: y NUMBER := 0;
229: l_exists VARCHAR2(1);

Line 299: FROM pay_shadow_formulas

295: r_pty_rec pqp_pension_types_f%ROWTYPE;
296:
297: CURSOR csr_get_formula_txt (c_formula_id NUMBER) IS
298: SELECT formula_text
299: FROM pay_shadow_formulas
300: WHERE formula_id = c_formula_id
301: AND template_type = 'U';
302:
303: CURSOR csr_get_dbi_user_name (c_bal_type_id NUMBER) IS

Line 1202: UPDATE pay_shadow_formulas

1198: l_formula_text := REPLACE(l_formula_text,
1199: 'REPLACE_PT_EE_BAL_PER_YTD',
1200: l_dbi_user_name);
1201:
1202: UPDATE pay_shadow_formulas
1203: SET formula_text = l_formula_text
1204: WHERE formula_id = l_shad_formula_id
1205: AND business_group_id = p_business_group_id;
1206:

Line 1230: UPDATE pay_shadow_formulas

1226: END LOOP;
1227: l_formula_text := REPLACE(l_formula_text,'REPLACE_TAX_SI_TEXT',
1228: l_tax_si_text);
1229:
1230: UPDATE pay_shadow_formulas
1231: SET formula_text = l_formula_text
1232: WHERE formula_id = l_shad_formula_id
1233: AND business_group_id = p_business_group_id;
1234: