DBA Data[Home] [Help]

APPS.OKC_WF_CHK_APPROVE dependencies on FND_USER

Line 39: from FND_USER USR, PER_PEOPLE_F PER

35: from -- here should be your view of structure (num,role,name)
36: ------------------------------------------------------
37: (select 1 num, FND_PROFILE.VALUE('OKC_CR_APPROVER') role,
38: NVL(PER.FULL_NAME, USR.USER_NAME) name
39: from FND_USER USR, PER_PEOPLE_F PER
40: where USR.USER_NAME = FND_PROFILE.VALUE('OKC_CR_APPROVER')
41: and USR.EMPLOYEE_ID = PER.PERSON_ID(+)
42: and trunc(sysdate) between nvl(per.effective_start_date, trunc(sysdate)) and
43: nvl(per.effective_end_date, trunc(sysdate))

Line 57: from FND_USER USR, PER_PEOPLE_F PER

53: from -- here should be your view of structure (num,role,name)
54: ------------------------------------------------------
55: (select 1 num, FND_PROFILE.VALUE('OKC_CR_APPROVER') role,
56: NVL(PER.FULL_NAME, USR.USER_NAME) name
57: from FND_USER USR, PER_PEOPLE_F PER
58: where USR.USER_NAME = FND_PROFILE.VALUE('OKC_CR_APPROVER')
59: and USR.EMPLOYEE_ID = PER.PERSON_ID(+)
60: and trunc(sysdate) between nvl(per.effective_start_date, trunc(sysdate)) and
61: nvl(per.effective_end_date, trunc(sysdate))

Line 189: FND_USER USR

185: USR.USER_NAME name,
186: PER.FULL_NAME display_name
187: from
188: PER_PEOPLE_F PER,
189: FND_USER USR
190: where trunc(SYSDATE) between PER.EFFECTIVE_START_DATE
191: and PER.EFFECTIVE_END_DATE
192: and PER.PERSON_ID = USR.EMPLOYEE_ID
193: and USR.USER_ID = P_USER_ID