APPS.MSDWF dependencies on FND_USER

Line 694: from fnd_user

690:
691: if g_owner <> ' ' then
692:
693: select user_id into msd_user_id
694: from fnd_user
695: where user_name = g_owner;
696:
697: /* select r.application_id, r.responsibility_id into resp_appl_id, resp_id
698: from fnd_application a, fnd_responsibility r

Line 704: from fnd_responsibility r, fnd_user_resp_groups urg, fnd_application a

700: and a.application_short_name = 'MSD'
701: and r.responsibility_key = 'MSD_SYSADMIN'; */
702:
703: select count(*) into number_resps
704: from fnd_responsibility r, fnd_user_resp_groups urg, fnd_application a
705: where r.application_id = a.application_id
706: and r.application_id = urg.responsibility_application_id
707: and r.responsibility_id = urg.responsibility_id
708: and urg.user_id = msd_user_id

Line 722: from fnd_responsibility r, fnd_user_resp_groups urg, fnd_application a

718:
719: elsif number_resps = 1 then
720:
721: select r.application_id, r.responsibility_id into resp_appl_id, resp_id
722: from fnd_responsibility r, fnd_user_resp_groups urg, fnd_application a
723: where r.application_id = a.application_id
724: and r.application_id = urg.responsibility_application_id
725: and r.responsibility_id = urg.responsibility_id
726: and urg.user_id = msd_user_id

Line 736: from fnd_responsibility r, fnd_user_resp_groups urg, fnd_application a

732:
733: else
734: resp_key := 'MSD_SYSADMIN';
735: select r.application_id, r.responsibility_id into resp_appl_id, resp_id
736: from fnd_responsibility r, fnd_user_resp_groups urg, fnd_application a
737: where r.application_id = a.application_id
738: and r.application_id = urg.responsibility_application_id
739: and r.responsibility_id = urg.responsibility_id
740: and urg.user_id = msd_user_id