DBA Data[Home] [Help]

APPS.ZX_TDS_PROCESS_CEC_PVT dependencies on HR_GENERAL

Line 586: AND NVL (loc.business_group_id, NVL (hr_general.get_business_group_id, -99)) =

582: AND loc.style = fnd.descriptive_flex_context_code
583: AND fnd.application_id = 800 -- Application_short_name 'PER'
584: AND fnd.descriptive_flexfield_name = 'Address Location'
585: AND fnd.enabled_flag IN ('Y', 'y')
586: AND NVL (loc.business_group_id, NVL (hr_general.get_business_group_id, -99)) =
587: NVL (hr_general.get_business_group_id, NVL (loc.business_group_id, -99));
588:
589: cursor c_get_location_id(c_organization_id NUMBER) is
590: select location_id

Line 587: NVL (hr_general.get_business_group_id, NVL (loc.business_group_id, -99));

583: AND fnd.application_id = 800 -- Application_short_name 'PER'
584: AND fnd.descriptive_flexfield_name = 'Address Location'
585: AND fnd.enabled_flag IN ('Y', 'y')
586: AND NVL (loc.business_group_id, NVL (hr_general.get_business_group_id, -99)) =
587: NVL (hr_general.get_business_group_id, NVL (loc.business_group_id, -99));
588:
589: cursor c_get_location_id(c_organization_id NUMBER) is
590: select location_id
591: from hr_organization_units