DBA Data[Home] [Help]

APPS.WIP_EAMWORKORDER_PVT dependencies on EAM_ORG_MAINT_DEFAULTS

Line 1369: FROM EAM_ORG_MAINT_DEFAULTS EOMD

1365: AND NVL(MEAA.tmpl_flag,'N') = 'N';
1366:
1367: SELECT EOMD.OWNING_DEPARTMENT_ID
1368: INTO x_owning_department_id
1369: FROM EAM_ORG_MAINT_DEFAULTS EOMD
1370: WHERE EOMD.organization_id = p_organization_id
1371: AND EOMD.OBJECT_ID = l_act_assoc_id
1372: AND EOMD.OBJECT_TYPE IN (40,60) ;
1373: EXCEPTION

Line 1386: FROM EAM_ORG_MAINT_DEFAULTS EOMD

1382: IF (x_owning_department_id IS NULL AND p_maintenance_object_type = 3) THEN
1383: BEGIN
1384: SELECT EOMD.OWNING_DEPARTMENT_ID
1385: INTO x_owning_department_id
1386: FROM EAM_ORG_MAINT_DEFAULTS EOMD
1387: WHERE EOMD.organization_id = p_organization_id
1388: AND EOMD.OBJECT_ID = p_maintenance_object_id
1389: AND EOMD.OBJECT_TYPE = 50 ;
1390: EXCEPTION