APPS.OKL_SO_CREDIT_APP_WF dependencies on PER_PEOPLE_F

Line 139: PER_PEOPLE_F PER,

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

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