APPS.CSF_DEBRIEF_UPDATE_PKG dependencies on JTF_TASKS_B

Line 207: JTF_TASKS_B jtb,

203: jtsb.closed_flag
204: from
205: JTF_TASK_STATUSES_B jtsb,
206: CSF_DEBRIEF_HEADERS cdh,
207: JTF_TASKS_B jtb,
208: JTF_TASK_ASSIGNMENTS jta,
209: cs_incidents_all_b ciab
210: WHERE cdh.task_assignment_id = jta.task_assignment_id
211: and jta.task_id = jtb.task_id

Line 234: JTF_TASKS_B jtb,

230: jtsb.closed_flag
231: from
232: JTF_TASK_STATUSES_B jtsb,
233: CSF_DEBRIEF_HEADERS cdh,
234: JTF_TASKS_B jtb,
235: JTF_TASK_ASSIGNMENTS jta,
236: csd_repairs cr
237: WHERE cdh.task_assignment_id = jta.task_assignment_id
238: and jta.task_id = jtb.task_id

Line 262: JTF_TASKS_B jtb,

258: jtsb.closed_flag
259: from
260: JTF_TASK_STATUSES_B jtsb,
261: CSF_DEBRIEF_HEADERS cdh,
262: JTF_TASKS_B jtb,
263: JTF_TASK_ASSIGNMENTS jta,
264: cs_incidents_all_b ciab
265: WHERE cdh.task_assignment_id = jta.task_assignment_id
266: and jta.task_id = jtb.task_id

Line 290: JTF_TASKS_B jtb,

286: jtsb.closed_flag
287: from
288: JTF_TASK_STATUSES_B jtsb,
289: CSF_DEBRIEF_HEADERS cdh,
290: JTF_TASKS_B jtb,
291: JTF_TASK_ASSIGNMENTS jta,
292: csd_repairs cr
293: WHERE cdh.task_assignment_id = jta.task_assignment_id
294: and jta.task_id = jtb.task_id

Line 1352: l_task_number jtf_tasks_b.task_number%type;

1348: x_msg_count out nocopy number,
1349: x_msg_data out nocopy varchar2) IS
1350:
1351: l_processed_flag csf_debrief_headers.processed_flag%type;
1352: l_task_number jtf_tasks_b.task_number%type;
1353: l_debrief_status_rec debrief_status_rec_type;
1354: l_debrief_status_tbl debrief_status_tbl_type;
1355:
1356: cursor get_debrief_status is

Line 1364: jtf_tasks_b jtb

1360: cdh.debrief_number,
1361: decode(processed_flag,'PENDING','P','E') debrief_status
1362: from csf_debrief_headers cdh,
1363: jtf_task_assignments jta,
1364: jtf_tasks_b jtb
1365: where processed_flag in ('PENDING','COMPLETED W/ERRORS')
1366: and jta.task_assignment_id = cdh.task_assignment_id
1367: and jtb.task_id = jta.task_id
1368: and jtb.source_object_type_code = 'SR'

Line 1377: jtf_tasks_b jtb,

1373: cdh.debrief_header_id,
1374: cdh.debrief_number,
1375: decode(processed_flag,'PENDING','P','E') debrief_status
1376: from csd_repairs cr,
1377: jtf_tasks_b jtb,
1378: jtf_task_assignments jta,
1379: csf_debrief_headers cdh
1380: where jtb.source_object_id = cr.repair_line_id
1381: and jtb.source_object_type_code = 'DR'