[Home] [Help]
224: ins_deduction_template and update of
225: pay_element_types_f for
226: termination rule update
227: 24-Jul-2002 ekim 115.9 changed v_bg_name to
228: per_business_groups.name%TYPE
229: 23-DEC-2002 tclewis 115.10 11.5.9. performance changes.
230: 27-DEC-2002 meshah 115.11 fixed gscc warnings.
231: 01-APR-2003 ahanda 115.12 Changed the defined balance creation for
232: ASG_GRE_RUN to save run balance for Primary,
359: -- local constants
360: c_end_of_time CONSTANT DATE := TO_DATE('31/12/4712','DD/MM/YYYY');
361:
362: -- local vars
363: v_bg_name per_business_groups.name%TYPE;
364: -- Get from bg short name passed in.
365: v_ele_type_id NUMBER(9); -- insertion of element type.
366: v_primary_class_id NUMBER(9);
367: v_class_lo_priority NUMBER(9);
3683: num_suffixes := 24;
3684:
3685: select business_group_id
3686: into v_business_group_id
3687: from per_business_groups
3688: where upper(name) = upper(p_bg_name);
3689:
3690: /* *** WWBug 133133 finish *** */
3691:
3763: -- Set "globals": v_bg_name
3764: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',20);
3765: select name
3766: into v_bg_name
3767: from per_business_groups
3768: where business_group_id = p_bg_id;
3769:
3770: --------------------- Create Balances Types and Defined Balances --------------
3771: --