DBA Data[Home] [Help]

APPS.WF_EVENT dependencies on FND_APPLICATION

Line 3625: l_appl_short_name fnd_application.application_short_name%TYPE;

3621: l_user_name fnd_user.user_name%TYPE;
3622: l_resp_appl_id fnd_responsibility.application_id%TYPE;
3623: l_resp_key fnd_responsibility.responsibility_key%TYPE;
3624: l_resp_id fnd_responsibility.responsibility_id%TYPE;
3625: l_appl_short_name fnd_application.application_short_name%TYPE;
3626:
3627: PRAGMA AUTONOMOUS_TRANSACTION;
3628:
3629: begin

Line 3660: FROM fnd_application a, fnd_responsibility r

3656: WHERE u.user_name = l_user_name;
3657:
3658: SELECT r.application_id, r.responsibility_id
3659: INTO l_resp_appl_id, l_resp_id
3660: FROM fnd_application a, fnd_responsibility r
3661: WHERE r.application_id = a.application_id
3662: AND a.application_short_name = l_appl_short_name
3663: AND r.responsibility_key = l_resp_key;
3664: