APPS.EAM_CREATEUPDATE_WO_PVT dependencies on EAM_ORG_MAINT_DEFAULTS

Line 354: FROM eam_org_maint_defaults

350: --if workorder dept. is null,de fault it from asset's owning dept
351:
352: SELECT OWNING_DEPARTMENT_ID
353: INTO l_fail_dept_id
354: FROM eam_org_maint_defaults
355: WHERE object_id =l_maintenance_object_id
356: AND object_type = 50
357: AND organization_id =l_eam_wo_comp_rec.organization_id;
358:

Line 361: FROM eam_org_maint_defaults

357: AND organization_id =l_eam_wo_comp_rec.organization_id;
358:
359: SELECT area_id
360: INTO l_eam_location_id
361: FROM eam_org_maint_defaults
362: WHERE object_id = l_maintenance_object_id
363: AND object_type = 50
364: AND organization_id = l_eam_wo_comp_rec.organization_id;
365:

Line 1250: FROM eam_org_maint_defaults

1246: --if workorder dept. is null,de fault it from asset's owning dept
1247: IF(l_fail_dept_id IS NULL) THEN
1248: SELECT OWNING_DEPARTMENT_ID
1249: INTO l_fail_dept_id
1250: FROM eam_org_maint_defaults
1251: WHERE object_id =l_maintenance_object_id
1252: AND object_type = 50
1253: AND organization_id =l_eam_wo_comp_rec.organization_id;
1254: END IF;

Line 1258: FROM eam_org_maint_defaults

1254: END IF;
1255:
1256: SELECT area_id
1257: INTO l_eam_location_id
1258: FROM eam_org_maint_defaults
1259: WHERE object_id = l_maintenance_object_id
1260: AND object_type = 50
1261: AND organization_id = l_eam_wo_comp_rec.organization_id;
1262:

Line 1984: FROM eam_org_maint_defaults

1980: --if workorder dept. is null,de fault it from asset's owning dept
1981:
1982: SELECT OWNING_DEPARTMENT_ID
1983: INTO l_fail_dept_id
1984: FROM eam_org_maint_defaults
1985: WHERE object_id =l_maintenance_object_id
1986: AND object_type = 50
1987: AND organization_id =l_eam_wo_comp_rec.organization_id;
1988:

Line 1991: FROM eam_org_maint_defaults

1987: AND organization_id =l_eam_wo_comp_rec.organization_id;
1988:
1989: SELECT area_id
1990: INTO l_eam_location_id
1991: FROM eam_org_maint_defaults
1992: WHERE object_id = l_maintenance_object_id
1993: AND object_type = 50
1994: AND organization_id = l_eam_wo_comp_rec.organization_id;
1995:

Line 2882: FROM eam_org_maint_defaults

2878: --if workorder dept. is null,de fault it from asset's owning dept
2879: IF(l_fail_dept_id IS NULL) THEN
2880: SELECT OWNING_DEPARTMENT_ID
2881: INTO l_fail_dept_id
2882: FROM eam_org_maint_defaults
2883: WHERE object_id =l_maintenance_object_id
2884: AND object_type = 50
2885: AND organization_id =l_eam_wo_comp_rec.organization_id;
2886: END IF;

Line 2890: FROM eam_org_maint_defaults

2886: END IF;
2887:
2888: SELECT area_id
2889: INTO l_eam_location_id
2890: FROM eam_org_maint_defaults
2891: WHERE object_id = l_maintenance_object_id
2892: AND object_type = 50
2893: AND organization_id = l_eam_wo_comp_rec.organization_id;
2894: