APPS.ENG_WORKFLOW_UTIL dependencies on EGO_USER_V

Line 9884: , EGO_USER_V UserV

9880: --
9881: SELECT COUNT(*)
9882: INTO l_total_pop
9883: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9884: , EGO_USER_V UserV
9885: , WF_NOTIFICATIONS wn
9886: WHERE RoutePeople.assignee_id = UserV.party_id
9887: AND RoutePeople.response_condition_code = 'MANDATORY'
9888: AND RoutePeople.step_id = StepId

Line 9896: , EGO_USER_V UserV

9892:
9893: SELECT COUNT(*)
9894: INTO l_total_voted
9895: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9896: , EGO_USER_V UserV
9897: , WF_NOTIFICATIONS wn
9898: WHERE RoutePeople.assignee_id = UserV.party_id
9899: AND RoutePeople.response_condition_code = 'MANDATORY'
9900: AND RoutePeople.step_id = StepId

Line 9909: , EGO_USER_V UserV

9905:
9906: SELECT COUNT(*)
9907: INTO l_code_count
9908: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9909: , EGO_USER_V UserV
9910: , WF_NOTIFICATION_ATTRIBUTES wfna
9911: , WF_NOTIFICATIONS wn
9912: WHERE RoutePeople.assignee_id = UserV.party_id
9913: AND RoutePeople.response_condition_code = 'MANDATORY'

Line 10695: FROM EGO_USER_V UserV

10691: CURSOR c_ntf_info (p_ntf_id NUMBER)
10692: IS
10693:
10694: SELECT UserV.user_id user_id
10695: FROM EGO_USER_V UserV
10696: , WF_NOTIFICATIONS wf
10697: WHERE UserV.user_name = wf.recipient_role
10698: AND wf.notification_id = p_ntf_id ;
10699:

Line 10704: FROM EGO_USER_V UserV

10700:
10701: CURSOR c_person_id (p_user_id NUMBER)
10702: IS
10703: SELECT UserV.party_id person_id
10704: FROM EGO_USER_V UserV
10705: WHERE UserV.user_id = p_user_id ;
10706:
10707: BEGIN
10708:

Line 10812: FROM EGO_USER_V UserV

10808: CURSOR c_ntf_info (p_ntf_id NUMBER)
10809: IS
10810:
10811: SELECT UserV.user_id user_id
10812: FROM EGO_USER_V UserV
10813: , WF_NOTIFICATIONS wf
10814: WHERE UserV.user_name = wf.recipient_role
10815: AND wf.notification_id = p_ntf_id ;
10816:

Line 10821: FROM EGO_USER_V UserV

10817:
10818: CURSOR c_person_id (p_user_id NUMBER)
10819: IS
10820: SELECT UserV.party_id person_id
10821: FROM EGO_USER_V UserV
10822: WHERE UserV.user_id = p_user_id ;
10823:
10824: BEGIN
10825: