APPS.HR_USER_ACCT_API dependencies on FND_USER_RESP_GROUPS_DIRECT

Line 1056: -- Fix for bug 4147802 starts here. used fnd_user_resp_groups_direct view

1052: -- Cursor to select all records which belongs to the terminated employee's
1053: -- user id and the end date is null or the end date is greater than the
1054: -- termination date.
1055: --
1056: -- Fix for bug 4147802 starts here. used fnd_user_resp_groups_direct view
1057: -- in place of fnd_user_resp_groups. Also the column description is removed.
1058: --
1059: CURSOR lc_get_user_resp (c_user_id in number)
1060: IS

Line 1068: FROM fnd_user_resp_groups_direct

1064: ,security_group_id
1065: ,start_date
1066: ,end_date
1067: -- ,description
1068: FROM fnd_user_resp_groups_direct
1069: WHERE user_id = c_user_id
1070: AND nvl(end_date, l_date + 1) > l_date
1071: AND trunc(sysdate) between start_date and nvl(end_date,sysdate); --5090502
1072: */

Line 1079: FROM fnd_user_resp_groups_direct furgd, FND_RESPONSIBILITY fr

1075: ,furgd.security_group_id
1076: ,furgd.start_date
1077: ,furgd.end_date
1078: -- ,description
1079: FROM fnd_user_resp_groups_direct furgd, FND_RESPONSIBILITY fr
1080: WHERE furgd.user_id = c_user_id
1081: AND fr.responsibility_id = furgd.responsibility_id
1082: AND trunc(sysdate) between fr.start_date and nvl(fr.end_date,sysdate)
1083: AND nvl(furgd.end_date, l_date + 1) > l_date