APPS.CSI_UTILITY_GRP dependencies on XNP_MSGS

Line 406: FROM xnp_msgs

402: msg_status,
403: body_text,
404: creation_date,
405: description
406: FROM xnp_msgs
407: WHERE (msg_code like 'CSI%' OR msg_code like 'CSE%')
408: AND msg_status in ('READY','FAILED')
409: AND msg_creation_date > pc_freeze_date
410: -- AND nvl(msg_status, 'READY') <> 'PROCESSED' -- commented for Bug 3987286

Line 744: FROM xnp_msgs

740: msg_status,
741: body_text,
742: creation_date,
743: description
744: FROM xnp_msgs
745: WHERE msg_code = 'CSISOSHP'
746: AND msg_status in ('READY','FAILED')
747: AND msg_creation_date > pc_freeze_date
748: AND recipient_name is null;