DBA Data[Home] [Help]

APPS.CLN_NP_PROCESSOR_PKG dependencies on CLN_NOTIFICATION_CODES_TL

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');