DBA Data[Home] [Help]

APPS.EAM_COMMON_UTILITIES_PVT dependencies on EAM_ORG_MAINT_DEFAULTS

Line 3602: FROM eam_org_maint_defaults eomd,

3598: FUNCTION get_asset_area( p_instance_id NUMBER, p_maint_org_id NUMBER) RETURN VARCHAR2
3599: IS
3600: CURSOR get_area IS
3601: SELECT el.location_codes
3602: FROM eam_org_maint_defaults eomd,
3603: mtl_eam_locations el
3604: WHERE eomd.area_id = el.location_id
3605: AND eomd.object_type = 50
3606: AND eomd.object_id = p_instance_id