APPS.OKL_SO_CREDIT_APP_WF dependencies on FND_USER

Line 132: from fnd_user

128: L_REQUESTOR_DNAME varchar2(240);
129:
130: cursor C_REQUESTOR_DISPLAY_NAME(P_USER_ID in number) is
131: select user_name name,user_name display_name
132: from fnd_user
133: where user_id=P_USER_ID
134: and employee_id is null
135: union all
136: select

Line 140: FND_USER USR

136: select
137: USR.USER_NAME name, PER.FULL_NAME display_name
138: from
139: PER_PEOPLE_F PER,
140: FND_USER USR
141: where trunc(SYSDATE)
142: between PER.EFFECTIVE_START_DATE and PER.EFFECTIVE_END_DATE
143: and PER.PERSON_ID = USR.EMPLOYEE_ID
144: and USR.USER_ID = P_USER_ID;

Line 238: from FND_USER USR, PER_PEOPLE_F PER

234: select role, name
235: from
236: (select 1 num, FND_PROFILE.VALUE('OKL_CREDIT_ANALYST') role,
237: NVL(PER.FULL_NAME, USR.USER_NAME) name
238: from FND_USER USR, PER_PEOPLE_F PER
239: where USR.USER_NAME = FND_PROFILE.VALUE('OKL_CREDIT_ANALYST')
240: and USR.EMPLOYEE_ID = PER.PERSON_ID(+)
241: and trunc(sysdate) between nvl(per.effective_start_date, trunc(sysdate)) and
242: nvl(per.effective_end_date, trunc(sysdate))

Line 662: FROM fnd_user

658: WHERE user_id = b_user_id;
659:
660: CURSOR c_approver_user_id (b_user_name IN VARCHAR2) IS
661: SELECT user_id
662: FROM fnd_user
663: WHERE user_name = b_user_name;
664:
665: BEGIN
666: --