APPS.JTF_UM_APPROVAL_REQUESTS_PVT dependencies on FND_USER

Line 42: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2

38: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
39: ''USERTYPE'' ENTITY_SOURCE, UT.USERTYPE_SHORTNAME ENTITY_NAME,
40: UTREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
41: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B APPR, HZ_PARTIES PARTY,
42: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2
43: WHERE UTREG.STATUS_CODE in (''PENDING'', ''UPGRADE_APPROVAL_PENDING'')
44: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
45: AND UT.APPROVAL_ID = APPR.APPROVAL_ID
46: AND APPR.USE_PENDING_REQ_FLAG = ''Y''

Line 60: FND_USER FU,

56: FROM JTF_UM_SUBSCRIPTIONS_VL SUB,
57: JTF_UM_APPROVALS_B APPR,
58: HZ_PARTIES PARTY,
59: JTF_UM_SUBSCRIPTION_REG SUBREG,
60: FND_USER FU,
61: JTF_UM_USERTYPE_REG UTREG,
62: FND_USER FU2
63: WHERE SUBREG.STATUS_CODE in (''PENDING'', ''UPGRADE_APPROVAL_PENDING'')
64: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID

Line 62: FND_USER FU2

58: HZ_PARTIES PARTY,
59: JTF_UM_SUBSCRIPTION_REG SUBREG,
60: FND_USER FU,
61: JTF_UM_USERTYPE_REG UTREG,
62: FND_USER FU2
63: WHERE SUBREG.STATUS_CODE in (''PENDING'', ''UPGRADE_APPROVAL_PENDING'')
64: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
65: AND SUB.APPROVAL_ID = APPR.APPROVAL_ID
66: AND APPR.USE_PENDING_REQ_FLAG = ''Y''

Line 152: l_dummy_user_id FND_USER.USER_ID%TYPE;

148: p_number_of_records in number,
149: p_approver_user_id in number,
150: x_result out NOCOPY APPROVAL_REQUEST_TABLE_TYPE) IS
151: l_rownum number := 10; -- Default value
152: l_dummy_user_id FND_USER.USER_ID%TYPE;
153: l_company_id HZ_PARTIES.PARTY_ID%TYPE;
154: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;
155: APPR_REQ APPR_REQ_CUR;
156: qry varchar2(4000) := 'SELECT * FROM

Line 165: HZ_RELATIONSHIPS PREL, JTF_UM_USERTYPE_REG UTREG, FND_USER FU

161: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
162: FU.USER_NAME USER_NAME, ''USERTYPE'' ENTITY_SOURCE,
163: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
164: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B APPR,
165: HZ_RELATIONSHIPS PREL, JTF_UM_USERTYPE_REG UTREG, FND_USER FU
166: WHERE UTREG.STATUS_CODE in (''PENDING'', ''UPGRADE_APPROVAL_PENDING'')
167: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
168: AND UT.APPROVAL_ID = APPR.APPROVAL_ID
169: AND APPR.USE_PENDING_REQ_FLAG = ''Y''

Line 186: FND_USER FU, JTF_UM_USERTYPE_REG UTREG

182: FU.USER_NAME USER_NAME, ''ENROLLMENT'' ENTITY_SOURCE,
183: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
184: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B APPR,
185: HZ_RELATIONSHIPS PREL, JTF_UM_SUBSCRIPTION_REG SUBREG,
186: FND_USER FU, JTF_UM_USERTYPE_REG UTREG
187: WHERE SUBREG.STATUS_CODE in (''PENDING'', ''UPGRADE_APPROVAL_PENDING'')
188: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
189: AND SUB.APPROVAL_ID = APPR.APPROVAL_ID
190: AND APPR.USE_PENDING_REQ_FLAG = ''Y''

Line 207: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL, FND_USER FU

203: AND SUBREG.APPROVER_USER_ID = :l_dummy_user_id
204: ) pri_requests ';
205: CURSOR GET_COMPANY_NAME IS
206: SELECT PARTY.PARTY_NAME, PARTY.PARTY_ID
207: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL, FND_USER FU
208: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
209: AND PREL.PARTY_ID = FU.CUSTOMER_ID
210: AND FU.USER_ID = p_approver_user_id
211: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 220: FROM FND_USER

216: ORDER BY PREL.START_DATE DESC;
217: i NUMBER := 1;
218: CURSOR FIND_DUMMY_USER IS
219: SELECT USER_ID
220: FROM FND_USER
221: WHERE USER_NAME = FND_PROFILE.VALUE('JTF_PRIMARY_USER');
222: BEGIN
223: IF p_number_of_records IS NOT NULL AND p_number_of_records <> 0 THEN
224: l_rownum := p_number_of_records;

Line 305: JTF_UM_USERTYPE_REG UTREG, FND_USER FU

301: PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
302: ''USERTYPE'' ENTITY_SOURCE, UT.USERTYPE_SHORTNAME ENTITY_NAME,
303: UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
304: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B APPR, HZ_PARTIES PARTY,
305: JTF_UM_USERTYPE_REG UTREG, FND_USER FU
306: WHERE UTREG.STATUS_CODE in (''PENDING'', ''UPGRADE_APPROVAL_PENDING'')
307: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
308: AND UT.APPROVAL_ID = APPR.APPROVAL_ID
309: AND APPR.USE_PENDING_REQ_FLAG = ''Y''

Line 320: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG

316: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
317: PARTY.PARTY_ID PARTY_ID, ''ENROLLMENT'' ENTITY_SOURCE,
318: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
319: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B APPR, HZ_PARTIES PARTY,
320: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG
321: WHERE SUBREG.STATUS_CODE in (''PENDING'', ''UPGRADE_APPROVAL_PENDING'')
322: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
323: AND SUB.APPROVAL_ID = APPR.APPROVAL_ID
324: AND APPR.USE_PENDING_REQ_FLAG = ''Y''