DBA Data[Home] [Help]

APPS.WSH_RU_ACTIONS dependencies on WSH_LOOKUPS

Line 802: ,wsh_lookups activity

798: ,p_lookup_type in VARCHAR2) is
799: select msgs.activity_code , msgs.validation_code , msgs.return_status
800: from wsh_customized_activity_msgs msgs
801: ,wsh_grants grants
802: ,wsh_lookups activity
803: ,wsh_lookups message
804: where grants.user_id = p_user_id
805: and sysdate between nvl(grants.start_date,sysdate) and nvl(grants.end_date,sysdate )
806: and msgs.activity_code = p_activity_code

Line 803: ,wsh_lookups message

799: select msgs.activity_code , msgs.validation_code , msgs.return_status
800: from wsh_customized_activity_msgs msgs
801: ,wsh_grants grants
802: ,wsh_lookups activity
803: ,wsh_lookups message
804: where grants.user_id = p_user_id
805: and sysdate between nvl(grants.start_date,sysdate) and nvl(grants.end_date,sysdate )
806: and msgs.activity_code = p_activity_code
807: and msgs.validation_code = p_validation_code