eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_UM_APPROVAL_REQUESTS_PVT dependencies on FND_USER

Line 44: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2

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

Line 64: FND_USER FU,

60: FROM JTF_UM_SUBSCRIPTIONS_VL SUB,
61: JTF_UM_APPROVALS_B AP,
62: HZ_PARTIES PARTY,
63: JTF_UM_SUBSCRIPTION_REG SUBREG,
64: FND_USER FU,
65: JTF_UM_USERTYPE_REG UTREG,
66: FND_USER FU2
67: WHERE SUBREG.STATUS_CODE = 'PENDING'
68: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID

Line 66: FND_USER FU2

62: HZ_PARTIES PARTY,
63: JTF_UM_SUBSCRIPTION_REG SUBREG,
64: FND_USER FU,
65: JTF_UM_USERTYPE_REG UTREG,
66: FND_USER FU2
67: WHERE SUBREG.STATUS_CODE = 'PENDING'
68: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
69: AND SUB.APPROVAL_ID = AP.APPROVAL_ID
70: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 97: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2

93: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
94: 'USERTYPE' ENTITY_SOURCE, UT.USERTYPE_SHORTNAME ENTITY_NAME,
95: UTREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
96: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
97: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2
98: WHERE UTREG.STATUS_CODE = 'PENDING'
99: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
100: AND UT.APPROVAL_ID = AP.APPROVAL_ID
101: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 114: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,

110: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
111: 'ENROLLMENT' ENTITY_SOURCE, SUB.SUBSCRIPTION_NAME ENTITY_NAME,
112: SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
113: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
114: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,
115: FND_USER FU2
116: WHERE SUBREG.STATUS_CODE = 'PENDING'
117: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
118: AND SUB.APPROVAL_ID = AP.APPROVAL_ID

Line 115: FND_USER FU2

111: 'ENROLLMENT' ENTITY_SOURCE, SUB.SUBSCRIPTION_NAME ENTITY_NAME,
112: SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
113: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
114: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,
115: FND_USER FU2
116: WHERE SUBREG.STATUS_CODE = 'PENDING'
117: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
118: AND SUB.APPROVAL_ID = AP.APPROVAL_ID
119: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 147: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2

143: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
144: 'USERTYPE' ENTITY_SOURCE, UT.USERTYPE_SHORTNAME ENTITY_NAME,
145: UTREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
146: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
147: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2
148: WHERE UTREG.STATUS_CODE = 'PENDING'
149: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
150: AND UT.APPROVAL_ID = AP.APPROVAL_ID
151: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 165: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,

161: PARTY_TYPE, PARTY.PARTY_ID PARTY_ID, 'ENROLLMENT' ENTITY_SOURCE,
162: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE,
163: FU2.USER_NAME APPROVER
164: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
165: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,
166: FND_USER FU2
167: WHERE SUBREG.STATUS_CODE = 'PENDING'
168: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
169: AND SUB.APPROVAL_ID = AP.APPROVAL_ID

Line 166: FND_USER FU2

162: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE,
163: FU2.USER_NAME APPROVER
164: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
165: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,
166: FND_USER FU2
167: WHERE SUBREG.STATUS_CODE = 'PENDING'
168: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
169: AND SUB.APPROVAL_ID = AP.APPROVAL_ID
170: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 199: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2

195: PARTY.PARTY_ID PARTY_ID, 'USERTYPE' ENTITY_SOURCE,
196: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE,
197: FU2.USER_NAME APPROVER
198: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
199: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2
200: WHERE UTREG.STATUS_CODE = 'PENDING'
201: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
202: AND UT.APPROVAL_ID = AP.APPROVAL_ID
203: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 216: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,

212: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
213: 'ENROLLMENT' ENTITY_SOURCE, SUB.SUBSCRIPTION_NAME ENTITY_NAME,
214: SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
215: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
216: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,
217: FND_USER FU2
218: WHERE SUBREG.STATUS_CODE = 'PENDING'
219: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
220: AND SUB.APPROVAL_ID = AP.APPROVAL_ID

Line 217: FND_USER FU2

213: 'ENROLLMENT' ENTITY_SOURCE, SUB.SUBSCRIPTION_NAME ENTITY_NAME,
214: SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
215: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
216: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,
217: FND_USER FU2
218: WHERE SUBREG.STATUS_CODE = 'PENDING'
219: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
220: AND SUB.APPROVAL_ID = AP.APPROVAL_ID
221: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 250: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2

