APPS.WF_ROLE_HIERARCHY dependencies on WF_USER_ROLE_ASSIGNMENTS_V

Line 1476: FROM WF_USER_ROLE_ASSIGNMENTS_V

1472: --timestamp
1473: if (l_assignmentType = 'I') then
1474: SELECT min(start_date)
1475: INTO l_startDateTAB(userIND)
1476: FROM WF_USER_ROLE_ASSIGNMENTS_V
1477: WHERE USER_NAME = l_userTAB(userIND)
1478: AND ROLE_NAME = l_roleTAB(roleIND);
1479:
1480: SELECT max(end_date)

Line 1482: FROM WF_USER_ROLE_ASSIGNMENTS_V

1478: AND ROLE_NAME = l_roleTAB(roleIND);
1479:
1480: SELECT max(end_date)
1481: INTO l_endDateTAB(userIND)
1482: FROM WF_USER_ROLE_ASSIGNMENTS_V
1483: WHERE USER_NAME = l_userTAB(userIND)
1484: AND ROLE_NAME = l_roleTAB(roleIND);
1485:
1486: end if;