DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on CS_INCIDENTS_ALL_B

Line 3916: from cs_incidents_all_b

3912: --Bug 12642943
3913: Cursor sr_instance(p_incident_id Number) is
3914: Select customer_product_id,
3915: inventory_item_id
3916: from cs_incidents_all_b
3917: where incident_id = p_incident_id;
3918:
3919: l_sr_instance_id Number;
3920: l_sr_inventory_item_id Number;

Line 14563: FROM CS_INCIDENTS_ALL_B

14559: l_credit_status) THEN
14560: BEGIN
14561: SELECT instrument_payment_use_id
14562: INTO x_charges_detail_rec.instrument_payment_use_id
14563: FROM CS_INCIDENTS_ALL_B
14564: WHERE incident_id = p_charges_detail_rec.incident_id;
14565:
14566: EXCEPTION
14567: WHEN OTHERS THEN

Line 14938: FROM cs_incidents_all_b inc,

14934: NVL(inc.ship_to_account_id,-999) ship_to_account_id,
14935: NVL(inc.bill_to_contact_id,-999) bill_to_contact_id,
14936: NVL(inc.ship_to_contact_id,-999) ship_to_contact_id,
14937: inc.caller_type
14938: FROM cs_incidents_all_b inc,
14939: CS_INCIDENT_TYPES intp,
14940: CS_BUSINESS_PROCESSES bp,
14941: hz_parties hzp,
14942: hz_cust_accounts hza

Line 15538: FROM CS_INCIDENTS_ALL_b

15534: Cursor c_val_sr_source(p_source_id IN NUMBER) IS
15535:
15536: -- Bug Fix for Bug # 3044488
15537: SELECT incident_id
15538: FROM CS_INCIDENTS_ALL_b
15539: WHERE incident_id = p_source_id;
15540: --AND org_id = p_org_id;
15541:
15542: Cursor c_val_dr_source(p_source_id IN NUMBER) IS