APPS.BIS_PMV_UTIL dependencies on FND_USER

Line 633: l_user_id fnd_user.user_id%TYPE;

629: l_default_resp_id fnd_responsibility.responsibility_id%TYPE;
630: l_appl_id fnd_responsibility.application_id%TYPE;
631: l_function_name fnd_form_functions.function_name%TYPE;
632: l_menu_id fnd_responsibility.menu_id%TYPE;
633: l_user_id fnd_user.user_id%TYPE;
634: CURSOR CM IS
635: SELECT 1
636: FROM FND_MENU_ENTRIES MEV, FND_RESP_FUNCTIONS RF, FND_FORM_FUNCTIONS FF
637: WHERE MEV.MENU_ID = l_menu_id

Line 665: fnd_user_resp_groups b

661: AND RF.APPLICATION_ID(+) = l_appl_id;
662: CURSOR c_resp IS
663: select a.responsibility_id resp_id , a.menu_id menu_id, a.application_id appl_id
664: from fnd_responsibility a,
665: fnd_user_resp_groups b
666: where b.user_id = l_user_id
667: and a.version = 'W'
668: and b.responsibility_id = a.responsibility_id
669: and b.start_date <= sysdate

Line 704: from fnd_user

700: )
701: IS
702: cursor c_username is
703: select user_name
704: from fnd_user
705: where user_id=puserid;
706: l_user_name varchar2(200);
707: BEGIN
708: /*OPEN c_username;