246: PARTY.PARTY_ID PARTY_ID, 'USERTYPE' ENTITY_SOURCE,
247: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE,
248: FU2.USER_NAME APPROVER
249: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
250: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2
251: WHERE UTREG.STATUS_CODE = 'PENDING'
252: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
253: AND UT.APPROVAL_ID = AP.APPROVAL_ID
254: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 267: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,

263: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
264: 'ENROLLMENT' ENTITY_SOURCE, SUB.SUBSCRIPTION_NAME ENTITY_NAME,
265: SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
266: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
267: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,
268: FND_USER FU2
269: WHERE SUBREG.STATUS_CODE = 'PENDING'
270: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
271: AND SUB.APPROVAL_ID = AP.APPROVAL_ID

Line 268: FND_USER FU2

264: 'ENROLLMENT' ENTITY_SOURCE, SUB.SUBSCRIPTION_NAME ENTITY_NAME,
265: SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
266: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
267: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,
268: FND_USER FU2
269: WHERE SUBREG.STATUS_CODE = 'PENDING'
270: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
271: AND SUB.APPROVAL_ID = AP.APPROVAL_ID
272: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 301: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2

297: PARTY.PARTY_ID PARTY_ID, 'USERTYPE' ENTITY_SOURCE,
298: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE,
299: FU2.USER_NAME APPROVER
300: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
301: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2
302: WHERE UTREG.STATUS_CODE = 'PENDING'
303: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
304: AND UT.APPROVAL_ID = AP.APPROVAL_ID
305: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 318: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,

314: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
315: 'ENROLLMENT' ENTITY_SOURCE, SUB.SUBSCRIPTION_NAME ENTITY_NAME,
316: SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
317: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
318: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,
319: FND_USER FU2
320: WHERE SUBREG.STATUS_CODE = 'PENDING'
321: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
322: AND SUB.APPROVAL_ID = AP.APPROVAL_ID

Line 319: FND_USER FU2

315: 'ENROLLMENT' ENTITY_SOURCE, SUB.SUBSCRIPTION_NAME ENTITY_NAME,
316: SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
317: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
318: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,
319: FND_USER FU2
320: WHERE SUBREG.STATUS_CODE = 'PENDING'
321: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
322: AND SUB.APPROVAL_ID = AP.APPROVAL_ID
323: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 528: l_dummy_user_id FND_USER.USER_ID%TYPE;

524: p_approver_user_id in number,
525: x_result out NOCOPY APPROVAL_REQUEST_TABLE_TYPE) IS
526:
527: l_rownum number := 10; -- Default value
528: l_dummy_user_id FND_USER.USER_ID%TYPE;
529: l_company_id HZ_PARTIES.PARTY_ID%TYPE;
530: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;
531:
532: CURSOR APPR_REQ_USER_NAME IS

Line 541: HZ_RELATIONSHIPS PREL, JTF_UM_USERTYPE_REG UTREG, FND_USER FU

537: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
538: FU.USER_NAME USER_NAME, 'USERTYPE' ENTITY_SOURCE,
539: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
540: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP,
541: HZ_RELATIONSHIPS PREL, JTF_UM_USERTYPE_REG UTREG, FND_USER FU
542:
543: WHERE UTREG.STATUS_CODE = 'PENDING'
544: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
545: AND UT.APPROVAL_ID = AP.APPROVAL_ID

Line 565: FND_USER FU, JTF_UM_USERTYPE_REG UTREG

561: FU.USER_NAME USER_NAME, 'ENROLLMENT' ENTITY_SOURCE,
562: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
563: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP,
564: HZ_RELATIONSHIPS PREL, JTF_UM_SUBSCRIPTION_REG SUBREG,
565: FND_USER FU, JTF_UM_USERTYPE_REG UTREG
566: WHERE SUBREG.STATUS_CODE = 'PENDING'
567: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
568: AND SUB.APPROVAL_ID = AP.APPROVAL_ID
569: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 595: HZ_RELATIONSHIPS PREL, JTF_UM_USERTYPE_REG UTREG, FND_USER FU

591: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
592: FU.USER_NAME USER_NAME, 'USERTYPE' ENTITY_SOURCE,
593: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
594: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP,
595: HZ_RELATIONSHIPS PREL, JTF_UM_USERTYPE_REG UTREG, FND_USER FU
596: WHERE UTREG.STATUS_CODE = 'PENDING'
597: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
598: AND UT.APPROVAL_ID = AP.APPROVAL_ID
599: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 618: FND_USER FU, JTF_UM_USERTYPE_REG UTREG

