DBA Data[Home] [Help]

APPS.CS_SERVICE_BILLING_ENGINE_PVT dependencies on CSF_DEBRIEF_LINES

Line 257: csf_debrief_lines l,

253: -- Added fix for bug#4120101
254: CURSOR get_task_resource(p_debrief_line_id number) IS
255: SELECT j.resource_id,j.task_id
256: FROM csf_debrief_headers h,
257: csf_debrief_lines l,
258: jtf_task_assignments_v j,
259: jtf_tasks_b jt
260: WHERE l.debrief_line_id = p_debrief_line_id
261: AND h.debrief_header_id = l.debrief_header_id

Line 1718: and source_id in (select debrief_line_id from csf_debrief_lines where debrief_header_id = nvl(p_debrief_header_id, debrief_header_id)) -- Enhancement 2983340

1714: SELECT estimate_detail_id
1715: FROM cs_estimate_details
1716: WHERE incident_id = p_incident_id
1717: and source_code = 'SD' -- Enhancement 2983340
1718: and source_id in (select debrief_line_id from csf_debrief_lines where debrief_header_id = nvl(p_debrief_header_id, debrief_header_id)) -- Enhancement 2983340
1719: -- Fix bug 3137168 and generated_by_bca_engine_flag = 'Y'
1720: and charge_line_type = 'IN_PROGRESS';
1721:
1722: --Added to Fix Bug # 3539583

Line 1728: and source_id in (select debrief_line_id from csf_debrief_lines where debrief_line_id = nvl(p_debrief_line_id, debrief_line_id)) -- Enhancement 2983340

1724: SELECT estimate_detail_id
1725: FROM cs_estimate_details
1726: WHERE incident_id = p_incident_id
1727: and source_code = 'SD' -- Enhancement 2983340
1728: and source_id in (select debrief_line_id from csf_debrief_lines where debrief_line_id = nvl(p_debrief_line_id, debrief_line_id)) -- Enhancement 2983340
1729: and charge_line_type = 'IN_PROGRESS';
1730:
1731:
1732: BEGIN