DBA Data[Home] [Help]

APPS.GMD_QMSMC dependencies on FND_USER

Line 446: FROM fnd_user

442:
443: CURSOR get_user_name (x_user_id NUMBER)
444: IS /* 4576699 */
445: SELECT user_name
446: FROM fnd_user
447: WHERE user_id = x_user_id;
448:
449: BEGIN
450: gmd_debug.put_line ('SampleCreation WF. VERIFY_EVENT '); /* 4576699 */

Line 1853: select user_name into l_user from fnd_user

1849: /* No Approval Required */
1850: P_resultout:='COMPLETE:N';
1851: ELSE
1852: IF(Approver.person_id is null) THEN
1853: select user_name into l_user from fnd_user
1854: where user_id=Approver.user_id;
1855: ELSE
1856: select user_name into l_user from fnd_user
1857: where

Line 1856: select user_name into l_user from fnd_user

1852: IF(Approver.person_id is null) THEN
1853: select user_name into l_user from fnd_user
1854: where user_id=Approver.user_id;
1855: ELSE
1856: select user_name into l_user from fnd_user
1857: where
1858: user_id=AME_UTIL.PERSONIDTOUSERID(Approver.person_id);
1859: END IF;
1860:

Line 2629: from fnd_user

2625:
2626: IF(Approver.person_id is null) THEN
2627: select user_name
2628: into l_user
2629: from fnd_user
2630: where user_id=Approver.user_id;
2631: ELSE
2632: select user_name
2633: into l_user

Line 2634: from fnd_user

2630: where user_id=Approver.user_id;
2631: ELSE
2632: select user_name
2633: into l_user
2634: from fnd_user
2635: where user_id=AME_UTIL.PERSONIDTOUSERID(Approver.person_id);
2636: END IF;
2637:
2638: IF (l_debug = 'Y') THEN