APPS.CSF_DEBRIEF_UPDATE_PKG dependencies on JTF_TASKS_B

Line 278: JTF_TASKS_B jtb,

274: cdh.travel_end_time, ciab.system_id system_id
275: from
276: JTF_TASK_STATUSES_B jtsb,
277: CSF_DEBRIEF_HEADERS cdh,
278: JTF_TASKS_B jtb,
279: JTF_TASK_ASSIGNMENTS jta,
280: cs_incidents_all_b ciab
281: WHERE cdh.task_assignment_id = jta.task_assignment_id
282: and jta.task_id = jtb.task_id

Line 307: JTF_TASKS_B jtb,

303: cdh.travel_end_time, to_number(null) system_id
304: from
305: JTF_TASK_STATUSES_B jtsb,
306: CSF_DEBRIEF_HEADERS cdh,
307: JTF_TASKS_B jtb,
308: JTF_TASK_ASSIGNMENTS jta,
309: csd_repairs cr
310: WHERE cdh.task_assignment_id = jta.task_assignment_id
311: and jta.task_id = jtb.task_id

Line 337: JTF_TASKS_B jtb,

333: cdh.travel_end_time, ciab.system_id system_id
334: from
335: JTF_TASK_STATUSES_B jtsb,
336: CSF_DEBRIEF_HEADERS cdh,
337: JTF_TASKS_B jtb,
338: JTF_TASK_ASSIGNMENTS jta,
339: cs_incidents_all_b ciab
340: WHERE cdh.task_assignment_id = jta.task_assignment_id
341: and jta.task_id = jtb.task_id

Line 368: JTF_TASKS_B jtb,

364: cdh.travel_end_time, to_number(null) system_id
365: from
366: JTF_TASK_STATUSES_B jtsb,
367: CSF_DEBRIEF_HEADERS cdh,
368: JTF_TASKS_B jtb,
369: JTF_TASK_ASSIGNMENTS jta,
370: csd_repairs cr
371: WHERE cdh.task_assignment_id = jta.task_assignment_id
372: and jta.task_id = jtb.task_id

Line 1965: l_task_number jtf_tasks_b.task_number%type;

1961: x_msg_count out nocopy number,
1962: x_msg_data out nocopy varchar2) IS
1963:
1964: l_processed_flag csf_debrief_headers.processed_flag%type;
1965: l_task_number jtf_tasks_b.task_number%type;
1966: l_debrief_status_rec debrief_status_rec_type;
1967: l_debrief_status_tbl debrief_status_tbl_type;
1968:
1969: cursor get_debrief_status is

Line 1977: jtf_tasks_b jtb

1973: cdh.debrief_number,
1974: decode(processed_flag,'PENDING','P','E') debrief_status
1975: from csf_debrief_headers cdh,
1976: jtf_task_assignments jta,
1977: jtf_tasks_b jtb
1978: where processed_flag in ('PENDING','COMPLETED W/ERRORS')
1979: and jta.task_assignment_id = cdh.task_assignment_id
1980: and jtb.task_id = jta.task_id
1981: and jtb.source_object_type_code = 'SR'

Line 1990: jtf_tasks_b jtb,

1986: cdh.debrief_header_id,
1987: cdh.debrief_number,
1988: decode(processed_flag,'PENDING','P','E') debrief_status
1989: from csd_repairs cr,
1990: jtf_tasks_b jtb,
1991: jtf_task_assignments jta,
1992: csf_debrief_headers cdh
1993: where jtb.source_object_id = cr.repair_line_id
1994: and jtb.source_object_type_code = 'DR'