DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_UTIL dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 2329: FROM WF_NOTIFICATION_ATTRIBUTES na,

2325: SELECT na.NAME
2326: , na.TEXT_VALUE
2327: , na.NUMBER_VALUE
2328: , na.DATE_VALUE
2329: FROM WF_NOTIFICATION_ATTRIBUTES na,
2330: WF_MESSAGE_ATTRIBUTES ma,
2331: WF_NOTIFICATIONS ntf
2332: WHERE ntf.NOTIFICATION_ID = p_orig_ntf_id
2333: AND na.NOTIFICATION_ID = ntf.NOTIFICATION_ID

Line 8358: FROM WF_NOTIFICATION_ATTRIBUTES na,

8354: AND ntf.GROUP_ID = orig_ntf.GROUP_ID
8355: AND ntf.NOTIFICATION_ID <> orig_ntf.NOTIFICATION_ID
8356: AND orig_ntf.NOTIFICATION_ID = p_orig_ntf_id
8357: AND EXISTS (SELECT 1
8358: FROM WF_NOTIFICATION_ATTRIBUTES na,
8359: WF_MESSAGE_ATTRIBUTES ma
8360: WHERE na.NOTIFICATION_ID = ntf.NOTIFICATION_ID
8361: AND ma.MESSAGE_NAME = ntf.MESSAGE_NAME
8362: AND ma.MESSAGE_TYPE = ntf.MESSAGE_TYPE

Line 9986: , WF_NOTIFICATION_ATTRIBUTES wfna

9982: SELECT COUNT(*)
9983: INTO l_code_count
9984: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9985: , EGO_USER_V UserV
9986: , WF_NOTIFICATION_ATTRIBUTES wfna
9987: , WF_NOTIFICATIONS wn
9988: WHERE RoutePeople.assignee_id = UserV.party_id
9989: AND RoutePeople.response_condition_code = 'MANDATORY'
9990: AND RoutePeople.step_id = StepId

Line 11218: FROM WF_NOTIFICATION_ATTRIBUTES na,

11214: AND wias.ITEM_TYPE = p_item_type
11215: AND wias.ITEM_KEY = p_item_key
11216: AND ntf.RECIPIENT_ROLE = p_responder
11217: AND EXISTS (SELECT 1
11218: FROM WF_NOTIFICATION_ATTRIBUTES na,
11219: WF_MESSAGE_ATTRIBUTES ma
11220: WHERE na.NOTIFICATION_ID = ntf.NOTIFICATION_ID
11221: AND ma.MESSAGE_NAME = ntf.MESSAGE_NAME
11222: AND ma.MESSAGE_TYPE = ntf.MESSAGE_TYPE