DBA Data[Home] [Help]

APPS.CS_SERVICE_BILLING_ENGINE_PVT dependencies on CSF_DEBRIEF_LINES

Line 256: csf_debrief_lines l,

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

Line 1659: 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

1655: SELECT estimate_detail_id
1656: FROM cs_estimate_details
1657: WHERE incident_id = p_incident_id
1658: and source_code = 'SD' -- Enhancement 2983340
1659: 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
1660: -- Fix bug 3137168 and generated_by_bca_engine_flag = 'Y'
1661: and charge_line_type = 'IN_PROGRESS';
1662:
1663: --Added to Fix Bug # 3539583

Line 1669: 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

1665: SELECT estimate_detail_id
1666: FROM cs_estimate_details
1667: WHERE incident_id = p_incident_id
1668: and source_code = 'SD' -- Enhancement 2983340
1669: 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
1670: and charge_line_type = 'IN_PROGRESS';
1671:
1672:
1673: BEGIN