DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_FND_HR_ENTITY dependencies on PER_BUSINESS_GROUPS

Line 3790: l_business_group_name per_business_groups.name%type;

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');

Line 3791: l_business_group_name_main per_business_groups.name%type;

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 ;

Line 3792: l_business_group_name_global per_business_groups.name%type;

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 ;

Line 4343: from per_business_groups

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