APPS.CS_WF_ACTIVITIES_PKG dependencies on CS_INCIDENT_STATUSES

Line 94: cs_incident_statuses st,

90: -- CS_INCIDENT_ACTIONS_V act,
91: mtl_system_items_kfv mtl,
92: cs_customer_products cp,
93: cs_incident_types it,
94: cs_incident_statuses st,
95: hz_party_sites hps,
96: hz_locations hl,
97: jtf_notes_vl jn
98: WHERE it.incident_type_id = sr.incident_type_id

Line 413: CS_INCIDENT_STATUSES_VL STATUS,

409: MTL.DESCRIPTION PRODUCT_DESCRIPTION
410: FROM CS_INCIDENTS_ALL_VL INC,
411: --CS_INCIDENT_SEVERITIES_VL SEVERITY,
412: CS_INCIDENT_SEVERITIES_TL SEVERITY,
413: CS_INCIDENT_STATUSES_VL STATUS,
414: --CS_INCIDENT_URGENCIES_VL URGENCY,
415: CS_INCIDENT_URGENCIES_TL URGENCY,
416: HZ_PARTIES RA2,
417: CS_LOOKUPS CSLKUP,

Line 1384: FROM cs_incident_statuses

1380: --
1381: -- Update the item attribute
1382: SELECT name
1383: INTO l_new_status
1384: FROM cs_incident_statuses
1385: WHERE incident_status_id = 2;
1386:
1387: WF_ENGINE.SetItemAttrText(
1388: itemtype => itemtype,

Line 2116: l_close_flag CS_INCIDENT_STATUSES.CLOSE_FLAG%TYPE;

2112: result OUT VARCHAR2
2113: ) IS
2114: l_request_id CS_INCIDENT_ACTIONS.INCIDENT_ID%TYPE;
2115: l_action_number CS_INCIDENT_ACTIONS.ACTION_NUM%TYPE;
2116: l_close_flag CS_INCIDENT_STATUSES.CLOSE_FLAG%TYPE;
2117:
2118: CURSOR l_stat_cur IS
2119: SELECT b.close_flag
2120: FROM CS_INCIDENT_ACTIONS a, CS_INCIDENT_STATUSES b

Line 2120: FROM CS_INCIDENT_ACTIONS a, CS_INCIDENT_STATUSES b

2116: l_close_flag CS_INCIDENT_STATUSES.CLOSE_FLAG%TYPE;
2117:
2118: CURSOR l_stat_cur IS
2119: SELECT b.close_flag
2120: FROM CS_INCIDENT_ACTIONS a, CS_INCIDENT_STATUSES b
2121: WHERE a.incident_id = l_request_id AND
2122: a.action_num = l_action_number AND
2123: a.action_status_id = b.incident_status_id;
2124: