DBA Data[Home] [Help]

APPS.OZF_APPROVAL_PVT dependencies on PV_NOTIFICATION_SETUPS

Line 1251: FROM pv_notification_setups

1247: CURSOR csr_message (p_object_id number, p_status varchar2, p_user_role varchar2) IS
1248: SELECT user_role
1249: , wf_message_type
1250: , wf_message_name
1251: FROM pv_notification_setups
1252: WHERE benefit_id = p_object_id
1253: AND entity_status = p_status
1254: AND user_role like p_user_role;
1255: