APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on PAY_SHADOW_FORMULAS

Line 1448: FROM pay_shadow_formulas

1444: -- Cursor to retrieve the formula information
1445: CURSOR csr_get_formula_info
1446: IS
1447: SELECT formula_id
1448: FROM pay_shadow_formulas
1449: WHERE formula_name = p_formula_name
1450: AND business_group_id = p_business_group_id
1451: AND template_type = 'U';
1452:

Line 1497: FROM pay_shadow_formulas

1493: -- Cursor to retrieve the formula information
1494: CURSOR csr_get_formula_info
1495: IS
1496: SELECT formula_text
1497: FROM pay_shadow_formulas
1498: WHERE formula_id = p_formula_id;
1499:
1500: l_proc_name VARCHAR2 (80)
1501: := g_proc_name

Line 1505: l_formula_text pay_shadow_formulas.formula_text%type;

1501: := g_proc_name
1502: || 'update_shadow_formula';
1503: /* Bug No:13520124
1504: l_formula_text LONG;*/
1505: l_formula_text pay_shadow_formulas.formula_text%type;
1506: --
1507: BEGIN
1508: --
1509: hr_utility.set_location ( 'Entering: '

Line 1529: UPDATE pay_shadow_formulas

1525: --
1526: hr_utility.set_location (l_proc_name, 20);
1527:
1528: --
1529: UPDATE pay_shadow_formulas
1530: SET formula_text = l_formula_text
1531: WHERE formula_id = p_formula_id;
1532:
1533: --