DBA Data[Home] [Help]

APPS.CS_SERVICE_BILLING_ENGINE_PVT dependencies on CS_ESTIMATE_DETAILS

Line 1715: FROM cs_estimate_details

1711:
1712: -- Enhancement 2983340 CURSOR in_progress_charges_csr(p_incident_id number) IS
1713: CURSOR in_progress_charges_csr(p_incident_id number, p_debrief_header_id number) IS -- 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'

Line 1725: FROM cs_estimate_details

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