APPS.HR_USER_ACCT_INTERNAL dependencies on FND_USER_RESP_GROUPS_DIRECT

Line 2596: FROM fnd_user_resp_groups_direct

2592: ,responsibility_id
2593: ,start_date
2594: ,end_date
2595: ,description
2596: FROM fnd_user_resp_groups_direct
2597: WHERE user_id = p_user_id
2598: AND responsibility_id = p_responsibility_id
2599: AND responsibility_application_id = p_resp_application_id
2600: AND security_group_id = p_security_group_id;

Line 2727: FND_USER_RESP_GROUPS_DIRECT instead of FND_USER_RESP_GROUPS

2723: Bug fix 8582264
2724: When 2 responsibilities have same responsibility_id , but different
2725: application_ids and one of those responsibility is end dated, l_dummy
2726: will be 0. In this case, we will fetch the data from
2727: FND_USER_RESP_GROUPS_DIRECT instead of FND_USER_RESP_GROUPS
2728: */
2729:
2730: IF l_dummy = 0 OR l_dummy IS NULL THEN
2731: OPEN lc_user_resp_direct_row;