APPS.CS_CHARGE_DETAILS_PVT dependencies on CS_INCIDENTS_ALL

Line 444: FROM cs_incidents_all

440: IS
441:
442: Cursor c_incident IS
443: SELECT 'Y'
444: FROM cs_incidents_all
445: WHERE incident_id = p_incident_id;
446:
447: lv_exists_flag VARCHAR2(1) := 'N';
448:

Line 13401: FROM cs_incidents_all_b inc,

13397: NVL(inc.ship_to_account_id,-999) ship_to_account_id,
13398: NVL(inc.bill_to_contact_id,-999) bill_to_contact_id,
13399: NVL(inc.ship_to_contact_id,-999) ship_to_contact_id,
13400: inc.caller_type
13401: FROM cs_incidents_all_b inc,
13402: CS_INCIDENT_TYPES intp,
13403: CS_BUSINESS_PROCESSES bp,
13404: hz_parties hzp,
13405: hz_cust_accounts hza

Line 14001: FROM CS_INCIDENTS_ALL_b

13997: Cursor c_val_sr_source(p_source_id IN NUMBER) IS
13998:
13999: -- Bug Fix for Bug # 3044488
14000: SELECT incident_id
14001: FROM CS_INCIDENTS_ALL_b
14002: WHERE incident_id = p_source_id;
14003: --AND org_id = p_org_id;
14004:
14005: Cursor c_val_dr_source(p_source_id IN NUMBER) IS

Line 15037: cs_incidents_all csinall

15033: cursor c_charge_flags(p_incident_id IN NUMBER)IS
15034: select nvl(csinst.disallow_new_charge, 'N'),
15035: nvl(csinst.disallow_charge_update, 'N')
15036: from cs_incident_statuses csinst,
15037: cs_incidents_all csinall
15038: where csinst.incident_status_id = csinall.incident_status_id
15039: and csinall.incident_id = p_incident_id;
15040:
15041: