DBA Data[Home] [Help]

APPS.CS_SERVICE_BILLING_ENGINE_PVT dependencies on CS_ESTIMATE_DETAILS

Line 1656: FROM cs_estimate_details

1652:
1653: -- Enhancement 2983340 CURSOR in_progress_charges_csr(p_incident_id number) IS
1654: CURSOR in_progress_charges_csr(p_incident_id number, p_debrief_header_id number) IS -- 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'

Line 1666: FROM cs_estimate_details

1662:
1663: --Added to Fix Bug # 3539583
1664: CURSOR in_progress_charge_csr(p_incident_id number, p_debrief_line_id number) IS -- 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';