DBA Data[Home] [Help]

APPS.OTA_COMPETENCE_SS dependencies on OTA_GENERAL

Line 360: --l_business_group_id := ota_general.get_business_group_id;

356:
357: OPEN get_person_business_grp; ----Bug#6869342
358: FETCH get_person_business_grp INTO l_business_group_id;
359: CLOSE get_person_business_grp;
360: --l_business_group_id := ota_general.get_business_group_id;
361:
362:
363: end if;
364: --

Line 1546: business_group_id = ota_general.get_business_group_id);

1542: Select 1 from
1543: per_all_people_f
1544: where person_id= p_person_id
1545: and (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is not null or --Bug#6869342
1546: business_group_id = ota_general.get_business_group_id);
1547:
1548: -- get certification name
1549: cursor certification_name
1550: is select name from ota_certifications_tl