APPS.CSP_REQUIREMENT_POPULATE_PVT dependencies on JTF_TASKS_B

Line 26: FROM jtf_tasks_b j, CS_INCIDENTS_ALL_B i,csp_product_tasks p

22:
23:
24: CURSOR product_task_id(l_task_id NUMBER) IS
25: SELECT product_task_id,ACTUAL_TIMES_USED
26: FROM jtf_tasks_b j, CS_INCIDENTS_ALL_B i,csp_product_tasks p
27: WHERE j.task_id = l_task_id
28: AND j.SOURCE_OBJECT_TYPE_CODE = 'SR'
29: AND i.incident_id = j.SOURCE_OBJECT_ID
30: AND p.product_id = i.inventory_item_id

Line 34: FROM jtf_tasks_b jtb, csd_repairs cr,csp_product_tasks cpp

30: AND p.product_id = i.inventory_item_id
31: AND p.task_template_id = j.template_id
32: union all
33: SELECT product_task_id,ACTUAL_TIMES_USED
34: FROM jtf_tasks_b jtb, csd_repairs cr,csp_product_tasks cpp
35: WHERE jtb.task_id = l_task_id
36: AND jtb.SOURCE_OBJECT_TYPE_CODE = 'DR'
37: AND cr.repair_line_id = jtb.SOURCE_OBJECT_ID
38: AND cpp.product_id = cr.inventory_item_id