DBA Data[Home] [Help]

APPS.HR_USER_INIT_DEDN dependencies on PER_BUSINESS_GROUPS

Line 228: per_business_groups.name%TYPE

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,

Line 351: v_bg_name per_business_groups.name%TYPE;

347: -- local constants
348: c_end_of_time CONSTANT DATE := TO_DATE('31/12/4712','DD/MM/YYYY');
349:
350: -- local vars
351: v_bg_name per_business_groups.name%TYPE;
352: -- Get from bg short name passed in.
353: v_ele_type_id NUMBER(9); -- insertion of element type.
354: v_primary_class_id NUMBER(9);
355: v_class_lo_priority NUMBER(9);

Line 3588: from per_business_groups

3584: num_suffixes := 23;
3585:
3586: select business_group_id
3587: into v_business_group_id
3588: from per_business_groups
3589: where upper(name) = upper(p_bg_name);
3590:
3591: /* *** WWBug 133133 finish *** */
3592:

Line 3668: from per_business_groups

3664: -- Set "globals": v_bg_name
3665: hr_utility.set_location('hr_user_init_dedn.ins_deduction_template',20);
3666: select name
3667: into v_bg_name
3668: from per_business_groups
3669: where business_group_id = p_bg_id;
3670:
3671: --------------------- Create Balances Types and Defined Balances --------------
3672: --