APPS.OKL_SO_CREDIT_APP_WF dependencies on PER_PEOPLE_F

Line 142: PER_PEOPLE_F PER,

138: union all
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

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))