APPS.CSF_PREVENTIVE_MAINTENANCE_PVT dependencies on JTF_TASKS_B

Line 702: FROM jtf_tasks_b

698: SAVEPOINT Generate_SR_Tasks_PVT;
699:
700: SELECT task_id,object_version_number
701: BULK COLLECT INTO conf_task_id,conf_object_version_number
702: FROM jtf_tasks_b
703: WHERE source_object_id = x_request_id;
704:
705: FOR i in 1..conf_task_id.COUNT Loop
706: csf_tasks_pub.Update_Task_status

Line 789: FROM jtf_tasks_b

785: IF (l_acchrs_found = true) THEN
786:
787: SELECT task_id,object_version_number
788: BULK COLLECT INTO conf_task_id,conf_object_version_number
789: FROM jtf_tasks_b
790: WHERE source_object_id = x_request_id;
791:
792:
793: FOR i in 1..conf_task_id.COUNT Loop

Line 1138: jtf_tasks_b jtb

1134: jtb.object_version_number tasks_object_version
1135: From ahl_unit_effectivities_app_v aueb,
1136: cs_incident_links cil,
1137: cs_incidents_all_b csi,
1138: jtf_tasks_b jtb
1139: Where aueb.status_code in ('TERMINATED','EXCEPTION')
1140: -- Application_usg_code PM for Preventive Maintenance seeded for CMRO 11.5.10 changes
1141: and aueb.application_usg_code = 'PM'
1142: and cil.object_id = aueb.unit_effectivity_id