DBA Data[Home] [Help]

APPS.CS_CHARGE_CORE_PVT dependencies on CS_ESTIMATE_DETAILS

Line 258: FROM CS_ESTIMATE_DETAILS

254: p_qte_line_id NUMBER) RETURN NUMBER
255: IS
256: CURSOR c_ship_site1 IS
257: SELECT ship_to_org_id
258: FROM CS_ESTIMATE_DETAILS
259: WHERE incident_id = p_qte_header_id
260: AND estimate_detail_id = p_qte_line_id;
261:
262: CURSOR c_ship_site2 IS

Line 264: FROM CS_ESTIMATE_DETAILS

260: AND estimate_detail_id = p_qte_line_id;
261:
262: CURSOR c_ship_site2 IS
263: SELECT ship_to_org_id
264: FROM CS_ESTIMATE_DETAILS
265: WHERE incident_id = p_qte_header_id
266: AND estimate_detail_id IS NULL ;
267:
268: l_ship_site_id NUMBER;

Line 339: FROM CS_ESTIMATE_DETAILS

335: ) RETURN NUMBER
336: IS
337: CURSOR c_inv_site1 IS
338: SELECT invoice_to_org_id
339: FROM CS_ESTIMATE_DETAILS
340: WHERE estimate_detail_id = p_qte_line_id
341: AND incident_id = p_qte_header_id;
342:
343: CURSOR c_inv_site2 IS

Line 345: FROM CS_ESTIMATE_DETAILS

341: AND incident_id = p_qte_header_id;
342:
343: CURSOR c_inv_site2 IS
344: SELECT invoice_to_org_id
345: FROM CS_ESTIMATE_DETAILS
346: WHERE incident_id = p_qte_header_id;
347:
348:
349: l_inv_site_id NUMBER;