DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on HR_LOCATIONS

Line 1410: from hr_locations loc

1406: --
1407: cursor c_LocationNameLovVO(p_source_name1 varchar2, cv_effective_date date) is
1408: select loc.location_code name,
1409: loc.location_id id
1410: from hr_locations loc
1411: where trunc(cv_effective_date) <= nvl( loc.inactive_date, trunc(cv_effective_date))
1412: and nvl(business_group_id,p_target_business_group_id) = p_target_business_group_id
1413: and loc.location_code = p_source_name1;
1414: --