APPS.CLN_NP_PROCESSOR_PKG dependencies on CLN_NOTIFICATION_CODES

Line 203: FROM CLN_NOTIFICATION_CODES codes, CLN_NOTIFICATION_ACTION_HDR header, CLN_NOTIFICATION_ACTION_DTL details

199: SELECT codes.notification_message,details.action_dtl_id, details.action_code, details.attribute1,
200: details.attribute2, details.attribute3, details.attribute4, details.attribute5, details.attribute6,
201: details.attribute7, details.attribute8, details.attribute9, details.attribute10, details.attribute11,
202: details.attribute12, details.attribute13, details.attribute14, details.attribute15
203: FROM CLN_NOTIFICATION_CODES codes, CLN_NOTIFICATION_ACTION_HDR header, CLN_NOTIFICATION_ACTION_DTL details
204: WHERE codes.NOTIFICATION_CODE = p_notification_code and codes.collaboration_point = p_coll_point
205: and header.notification_id = codes.notification_id and header.application_id = p_application_id
206: and header.collaboration_type = p_collaboration_type and header.ACTION_HDR_ID = details.ACTION_HDR_ID
207: and details.active_flag = 'Y'

Line 1993: FROM CLN_NOTIFICATION_CODES codes, CLN_NOTIFICATION_CODES_TL codestl

1989: IF(p_collaboration_point IS NOT NULL AND p_notification_code IS NOT NULL) THEN
1990: BEGIN
1991: SELECT codestl.NOTIFICATION_MESSAGE
1992: INTO l_notification_desc
1993: FROM CLN_NOTIFICATION_CODES codes, CLN_NOTIFICATION_CODES_TL codestl
1994: WHERE codes.NOTIFICATION_ID = codestl.NOTIFICATION_ID
1995: AND NOTIFICATION_CODE = p_notification_code
1996: AND COLLABORATION_POINT = p_collaboration_point
1997: AND LANGUAGE = USERENV('LANG');