DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_DATAPUMP_ENTITY dependencies on FND_PROFILE

Line 89: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');

85: l_system_model := hr_multi_tenancy_pkg.get_system_model;
86: end if;
87: BEGIN
88: select enterprise_id into l_enterprise_id from per_ent_security_groups
89: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
90: EXCEPTION
91: WHEN NO_DATA_FOUND THEN
92: l_enterprise_id := null;
93: END;

Line 97: fnd_profile.value('PER_BUSINESS_GROUP_ID');

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');
101: open csr_config_enterprise(p_configuration_code);

Line 100: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');

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
104: l_configuration_code,

Line 387: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');

383: end if;
384:
385: BEGIN
386: select enterprise_id into l_enterprise_id from per_ent_security_groups
387: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
388: EXCEPTION
389: WHEN NO_DATA_FOUND THEN
390: l_enterprise_id := null;
391: END;

Line 395: fnd_profile.value('PER_BUSINESS_GROUP_ID');

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

Line 398: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');

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:
402: loop

Line 656: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');

652: end if;
653:
654: BEGIN
655: select enterprise_id into l_enterprise_id from per_ent_security_groups
656: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
657: EXCEPTION
658: WHEN NO_DATA_FOUND THEN
659: l_enterprise_id := null;
660: END;

Line 664: fnd_profile.value('PER_BUSINESS_GROUP_ID');

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

Line 667: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');

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:
671: l_enterprise_name := per_ri_config_utilities.get_enterprise_name

Line 1293: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');

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;
1297: if l_multi_tenancy then

Line 1314: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');

1310: END IF;
1311:
1312: BEGIN
1313: select enterprise_id into l_enterprise_id from per_ent_security_groups
1314: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
1315: EXCEPTION
1316: WHEN NO_DATA_FOUND THEN
1317: l_enterprise_id := null;
1318: END;