3786: l_hrms boolean default FALSE;
3787: l_benefits boolean default FALSE;
3788: l_self_service boolean default FALSE;
3789:
3790: l_business_group_name per_business_groups.name%type;
3791: l_business_group_name_main per_business_groups.name%type;
3792: l_business_group_name_global per_business_groups.name%type;
3793: l_start_date varchar2(240) := to_char(per_ri_config_fnd_hr_entity.g_config_effective_date,'YYYY/MM/DD');
3794: l_end_date varchar2(240) := to_char(per_ri_config_fnd_hr_entity.g_config_effective_end_date,'YYYY/MM/DD');
3787: l_benefits boolean default FALSE;
3788: l_self_service boolean default FALSE;
3789:
3790: l_business_group_name per_business_groups.name%type;
3791: l_business_group_name_main per_business_groups.name%type;
3792: l_business_group_name_global per_business_groups.name%type;
3793: l_start_date varchar2(240) := to_char(per_ri_config_fnd_hr_entity.g_config_effective_date,'YYYY/MM/DD');
3794: l_end_date varchar2(240) := to_char(per_ri_config_fnd_hr_entity.g_config_effective_end_date,'YYYY/MM/DD');
3795: l_row_count number(9) default 0 ;
3788: l_self_service boolean default FALSE;
3789:
3790: l_business_group_name per_business_groups.name%type;
3791: l_business_group_name_main per_business_groups.name%type;
3792: l_business_group_name_global per_business_groups.name%type;
3793: l_start_date varchar2(240) := to_char(per_ri_config_fnd_hr_entity.g_config_effective_date,'YYYY/MM/DD');
3794: l_end_date varchar2(240) := to_char(per_ri_config_fnd_hr_entity.g_config_effective_end_date,'YYYY/MM/DD');
3795: l_row_count number(9) default 0 ;
3796: l_earlier_row_count number(9) default 0 ;
4339: and resp.responsibility_key = cp_responsibility_key;
4340:
4341: cursor csr_bg_id (cp_business_group_name in varchar2) IS
4342: select business_group_id
4343: from per_business_groups
4344: where name = cp_business_group_name;
4345:
4346: cursor csr_sg_id (cp_business_group_name in varchar2) IS
4347: select security_profile_id