614: FU.USER_NAME USER_NAME, 'ENROLLMENT' ENTITY_SOURCE,
615: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
616: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP,
617: HZ_RELATIONSHIPS PREL, JTF_UM_SUBSCRIPTION_REG SUBREG,
618: FND_USER FU, JTF_UM_USERTYPE_REG UTREG
619: WHERE SUBREG.STATUS_CODE = 'PENDING'
620: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
621: AND SUB.APPROVAL_ID = AP.APPROVAL_ID
622: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 648: HZ_RELATIONSHIPS PREL, JTF_UM_USERTYPE_REG UTREG, FND_USER FU

644: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
645: FU.USER_NAME USER_NAME, 'USERTYPE' ENTITY_SOURCE,
646: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
647: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP,
648: HZ_RELATIONSHIPS PREL, JTF_UM_USERTYPE_REG UTREG, FND_USER FU
649: WHERE UTREG.STATUS_CODE = 'PENDING'
650: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
651: AND UT.APPROVAL_ID = AP.APPROVAL_ID
652: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 671: FND_USER FU, JTF_UM_USERTYPE_REG UTREG

667: FU.USER_NAME USER_NAME,'ENROLLMENT' ENTITY_SOURCE,
668: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
669: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP,
670: HZ_RELATIONSHIPS PREL, JTF_UM_SUBSCRIPTION_REG SUBREG,
671: FND_USER FU, JTF_UM_USERTYPE_REG UTREG
672: WHERE SUBREG.STATUS_CODE = 'PENDING'
673: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
674: AND SUB.APPROVAL_ID = AP.APPROVAL_ID
675: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 702: FND_USER FU

698: FROM JTF_UM_USERTYPES_VL UT,
699: JTF_UM_APPROVALS_B AP,
700: HZ_RELATIONSHIPS PREL,
701: JTF_UM_USERTYPE_REG UTREG,
702: FND_USER FU
703:
704: WHERE UTREG.STATUS_CODE = 'PENDING'
705: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
706: AND UT.APPROVAL_ID = AP.APPROVAL_ID

Line 726: FND_USER FU, JTF_UM_USERTYPE_REG UTREG

722: FU.USER_NAME USER_NAME,'ENROLLMENT' ENTITY_SOURCE,
723: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
724: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP,
725: HZ_RELATIONSHIPS PREL, JTF_UM_SUBSCRIPTION_REG SUBREG,
726: FND_USER FU, JTF_UM_USERTYPE_REG UTREG
727: WHERE SUBREG.STATUS_CODE = 'PENDING'
728: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
729: AND SUB.APPROVAL_ID = AP.APPROVAL_ID
730: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 757: FND_USER FU

753: FROM JTF_UM_USERTYPES_VL UT,
754: JTF_UM_APPROVALS_B AP,
755: HZ_RELATIONSHIPS PREL,
756: JTF_UM_USERTYPE_REG UTREG,
757: FND_USER FU
758:
759: WHERE UTREG.STATUS_CODE = 'PENDING'
760: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
761: AND UT.APPROVAL_ID = AP.APPROVAL_ID

Line 781: FND_USER FU, JTF_UM_USERTYPE_REG UTREG

777: FU.USER_NAME USER_NAME,'ENROLLMENT' ENTITY_SOURCE,
778: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
779: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP,
780: HZ_RELATIONSHIPS PREL, JTF_UM_SUBSCRIPTION_REG SUBREG,
781: FND_USER FU, JTF_UM_USERTYPE_REG UTREG
782: WHERE SUBREG.STATUS_CODE = 'PENDING'
783: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
784: AND SUB.APPROVAL_ID = AP.APPROVAL_ID
785: AND AP.USE_PENDING_REQ_FLAG = 'Y'

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

800: ) pri_requests where rownum < l_rownum order by REG_ID;
801:
802: CURSOR GET_COMPANY_NAME IS
803: SELECT PARTY.PARTY_NAME, PARTY.PARTY_ID
804: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL, FND_USER FU
805: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
806: AND PREL.PARTY_ID = FU.CUSTOMER_ID
807: AND FU.USER_ID = p_approver_user_id
808: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 818: FROM FND_USER

