[Home] [Help]
505: , f.description
506: , f.formula_text
507: , f.formula_type_name
508: , f.object_version_number
509: from pay_shadow_formulas f
510: , pay_shadow_element_types et
511: where et.template_id = p_template_id
512: and et.payroll_formula_id is not null
513: and f.formula_id = et.payroll_formula_id
522: , f.description
523: , f.formula_text
524: , f.formula_type_name
525: , f.object_version_number
526: from pay_shadow_formulas f
527: , pay_shadow_element_types et
528: , pay_shadow_input_values iv
529: where et.template_id = p_template_id
530: and et.element_type_id = iv.element_type_id
541: , f.description
542: , f.formula_text
543: , f.formula_type_name
544: , f.object_version_number
545: from pay_shadow_formulas f
546: , pay_template_ff_usages tfu
547: where tfu.template_id = p_template_id
548: and f.formula_id = tfu.formula_id
549: for update of f.formula_id;
3439: ------------------------------
3440: delete from pay_shadow_element_types
3441: where template_id = p_template_id;
3442: -------------------------
3443: -- pay_shadow_formulas --
3444: -------------------------
3445: --
3446: -- It may not be as fast, but using the formulas table gives the most
3447: -- maintainable code when it comes to deleting the template's formulas.
3474:
3475: FUNCTION get_shadow_formula_name(p_formula_id in number)
3476: return varchar2 is
3477:
3478: l_formula_name pay_shadow_formulas.formula_name%TYPE;
3479:
3480: CURSOR cur_get_formula_name IS
3481: SELECT formula_name
3482: FROM pay_shadow_formulas
3478: l_formula_name pay_shadow_formulas.formula_name%TYPE;
3479:
3480: CURSOR cur_get_formula_name IS
3481: SELECT formula_name
3482: FROM pay_shadow_formulas
3483: WHERE formula_id = p_formula_id;
3484:
3485: BEGIN
3486: OPEN cur_get_formula_name;