DBA Data[Home] [Help]

APPS.PSA_UTILS dependencies on FND_USER_RESP_GROUPS_DIRECT

Line 1820: FROM fnd_user_resp_groups_direct a

1816: a.responsibility_application_id
1817: INTO l_start_date,
1818: l_end_date,
1819: l_resp_appl_id
1820: FROM fnd_user_resp_groups_direct a
1821: WHERE a.responsibility_id = p_resp_id
1822: AND a.user_id = p_user_id;
1823:
1824: IF (SYSDATE BETWEEN l_start_date AND NVL(l_end_date, SYSDATE)) THEN

Line 1839: undo_error('Getting fnd_user_resp_groups_direct:'||SQLERRM);

1835: WHEN NO_DATA_FOUND THEN
1836: undo_error ('User does not have access to the Repsonsibility');
1837: RAISE;
1838: WHEN OTHERS THEN
1839: undo_error('Getting fnd_user_resp_groups_direct:'||SQLERRM);
1840: RAISE;
1841: END;
1842:
1843: EXCEPTION