APPS.WF_ROLE_HIERARCHY dependencies on WF_USER_ROLE_ASSIGNMENTS_V

Line 1448: FROM WF_USER_ROLE_ASSIGNMENTS_V

1444: --timestamp
1445: if (l_assignmentType = 'I') then
1446: SELECT min(start_date)
1447: INTO l_startDateTAB(userIND)
1448: FROM WF_USER_ROLE_ASSIGNMENTS_V
1449: WHERE USER_NAME = l_userTAB(userIND)
1450: AND ROLE_NAME = l_roleTAB(roleIND);
1451:
1452: SELECT max(end_date)

Line 1454: FROM WF_USER_ROLE_ASSIGNMENTS_V

1450: AND ROLE_NAME = l_roleTAB(roleIND);
1451:
1452: SELECT max(end_date)
1453: INTO l_endDateTAB(userIND)
1454: FROM WF_USER_ROLE_ASSIGNMENTS_V
1455: WHERE USER_NAME = l_userTAB(userIND)
1456: AND ROLE_NAME = l_roleTAB(roleIND);
1457:
1458: end if;