51: AND (p_set_name_id is null OR
52: (
53: (cii.instance_id,3) in
54: (select maintenance_object_id,maintenance_object_type
55: from eam_pm_schedulings where set_name_id = p_set_name_id )
56: ) );
57:
58: IF SQL%ROWCOUNT = 0 THEN
59: l_count_first := 1;
88: AND (p_set_name_id is null OR
89: (
90: (cii.instance_id,3) in
91: (select maintenance_object_id,maintenance_object_type
92: from eam_pm_schedulings where set_name_id = p_set_name_id )
93: ) )
94: AND EXISTS (SELECT 1
95: FROM wip_discrete_jobs
96: WHERE organization_id = p_org_id
292: AND (p_set_name_id is null OR
293: (
294: (cii.instance_id,3) in
295: (select maintenance_object_id,maintenance_object_type
296: from eam_pm_schedulings where set_name_id = p_set_name_id )
297: ) )
298: AND eomd.organization_id(+) = p_org_id;
299: -- Is this stii required, WE team please check ????
300: -- (p_include_rebuildable='Y' and msn.current_status in (1,3,4))))) --planners workbench will pass p_include_rebuildable as 'Y'
327: AND (p_set_name_id is null OR
328: (
329: (cii.instance_id,3) in
330: (select maintenance_object_id,maintenance_object_type
331: from eam_pm_schedulings where set_name_id = p_set_name_id )
332: ) )
333: AND EXISTS (SELECT 1
334: FROM wip_discrete_jobs
335: WHERE organization_id = p_org_id