814: i NUMBER;
815:
816: CURSOR FIND_DUMMY_USER IS
817: SELECT USER_ID
818: FROM FND_USER
819: WHERE USER_NAME = FND_PROFILE.VALUE('JTF_PRIMARY_USER');
820:
821: BEGIN
822:

Line 963: JTF_UM_USERTYPE_REG UTREG, FND_USER FU

959: PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
960: 'USERTYPE' ENTITY_SOURCE, UT.USERTYPE_SHORTNAME ENTITY_NAME,
961: UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
962: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
963: JTF_UM_USERTYPE_REG UTREG, FND_USER FU
964: WHERE UTREG.STATUS_CODE = 'PENDING'
965: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
966: AND UT.APPROVAL_ID = AP.APPROVAL_ID
967: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 980: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG

976: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
977: PARTY.PARTY_ID PARTY_ID, 'ENROLLMENT' ENTITY_SOURCE,
978: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
979: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
980: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG
981: WHERE SUBREG.STATUS_CODE = 'PENDING'
982: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
983: AND SUB.APPROVAL_ID = AP.APPROVAL_ID
984: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 1006: FND_USER FU

1002: FROM JTF_UM_USERTYPES_VL UT,
1003: JTF_UM_APPROVALS_B AP,
1004: HZ_PARTIES PARTY,
1005: JTF_UM_USERTYPE_REG UTREG,
1006: FND_USER FU
1007: WHERE UTREG.STATUS_CODE = 'PENDING'
1008: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
1009: AND UT.APPROVAL_ID = AP.APPROVAL_ID
1010: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 1023: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG

1019: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
1020: PARTY.PARTY_ID PARTY_ID, 'ENROLLMENT' ENTITY_SOURCE,
1021: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
1022: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
1023: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG
1024: WHERE SUBREG.STATUS_CODE = 'PENDING'
1025: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
1026: AND SUB.APPROVAL_ID = AP.APPROVAL_ID
1027: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 1047: JTF_UM_USERTYPE_REG UTREG, FND_USER FU

1043: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
1044: PARTY.PARTY_ID PARTY_ID, 'USERTYPE' ENTITY_SOURCE,
1045: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
1046: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
1047: JTF_UM_USERTYPE_REG UTREG, FND_USER FU
1048: WHERE UTREG.STATUS_CODE = 'PENDING'
1049: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
1050: AND UT.APPROVAL_ID = AP.APPROVAL_ID
1051: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 1064: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG

1060: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
1061: PARTY.PARTY_ID PARTY_ID, 'ENROLLMENT' ENTITY_SOURCE,
1062: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
1063: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
1064: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG
1065: WHERE SUBREG.STATUS_CODE = 'PENDING'
1066: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
1067: AND SUB.APPROVAL_ID = AP.APPROVAL_ID
1068: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 1088: JTF_UM_USERTYPE_REG UTREG, FND_USER FU

1084: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
1085: PARTY.PARTY_ID PARTY_ID, 'USERTYPE' ENTITY_SOURCE,
1086: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
1087: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
1088: JTF_UM_USERTYPE_REG UTREG, FND_USER FU
1089: WHERE UTREG.STATUS_CODE = 'PENDING'
1090: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
1091: AND UT.APPROVAL_ID = AP.APPROVAL_ID
1092: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 1105: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG

1101: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
1102: PARTY.PARTY_ID PARTY_ID, 'ENROLLMENT' ENTITY_SOURCE,
1103: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
1104: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
1105: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG
1106: WHERE SUBREG.STATUS_CODE = 'PENDING'
1107: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
1108: AND SUB.APPROVAL_ID = AP.APPROVAL_ID
1109: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 1128: JTF_UM_USERTYPE_REG UTREG, FND_USER FU

1124: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
1125: PARTY.PARTY_ID PARTY_ID, 'USERTYPE' ENTITY_SOURCE,
1126: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
1127: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
1128: JTF_UM_USERTYPE_REG UTREG, FND_USER FU
1129: WHERE UTREG.STATUS_CODE = 'PENDING'
1130: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
1131: AND UT.APPROVAL_ID = AP.APPROVAL_ID
1132: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 1145: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG

1141: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
1142: PARTY.PARTY_ID PARTY_ID, 'ENROLLMENT' ENTITY_SOURCE,
1143: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
1144: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
1145: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG
1146: WHERE SUBREG.STATUS_CODE = 'PENDING'
1147: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
1148: AND SUB.APPROVAL_ID = AP.APPROVAL_ID
1149: AND AP.USE_PENDING_REQ_FLAG = 'Y'