DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_DATAPUMP_ENTITY dependencies on PER_BUSINESS_GROUPS

Line 57: l_business_group_country_code per_business_groups.name%type;

53: l_enterprise_hq_country per_ri_config_information.config_information1%type;
54: l_hr_enterprise_primary_indust per_ri_config_information.config_information1%type;
55: l_enterprise_location_id per_ri_config_information.config_information1%type;
56:
57: l_business_group_country_code per_business_groups.name%type;
58: l_business_group_name per_business_groups.name%type;
59: l_ent_location_code per_ri_config_locations.description%type; -- fix for 4457389
60:
61:

Line 58: l_business_group_name per_business_groups.name%type;

54: l_hr_enterprise_primary_indust per_ri_config_information.config_information1%type;
55: l_enterprise_location_id per_ri_config_information.config_information1%type;
56:
57: l_business_group_country_code per_business_groups.name%type;
58: l_business_group_name per_business_groups.name%type;
59: l_ent_location_code per_ri_config_locations.description%type; -- fix for 4457389
60:
61:
62: l_hr_legal_mand_org_info_types boolean;

Line 96: per_business_groups where business_group_id =

92: l_enterprise_id := null;
93: END;
94:
95: select legislation_code into l_selected_country_code from
96: per_business_groups where business_group_id =
97: fnd_profile.value('PER_BUSINESS_GROUP_ID');
98:
99: select name into l_selected_country_name from per_business_groups
100: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');

Line 99: select name into l_selected_country_name from per_business_groups

95: select legislation_code into l_selected_country_code from
96: per_business_groups where business_group_id =
97: fnd_profile.value('PER_BUSINESS_GROUP_ID');
98:
99: select name into l_selected_country_name from per_business_groups
100: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
101: open csr_config_enterprise(p_configuration_code);
102:
103: fetch csr_config_enterprise into

Line 357: l_business_group_country_code per_business_groups.name%type;

353: l_operating_company_short_name per_ri_config_information.config_information1%type;
354: l_operating_company_hq_country per_ri_config_information.config_information1%type;
355: l_operating_comp_location_id per_ri_config_information.config_information1%type;
356:
357: l_business_group_country_code per_business_groups.name%type;
358: l_business_group_name per_business_groups.name%type;
359: l_oc_location_code per_ri_config_locations.description%type; -- fix for 4457389
360: l_enterprise_name per_ri_config_information.config_information1%type;
361:

Line 358: l_business_group_name per_business_groups.name%type;

354: l_operating_company_hq_country per_ri_config_information.config_information1%type;
355: l_operating_comp_location_id per_ri_config_information.config_information1%type;
356:
357: l_business_group_country_code per_business_groups.name%type;
358: l_business_group_name per_business_groups.name%type;
359: l_oc_location_code per_ri_config_locations.description%type; -- fix for 4457389
360: l_enterprise_name per_ri_config_information.config_information1%type;
361:
362: l_oc_count number(10) := 0;

Line 394: per_business_groups where business_group_id =

390: l_enterprise_id := null;
391: END;
392:
393: select legislation_code into l_selected_country_code from
394: per_business_groups where business_group_id =
395: fnd_profile.value('PER_BUSINESS_GROUP_ID');
396:
397: select name into l_selected_country_name from per_business_groups
398: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');

Line 397: select name into l_selected_country_name from per_business_groups

393: select legislation_code into l_selected_country_code from
394: per_business_groups where business_group_id =
395: fnd_profile.value('PER_BUSINESS_GROUP_ID');
396:
397: select name into l_selected_country_name from per_business_groups
398: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
399:
400: open csr_config_oper_comp(p_configuration_code);
401:

Line 633: l_business_group_country_code per_business_groups.name%type;

629: l_proc varchar2(72) := g_package ||'create_le_batch_lines';
630: l_log_message varchar2(360);
631: l_error_message varchar2(360);
632:
633: l_business_group_country_code per_business_groups.name%type;
634: l_business_group_name per_business_groups.name%type;
635: l_le_location_code per_ri_config_locations.description%type; -- fix for 4457389
636: l_mandatory_org_info_types boolean default true;
637: l_multi_tenancy boolean := false;

Line 634: l_business_group_name per_business_groups.name%type;

630: l_log_message varchar2(360);
631: l_error_message varchar2(360);
632:
633: l_business_group_country_code per_business_groups.name%type;
634: l_business_group_name per_business_groups.name%type;
635: l_le_location_code per_ri_config_locations.description%type; -- fix for 4457389
636: l_mandatory_org_info_types boolean default true;
637: l_multi_tenancy boolean := false;
638: l_system_model varchar2(10) := 'N';

Line 663: per_business_groups where business_group_id =

659: l_enterprise_id := null;
660: END;
661:
662: select legislation_code into l_selected_country_code from
663: per_business_groups where business_group_id =
664: fnd_profile.value('PER_BUSINESS_GROUP_ID');
665:
666: select name into l_selected_country_name from per_business_groups
667: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');

Line 666: select name into l_selected_country_name from per_business_groups

662: select legislation_code into l_selected_country_code from
663: per_business_groups where business_group_id =
664: fnd_profile.value('PER_BUSINESS_GROUP_ID');
665:
666: select name into l_selected_country_name from per_business_groups
667: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
668:
669: open csr_config_legal_entity(p_configuration_code);
670:

Line 1260: l_legislation_code per_business_groups.legislation_code%type;

1256: l_bg_country_name per_ri_config_information.config_information1%type;
1257: l_enterprise_bg_country_code per_ri_config_information.config_information2%type;
1258: l_business_group_name hr_all_organization_units.name%type;
1259: l_batch_header_id number(15);
1260: l_legislation_code per_business_groups.legislation_code%type;
1261: l_job_flex_stru_code varchar2(30);
1262: l_position_flex_stru_code varchar2(30);
1263: l_grade_flex_stru_code varchar2(30);
1264: l_group_flex_stru_code varchar2(30);

Line 1286: l_country_selected PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPe;

1282:
1283: l_multi_tenancy boolean default false;
1284: l_system_model varchar2(10) := 'N';
1285: l_sec_group_id varchar2(10);
1286: l_country_selected PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPe;
1287: l_enterprise_id number(9);
1288:
1289: BEGIN
1290: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1292: select legislation_code into l_country_selected from per_business_groups

1288:
1289: BEGIN
1290: hr_utility.set_location('Entering:'|| l_proc, 10);
1291:
1292: select legislation_code into l_country_selected from per_business_groups
1293: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
1294:
1295: l_multi_tenancy := hr_multi_tenancy_pkg.is_multi_tenant_system;
1296: l_sec_group_id := fnd_global.security_group_id;