APPS.OKC_WF_K_APPROVE dependencies on PER_PEOPLE_F

Line 107: from FND_USER USR, PER_PEOPLE_F PER

103: FND_PROFILE.VALUE('OKC_K_APPROVER') name
104: from dual
105: where not exists
106: ( select '!'
107: from FND_USER USR, PER_PEOPLE_F PER
108: where USR.USER_NAME=FND_PROFILE.VALUE('OKC_K_APPROVER')
109: and USR.EMPLOYEE_ID = PER.PERSON_ID
110: )
111: union all

Line 115: from FND_USER USR, PER_PEOPLE_F PER

111: union all
112: select 1 num,
113: FND_PROFILE.VALUE('OKC_K_APPROVER') role,
114: NVL(PER.FULL_NAME,FND_PROFILE.VALUE('OKC_K_APPROVER')) name
115: from FND_USER USR, PER_PEOPLE_F PER
116: where USR.USER_NAME=FND_PROFILE.VALUE('OKC_K_APPROVER')
117: and USR.EMPLOYEE_ID = PER.PERSON_ID
118: )
119: ------------------------------------------------------

Line 285: from FND_USER USR, PER_PEOPLE_F PER

281: and FND_USER.EMPLOYEE_ID is NULL
282: and trunc(sysdate) between trunc(start_date) and nvl(end_date,sysdate)
283: union all
284: select 'T'
285: from FND_USER USR, PER_PEOPLE_F PER
286: where USR.USER_NAME=p_account
287: and trunc(sysdate) between trunc(USR.start_date) and nvl(USR.end_date,sysdate)
288: and USR.EMPLOYEE_ID = PER.PERSON_ID
289: and trunc(sysdate) between trunc(per.effective_start_date) and nvl(per.effective_end_date,sysdate)

Line 761: PER_PEOPLE_F PER,

757: select
758: USR.USER_NAME name,
759: PER.FULL_NAME display_name
760: from
761: PER_PEOPLE_F PER,
762: FND_USER USR
763: where trunc(SYSDATE) between PER.EFFECTIVE_START_DATE
764: and PER.EFFECTIVE_END_DATE
765: and PER.PERSON_ID = USR.EMPLOYEE_ID

Line 781: PER_PEOPLE_F PER,

777: union all
778: select
779: USR.USER_NAME name, PER.FULL_NAME display_name
780: from
781: PER_PEOPLE_F PER,
782: FND_USER USR
783: where trunc(SYSDATE)
784: between PER.EFFECTIVE_START_DATE and PER.EFFECTIVE_END_DATE
785: and PER.PERSON_ID = USR.EMPLOYEE_ID