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 1395: CS_SR_LINK_TYPES_VL cilt

1391: cil.link_type_id,
1392: cilt.name link_type_name
1393: FROM cs_incident_links cil,
1394: cs_incidents_all_b inc,
1395: CS_SR_LINK_TYPES_VL cilt
1396: WHERE cil.subject_id = l_request_id
1397: and cil.object_id = l_notify_subject_id
1398: and inc.incident_id = cil.object_id
1399: and cilt.link_type_id(+) = cil.link_type_id;

Line 1509: CS_SR_LINK_TYPES_VL cilt

1505: -- 1. NTFY_LINK_TYPE
1506: CURSOR sel_linked_sr_type_csr IS
1507: SELECT cilt.name link_type_name
1508: FROM cs_incident_links cil,
1509: CS_SR_LINK_TYPES_VL cilt
1510: WHERE cilt.link_type_id = cil.link_type_id AND
1511: cil.subject_id = l_notify_subject_id AND
1512: cil.object_id = l_request_id;
1513:

Line 5096: FROM CS_SR_LINK_TYPES_VL

5092:
5093: -- Obtain link type name from relationship_type_id
5094: SELECT name
5095: INTO l_relationship_type_name
5096: FROM CS_SR_LINK_TYPES_VL
5097: WHERE link_type_id = l_relationship_type_id;
5098:
5099: WF_ENGINE.SetItemAttrText(
5100: itemtype => itemtype,

Line 5837: CS_SR_LINK_TYPES_VL cilt

5833: SELECT cil.link_type_id,
5834: cil.object_id,
5835: cil.link_id
5836: FROM cs_incident_links cil,
5837: CS_SR_LINK_TYPES_VL cilt
5838: WHERE cil.subject_id = l_request_id
5839: AND cil.link_type_id = cilt.link_type_id
5840: AND cilt.name = l_relationship_type_name
5841: AND cil.object_id > l_subject_id