APPS.OKC_WF_K_APPROVE dependencies on FND_USER

Line 90: and restrict select to fnd_user data only

86: DISPLAY_NAME name
87: from wf_roles
88: where name=FND_PROFILE.VALUE('OKC_K_APPROVER'))
89:
90: and restrict select to fnd_user data only
91:
92: might be customisation problem
93:
94: */

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 135: -- For role comming from fnd_user use validation:

131: -- where r.APPLICATION_ID = a.APPLICATION_ID
132: -- and a.APPLICATION_SHORT_NAME like 'OK_'
133: -- order by RESPONSIBILITY_NAME"
134:
135: -- For role comming from fnd_user use validation:
136: -- SQL="SELECT USER_NAME \"Contract Approver\",
137: -- USER_NAME \"WF Role Name\"
138: -- INTO :visible_option_value, :profile_option_value
139: -- from fnd_user

Line 139: -- from fnd_user

135: -- For role comming from fnd_user use validation:
136: -- SQL="SELECT USER_NAME \"Contract Approver\",
137: -- USER_NAME \"WF Role Name\"
138: -- INTO :visible_option_value, :profile_option_value
139: -- from fnd_user
140: -- order by USER_NAME"
141: -- COLUMN="\"Contract Approver\"(30)"
142: -- COLUMN="\"WF Role Name\"(30)"
143:

Line 278: from FND_USER

274: resultout out nocopy varchar2 ) is
275:
276: cursor c1(p_account varchar2) is
277: select 'T'
278: from FND_USER
279: where
280: FND_USER.USER_NAME=p_account
281: and FND_USER.EMPLOYEE_ID is NULL
282: and trunc(sysdate) between trunc(start_date) and nvl(end_date,sysdate)

Line 280: FND_USER.USER_NAME=p_account

276: cursor c1(p_account varchar2) is
277: select 'T'
278: from FND_USER
279: where
280: FND_USER.USER_NAME=p_account
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'

Line 281: and FND_USER.EMPLOYEE_ID is NULL

277: select 'T'
278: from FND_USER
279: where
280: FND_USER.USER_NAME=p_account
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

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 762: FND_USER USR

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
766: and USR.USER_ID = P_USER_ID

Line 774: from fnd_user

770: and orig_system_id=P_USER_ID)
771: -- replaced to boost perf
772: */
773: select user_name name,user_name display_name
774: from fnd_user
775: where user_id=P_USER_ID
776: and employee_id is null
777: union all
778: select

Line 782: FND_USER USR

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
786: and USR.USER_ID = P_USER_ID