APPS.OKL_SO_CREDIT_APP_WF dependencies on FND_USER

Line 135: from fnd_user

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

Line 143: FND_USER USR

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

Line 241: from FND_USER USR, PER_PEOPLE_F PER

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

Line 665: FROM fnd_user

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