DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on EAM_ORG_MAINT_DEFAULTS

Line 11677: FROM eam_org_maint_defaults

11673: IF (l_department_id IS NULL) THEN
11674: BEGIN
11675: SELECT OWNING_DEPARTMENT_ID
11676: INTO l_department_id
11677: FROM eam_org_maint_defaults
11678: WHERE object_id = l_maint_object_id
11679: AND object_type = 60 AND organization_id = l_org_id ;
11680: EXCEPTION
11681: WHEN NO_DATA_FOUND THEN

Line 11691: FROM eam_org_maint_defaults

11687: IF (l_eam_location_id IS NULL) THEN
11688: BEGIN
11689: SELECT area_id
11690: INTO l_eam_location_id
11691: FROM eam_org_maint_defaults
11692: WHERE object_id = l_maint_object_id
11693: AND object_type = 60 AND organization_id = l_org_id ;
11694: EXCEPTION
11695: WHEN NO_DATA_FOUND THEN