DBA Data[Home] [Help]

APPS.CSD_REPAIR_ACTUAL_PROCESS_PVT dependencies on JTF_TASK_ASSIGNMENTS

Line 540: with CSF_DEBRIEF_HEADERS, JTF_TASKS_B, and JTF_TASK_ASSIGNMENTS */

536: --gilam: put in nvl for actual header id
537: -- Fetches only the charge lines that have not
538: -- been imported earlier for all eligible tasks.
539: /* swai: bug 6042488 / FP bug 5949309 - replace CSF_DEBRIEF_HEADERS_V
540: with CSF_DEBRIEF_HEADERS, JTF_TASKS_B, and JTF_TASK_ASSIGNMENTS */
541: CURSOR c_valid_task_charge_lines IS
542: SELECT CEST.estimate_detail_id,
543: JTB.task_id actual_source_id -- swai: bug 6042488
544: FROM CS_ESTIMATE_DETAILS CEST,

Line 548: JTF_TASK_ASSIGNMENTS JTA -- swai: bug 6042488

544: FROM CS_ESTIMATE_DETAILS CEST,
545: CSF_DEBRIEF_LINES CDBL,
546: CSF_DEBRIEF_HEADERS CDBH, -- swai: bug 6042488
547: JTF_TASKS_B JTB, -- swai: bug 6042488
548: JTF_TASK_ASSIGNMENTS JTA -- swai: bug 6042488
549: WHERE CEST.original_source_code = 'DR'
550: AND CEST.original_source_id = p_repair_line_id
551: AND CEST.source_code = 'SD'
552: AND CDBL.debrief_line_id = CEST.source_id