DBA Data[Home] [Help]

APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on PAY_SHADOW_FORMULAS

Line 1452: FROM pay_shadow_formulas

1448: -- Cursor to retrieve the formula information
1449: CURSOR csr_get_formula_info
1450: IS
1451: SELECT formula_id
1452: FROM pay_shadow_formulas
1453: WHERE formula_name = p_formula_name
1454: AND business_group_id = p_business_group_id
1455: AND template_type = 'U';
1456:

Line 1501: FROM pay_shadow_formulas

1497: -- Cursor to retrieve the formula information
1498: CURSOR csr_get_formula_info
1499: IS
1500: SELECT formula_text
1501: FROM pay_shadow_formulas
1502: WHERE formula_id = p_formula_id;
1503:
1504: l_proc_name VARCHAR2 (80)
1505: := g_proc_name

Line 1531: UPDATE pay_shadow_formulas

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