eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_RI_CONFIG_FND_HR_ENTITY dependencies on PER_BUSINESS_GROUPS

Line 1349: select legislation_code into l_country_selected from per_business_groups

1345:
1346: BEGIN
1347: hr_utility.set_location('Entering:'|| l_proc, 10);
1348:
1349: select legislation_code into l_country_selected from per_business_groups
1350: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
1351:
1352: l_multi_tenancy := hr_multi_tenancy_pkg.is_multi_tenant_system;
1353: l_sec_group_id := fnd_global.security_group_id;

Line 1558: select legislation_code into l_country_selected from per_business_groups

1554: l_sec_group_id varchar2(10);
1555: BEGIN
1556: hr_utility.set_location('Entering:'|| l_proc, 10);
1557:
1558: select legislation_code into l_country_selected from per_business_groups
1559: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
1560:
1561: l_multi_tenancy := hr_multi_tenancy_pkg.is_multi_tenant_system;
1562: l_sec_group_id := fnd_global.security_group_id;

Line 1764: select legislation_code into l_country_selected from per_business_groups

1760: l_sec_group_id varchar2(10);
1761: BEGIN
1762: hr_utility.set_location('Entering:'|| l_proc, 10);
1763:
1764: select legislation_code into l_country_selected from per_business_groups
1765: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
1766:
1767: l_multi_tenancy := hr_multi_tenancy_pkg.is_multi_tenant_system;
1768: l_sec_group_id := fnd_global.security_group_id;

Line 3850: l_business_group_name per_business_groups.name%type;

3846: l_hrms boolean default FALSE;
3847: l_benefits boolean default FALSE;
3848: l_self_service boolean default FALSE;
3849:
3850: l_business_group_name per_business_groups.name%type;
3851: l_business_group_name_main per_business_groups.name%type;
3852: l_business_group_name_global per_business_groups.name%type;
3853: l_start_date varchar2(240) := to_char(per_ri_config_fnd_hr_entity.g_config_effective_date,'YYYY/MM/DD');
3854: l_end_date varchar2(240) := to_char(per_ri_config_fnd_hr_entity.g_config_effective_end_date,'YYYY/MM/DD');

Line 3851: l_business_group_name_main per_business_groups.name%type;

3847: l_benefits boolean default FALSE;
3848: l_self_service boolean default FALSE;
3849:
3850: l_business_group_name per_business_groups.name%type;
3851: l_business_group_name_main per_business_groups.name%type;
3852: l_business_group_name_global per_business_groups.name%type;
3853: l_start_date varchar2(240) := to_char(per_ri_config_fnd_hr_entity.g_config_effective_date,'YYYY/MM/DD');
3854: l_end_date varchar2(240) := to_char(per_ri_config_fnd_hr_entity.g_config_effective_end_date,'YYYY/MM/DD');
3855: l_row_count number(9) default 0 ;

Line 3852: l_business_group_name_global per_business_groups.name%type;

3848: l_self_service boolean default FALSE;
3849:
3850: l_business_group_name per_business_groups.name%type;
3851: l_business_group_name_main per_business_groups.name%type;
3852: l_business_group_name_global per_business_groups.name%type;
3853: l_start_date varchar2(240) := to_char(per_ri_config_fnd_hr_entity.g_config_effective_date,'YYYY/MM/DD');
3854: l_end_date varchar2(240) := to_char(per_ri_config_fnd_hr_entity.g_config_effective_end_date,'YYYY/MM/DD');
3855: l_row_count number(9) default 0 ;
3856: l_earlier_row_count number(9) default 0 ;

Line 4403: from per_business_groups

4399: and resp.responsibility_key = cp_responsibility_key;
4400:
4401: cursor csr_bg_id (cp_business_group_name in varchar2) IS
4402: select business_group_id
4403: from per_business_groups
4404: where name = cp_business_group_name;
4405:
4406: cursor csr_sg_id (cp_business_group_name in varchar2) IS
4407: select security_profile_id