DBA Data[Home] [Help]

APPS.IBU_REQ_PKG dependencies on CS_INCIDENT_TYPES_B

Line 102: | from cs_incident_types_b instead of from |

98: | 115.120 16-APR-2004 WZLI When creating sr, pass sysdate to |
99: | parameter incident_occurred_date. |
100: | 115.121 09-JUN-2004 WZLI Fixed problem(bug#3676419):In procedure |
101: | get_default_status(),select status_group_id|
102: | from cs_incident_types_b instead of from |
103: | cs_incident_types_vl |
104: | 115.122 29-JUL-2004 WZLI Fixed problem(bug#3796975):Saving Service |
105: | request gives invalid date error. |
106: | 115.123 15-OCT-2004 WMA for sendEmail function, use userID |

Line 1465: FROM cs_incident_types_b

1461: TRUNC(NVL(TypeMapping.end_date, SYSDATE));
1462:
1463: cursor cur_sr_def_status_group_b(p_type_id number) is
1464: SELECT status_group_id
1465: FROM cs_incident_types_b
1466: WHERE incident_type_id = p_type_id AND
1467: TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE)) AND
1468: TRUNC(NVL(end_date_active, SYSDATE));
1469: