DBA Data[Home] [Help]

APPS.WIP_EAM_WORKREQUEST_PVT dependencies on EAM_ORG_MAINT_DEFAULTS

Line 165: FROM eam_org_maint_defaults eomd

161: begin
162: -- select owning dept from asset
163: SELECT eomd.owning_department_id
164: INTO l_owning_dept_id
165: FROM eam_org_maint_defaults eomd
166: WHERE eomd.object_type(+) = 50
167: AND eomd.object_id = l_maintenance_object_id
168: and organization_id = p_org_id;
169: exception

Line 3393: from eam_org_maint_defaults

3389: begin
3390:
3391: SELECT owning_department_id
3392: into l_owning_dept_id
3393: from eam_org_maint_defaults
3394: where object_type = 50
3395: and object_id = p_maintenance_object_id
3396: and organization_id = p_org_id;
3397: exception

Line 3415: FROM eam_org_maint_defaults eomd

3411:
3412:
3413: SELECT owning_department_id
3414: INTO l_owning_dept_id
3415: FROM eam_org_maint_defaults eomd
3416: WHERE eomd.organization_id = p_org_id
3417:
3418: and eomd.object_type(+) = 50
3419: and eomd.object_id (+) = l_instance_id;

Line 3498: FROM eam_org_maint_defaults eomd

3494:
3495: BEGIN
3496: SELECT area_id
3497: INTO l_asset_location_id
3498: FROM eam_org_maint_defaults eomd
3499: WHERE eomd.organization_id = p_org_id
3500: AND eomd.object_type = 50
3501: AND eomd.object_id = l_instance_id;
3502: EXCEPTION