eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on CS_SR_EVENT_CODES_B

Line 123: CS_SR_EVENT_CODES_B cec

119: to_char(null) role_group_type,
120: to_char(null) role_group_code
121: FROM CS_SR_ACTION_TRIGGERS csat,
122: CS_SR_ACTION_DETAILS csad,
123: CS_SR_EVENT_CODES_B cec
124: WHERE
125: cec.WF_BUSINESS_EVENT_ID = l_event_name
126: and csat.EVENT_CODE = cec.EVENT_CODE
127: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(csat.start_date_active, SYSDATE))

Line 151: CS_SR_EVENT_CODES_B cec

147: to_char(null) role_group_type,
148: to_char(null) role_group_code
149: FROM CS_SR_ACTION_TRIGGERS csat,
150: CS_SR_ACTION_DETAILS csad,
151: CS_SR_EVENT_CODES_B cec
152: WHERE
153: cec.WF_BUSINESS_EVENT_ID = l_event_name
154: and csat.EVENT_CODE = cec.EVENT_CODE
155: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(csat.start_date_active, SYSDATE))

Line 189: CS_SR_EVENT_CODES_B cec

185: role_group_type,
186: role_group_code
187: FROM CS_SR_ACTION_TRIGGERS csat,
188: CS_SR_ACTION_DETAILS csad,
189: CS_SR_EVENT_CODES_B cec
190: /* 03/01/2004 - RHUNGUND - Bug fix for 3412833
191: Commenting the following table from the FROM clause since it was resulting
192: in a cartesian join
193:

Line 625: CS_SR_EVENT_CODES_B cec

621: csat.incident_status_id trigger_incident_status_id,
622: csat.relationship_type_id trigger_link_type
623: FROM CS_SR_ACTION_TRIGGERS csat,
624: CS_SR_ACTION_DETAILS csad,
625: CS_SR_EVENT_CODES_B cec
626: WHERE
627: cec.WF_BUSINESS_EVENT_ID = l_event_name
628: and csat.EVENT_CODE = cec.EVENT_CODE
629: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(csat.start_date_active, SYSDATE))

Line 4684: CS_SR_EVENT_CODES_B cec

4680: csad.action_code,
4681: csad.notification_template_id
4682: FROM CS_SR_ACTION_TRIGGERS csat,
4683: CS_SR_ACTION_DETAILS csad,
4684: CS_SR_EVENT_CODES_B cec
4685: WHERE
4686: cec.WF_BUSINESS_EVENT_ID = l_event_name
4687: and csat.EVENT_CODE = cec.EVENT_CODE
4688: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(csat.start_date_active, SYSDATE))

Line 4975: FROM CS_SR_EVENT_CODES_B cec,

4971: csat.incident_status_id trigger_incident_status_id,
4972: csad.relationship_type_id detail_link_type,
4973: csad.incident_status_id detail_incident_status_id,
4974: csad.resolution_code
4975: FROM CS_SR_EVENT_CODES_B cec,
4976: CS_SR_ACTION_TRIGGERS csat,
4977: CS_SR_ACTION_DETAILS csad
4978: WHERE
4979: cec.WF_BUSINESS_EVENT_ID = l_event_name

Line 5987: CS_SR_EVENT_CODES_B cec

5983: csad.action_code,
5984: to_char(csad.event_condition_id) || csad.action_code index_cols
5985: FROM CS_SR_ACTION_TRIGGERS csat,
5986: CS_SR_ACTION_DETAILS csad,
5987: CS_SR_EVENT_CODES_B cec
5988: WHERE
5989: cec.WF_BUSINESS_EVENT_ID = l_event_name
5990: and csat.EVENT_CODE = cec.EVENT_CODE
5991: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(csat.start_date_active, SYSDATE))

Line 6012: CS_SR_EVENT_CODES_B cec

6008: csad.action_code,
6009: to_char(csad.event_condition_id) || csad.action_code index_cols
6010: FROM CS_SR_ACTION_TRIGGERS csat,
6011: CS_SR_ACTION_DETAILS csad,
6012: CS_SR_EVENT_CODES_B cec
6013: WHERE
6014: cec.WF_BUSINESS_EVENT_ID = l_event_name
6015: and csat.EVENT_CODE = cec.EVENT_CODE
6016: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(csat.start_date_active, SYSDATE))