APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on CS_SR_LINK_TYPES_VL

Line 610: FROM CS_SR_LINK_TYPES_VL

606: l_trigger_link_type_id NUMBER;
607:
608: CURSOR sel_link_type_id_csr IS
609: SELECT link_type_id
610: FROM CS_SR_LINK_TYPES_VL
611: WHERE name = l_trigger_link_type;
612:
613: CURSOR sel_event_action_csr IS
614: SELECT csad.event_condition_id,

Line 1399: CS_SR_LINK_TYPES_VL cilt

1395: cil.link_type_id,
1396: cilt.name link_type_name
1397: FROM cs_incident_links cil,
1398: cs_incidents_all_b inc,
1399: CS_SR_LINK_TYPES_VL cilt
1400: WHERE cil.subject_id = l_request_id
1401: and cil.object_id = l_notify_subject_id
1402: and inc.incident_id = cil.object_id
1403: and cilt.link_type_id(+) = cil.link_type_id;

Line 1513: CS_SR_LINK_TYPES_VL cilt

1509: -- 1. NTFY_LINK_TYPE
1510: CURSOR sel_linked_sr_type_csr IS
1511: SELECT cilt.name link_type_name
1512: FROM cs_incident_links cil,
1513: CS_SR_LINK_TYPES_VL cilt
1514: WHERE cilt.link_type_id = cil.link_type_id AND
1515: cil.subject_id = l_notify_subject_id AND
1516: cil.object_id = l_request_id;
1517:

Line 5160: FROM CS_SR_LINK_TYPES_VL

5156:
5157: -- Obtain link type name from relationship_type_id
5158: SELECT name
5159: INTO l_relationship_type_name
5160: FROM CS_SR_LINK_TYPES_VL
5161: WHERE link_type_id = l_relationship_type_id;
5162:
5163: WF_ENGINE.SetItemAttrText(
5164: itemtype => itemtype,

Line 5901: CS_SR_LINK_TYPES_VL cilt

5897: SELECT cil.link_type_id,
5898: cil.object_id,
5899: cil.link_id
5900: FROM cs_incident_links cil,
5901: CS_SR_LINK_TYPES_VL cilt
5902: WHERE cil.subject_id = l_request_id
5903: AND cil.link_type_id = cilt.link_type_id
5904: AND cilt.name = l_relationship_type_name
5905: AND cil.object_id > l_subject_id