APPS.ENG_WORKFLOW_UTIL dependencies on ENG_SECURITY_PEOPLE_V

Line 763: FROM ENG_SECURITY_PEOPLE_V EngSecPeople

759:
760: CURSOR c_party (p_party_id NUMBER)
761: IS
762: SELECT EngSecPeople.user_name user_role
763: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
764: WHERE EngSecPeople.person_id = p_party_id ;
765:
766: BEGIN
767:

Line 998: FROM ENG_SECURITY_PEOPLE_V EngSecPeople

994:
995: CURSOR c_route_people (p_route_id NUMBER)
996: IS
997: SELECT EngSecPeople.user_name user_role
998: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
999: , ENG_CHANGE_ROUTE_PEOPLE step_people
1000: , ENG_CHANGE_ROUTE_STEPS step
1001: WHERE EngSecPeople.person_id = step_people.assignee_id
1002: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON

Line 1052: FROM ENG_SECURITY_PEOPLE_V EngSecPeople

1048: -- In case of Instance Route, Assignee Id is always person's party id
1049: CURSOR c_step_people (p_route_step_id NUMBER)
1050: IS
1051: SELECT EngSecPeople.user_name user_role
1052: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
1053: , ENG_CHANGE_ROUTE_PEOPLE step_people
1054: WHERE EngSecPeople.person_id = step_people.assignee_id
1055: AND step_people.assignee_id <> -1
1056: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON

Line 1244: FROM ENG_SECURITY_PEOPLE_V EngSecPeople

1240:
1241: CURSOR c_party (p_party_id NUMBER)
1242: IS
1243: SELECT EngSecPeople.user_name user_role
1244: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
1245: WHERE EngSecPeople.person_id = p_party_id ;
1246:
1247: BEGIN
1248:

Line 1401: FROM ENG_SECURITY_PEOPLE_V EngSecPeople

1397:
1398: CURSOR c_route_people (p_route_id NUMBER)
1399: IS
1400: SELECT EngSecPeople.user_name user_role
1401: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
1402: , ENG_CHANGE_ROUTE_PEOPLE step_people
1403: , ENG_CHANGE_ROUTE_STEPS step
1404: WHERE EngSecPeople.person_id = step_people.assignee_id
1405: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON

Line 1437: FROM ENG_SECURITY_PEOPLE_V EngSecPeople

1433: -- In case of Instance Route, Assignee Id is always person's party id
1434: CURSOR c_step_people (p_route_step_id NUMBER)
1435: IS
1436: SELECT EngSecPeople.user_name user_role
1437: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
1438: , ENG_CHANGE_ROUTE_PEOPLE step_people
1439: WHERE EngSecPeople.person_id = step_people.assignee_id
1440: AND step_people.assignee_id <> -1
1441: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON

Line 8292: , ENG_SECURITY_PEOPLE_V EngSecPeople

8288: , RoutePeople.original_assignee_id
8289: , RoutePeople.original_assignee_type_code
8290: , RoutePeople.response_condition_code
8291: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
8292: , ENG_SECURITY_PEOPLE_V EngSecPeople
8293: , WF_NOTIFICATIONS wn
8294: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
8295: -- AND RoutePeople.assignee_type_code = p_assignee_type_code
8296: AND RoutePeople.step_id = p_step_id

Line 13233: , ENG_SECURITY_PEOPLE_V EngSecPeople

13229: , RoutePeople.original_assignee_id
13230: , RoutePeople.original_assignee_type_code
13231: , RoutePeople.response_condition_code
13232: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
13233: , ENG_SECURITY_PEOPLE_V EngSecPeople
13234: , WF_NOTIFICATIONS wn
13235: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
13236: -- AND RoutePeople.assignee_type_code = p_assignee_type_code
13237: AND RoutePeople.step_id = p_step_id

Line 13309: FROM ENG_SECURITY_PEOPLE_V

13305: END IF ;
13306:
13307:
13308: SELECT person_id into l_new_party_id
13309: FROM ENG_SECURITY_PEOPLE_V
13310: WHERE user_name = WF_ENGINE.context_new_role;
13311:
13312: IF g_debug_flag THEN
13313: Write_Debug('Route NEW Party id to whom NTF is being transfered or reassigned: ' || to_char(l_new_party_id));