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 HZ_PARTIES

Line 43: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

39: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
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

Line 62: HZ_PARTIES PARTY,

58: 'ENROLLMENT' ENTITY_SOURCE, SUB.SUBSCRIPTION_NAME ENTITY_NAME,
59: SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
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

Line 96: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

92: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
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

Line 113: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

109: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
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

Line 146: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

142: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
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

Line 164: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

160: REG_LAST_UPDATE_DATE, FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE
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

Line 198: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

194: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
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

Line 215: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

211: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
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

Line 249: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

245: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
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

Line 266: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

262: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
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

Line 300: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

296: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
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

Line 317: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

313: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
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

Line 336: l_party_id HZ_PARTIES.PARTY_ID%TYPE;

332: ) sys_requests order by sys_requests.APPROVER
333:
334: ) all_requests where rownum < l_rownum;
335:
336: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
337:
338: CURSOR GET_COMPANY_NAME IS
339:
340: SELECT PARTY.PARTY_NAME FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL

Line 340: SELECT PARTY.PARTY_NAME FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL

336: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
337:
338: CURSOR GET_COMPANY_NAME IS
339:
340: SELECT PARTY.PARTY_NAME FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
341: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
342: AND PREL.PARTY_ID = l_party_id
343: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
344: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 343: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

339:
340: SELECT PARTY.PARTY_NAME FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
341: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
342: AND PREL.PARTY_ID = l_party_id
343: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
344: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
345: AND PREL.START_DATE < SYSDATE
346: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
347: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF');

Line 344: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

340: SELECT PARTY.PARTY_NAME FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
341: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
342: AND PREL.PARTY_ID = l_party_id
343: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
344: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
345: AND PREL.START_DATE < SYSDATE
346: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
347: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF');
348:

Line 350: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;

346: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
347: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF');
348:
349:
350: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
351:
352: i NUMBER := 1;
353:
354: BEGIN

Line 529: l_company_id HZ_PARTIES.PARTY_ID%TYPE;

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
533:

Line 530: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;

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
533:
534: SELECT REG_ID, REG_LAST_UPDATE_DATE, USER_NAME, ENTITY_SOURCE, ENTITY_NAME,

Line 550: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

546: AND AP.USE_PENDING_REQ_FLAG = 'Y'
547: AND UTREG.USER_ID = FU.USER_ID
548: AND FU.CUSTOMER_ID = PREL.PARTY_ID
549: AND PREL.OBJECT_ID = l_company_id
550: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
551: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
552: AND PREL.START_DATE < SYSDATE
553: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
554: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')

Line 551: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

547: AND UTREG.USER_ID = FU.USER_ID
548: AND FU.CUSTOMER_ID = PREL.PARTY_ID
549: AND PREL.OBJECT_ID = l_company_id
550: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
551: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
552: AND PREL.START_DATE < SYSDATE
553: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
554: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')
555: AND nvl (UTREG.EFFECTIVE_END_DATE, sysdate + 1) > sysdate

Line 573: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

569: AND AP.USE_PENDING_REQ_FLAG = 'Y'
570: AND SUBREG.USER_ID = FU.USER_ID
571: AND FU.CUSTOMER_ID = PREL.PARTY_ID
572: AND PREL.OBJECT_ID = l_company_id
573: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
574: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
575: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')
576: AND PREL.START_DATE < SYSDATE
577: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE

Line 574: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

570: AND SUBREG.USER_ID = FU.USER_ID
571: AND FU.CUSTOMER_ID = PREL.PARTY_ID
572: AND PREL.OBJECT_ID = l_company_id
573: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
574: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
575: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')
576: AND PREL.START_DATE < SYSDATE
577: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
578: AND (SUBREG.EFFECTIVE_END_DATE IS null OR SUBREG.EFFECTIVE_END_DATE > sysdate)

Line 603: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

599: AND AP.USE_PENDING_REQ_FLAG = 'Y'
600: AND UTREG.USER_ID = FU.USER_ID
601: AND FU.CUSTOMER_ID = PREL.PARTY_ID
602: AND PREL.OBJECT_ID = l_company_id
603: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
604: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
605: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')
606: AND PREL.START_DATE < SYSDATE
607: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE

Line 604: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

600: AND UTREG.USER_ID = FU.USER_ID
601: AND FU.CUSTOMER_ID = PREL.PARTY_ID
602: AND PREL.OBJECT_ID = l_company_id
603: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
604: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
605: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')
606: AND PREL.START_DATE < SYSDATE
607: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
608: AND nvl (UTREG.EFFECTIVE_END_DATE, sysdate + 1) > sysdate

Line 626: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

622: AND AP.USE_PENDING_REQ_FLAG = 'Y'
623: AND SUBREG.USER_ID = FU.USER_ID
624: AND FU.CUSTOMER_ID = PREL.PARTY_ID
625: AND PREL.OBJECT_ID = l_company_id
626: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
627: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
628: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')
629: AND PREL.START_DATE < SYSDATE
630: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE

Line 627: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

623: AND SUBREG.USER_ID = FU.USER_ID
624: AND FU.CUSTOMER_ID = PREL.PARTY_ID
625: AND PREL.OBJECT_ID = l_company_id
626: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
627: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
628: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')
629: AND PREL.START_DATE < SYSDATE
630: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
631: AND (SUBREG.EFFECTIVE_END_DATE IS null OR SUBREG.EFFECTIVE_END_DATE > sysdate)

Line 656: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

652: AND AP.USE_PENDING_REQ_FLAG = 'Y'
653: AND UTREG.USER_ID = FU.USER_ID
654: AND FU.CUSTOMER_ID = PREL.PARTY_ID
655: AND PREL.OBJECT_ID = l_company_id
656: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
657: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
658: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')
659: AND PREL.START_DATE < SYSDATE
660: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE

Line 657: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

653: AND UTREG.USER_ID = FU.USER_ID
654: AND FU.CUSTOMER_ID = PREL.PARTY_ID
655: AND PREL.OBJECT_ID = l_company_id
656: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
657: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
658: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')
659: AND PREL.START_DATE < SYSDATE
660: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
661: AND nvl (UTREG.EFFECTIVE_END_DATE, sysdate + 1) > sysdate

Line 679: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

675: AND AP.USE_PENDING_REQ_FLAG = 'Y'
676: AND SUBREG.USER_ID = FU.USER_ID
677: AND FU.CUSTOMER_ID = PREL.PARTY_ID
678: AND PREL.OBJECT_ID = l_company_id
679: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
680: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
681: AND PREL.START_DATE < SYSDATE
682: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
683: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')

Line 680: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

676: AND SUBREG.USER_ID = FU.USER_ID
677: AND FU.CUSTOMER_ID = PREL.PARTY_ID
678: AND PREL.OBJECT_ID = l_company_id
679: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
680: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
681: AND PREL.START_DATE < SYSDATE
682: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
683: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')
684: AND (SUBREG.EFFECTIVE_END_DATE IS null OR SUBREG.EFFECTIVE_END_DATE > sysdate)

Line 711: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

707: AND AP.USE_PENDING_REQ_FLAG = 'Y'
708: AND UTREG.USER_ID = FU.USER_ID
709: AND FU.CUSTOMER_ID = PREL.PARTY_ID
710: AND PREL.OBJECT_ID = l_company_id
711: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
712: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
713: AND PREL.START_DATE < SYSDATE
714: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
715: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')

Line 712: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

708: AND UTREG.USER_ID = FU.USER_ID
709: AND FU.CUSTOMER_ID = PREL.PARTY_ID
710: AND PREL.OBJECT_ID = l_company_id
711: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
712: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
713: AND PREL.START_DATE < SYSDATE
714: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
715: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')
716: AND nvl (UTREG.EFFECTIVE_END_DATE, sysdate + 1) > sysdate

Line 734: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

730: AND AP.USE_PENDING_REQ_FLAG = 'Y'
731: AND SUBREG.USER_ID = FU.USER_ID
732: AND FU.CUSTOMER_ID = PREL.PARTY_ID
733: AND PREL.OBJECT_ID = l_company_id
734: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
735: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
736: AND PREL.START_DATE < SYSDATE
737: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
738: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')

Line 735: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

731: AND SUBREG.USER_ID = FU.USER_ID
732: AND FU.CUSTOMER_ID = PREL.PARTY_ID
733: AND PREL.OBJECT_ID = l_company_id
734: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
735: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
736: AND PREL.START_DATE < SYSDATE
737: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
738: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')
739: AND (SUBREG.EFFECTIVE_END_DATE IS null OR SUBREG.EFFECTIVE_END_DATE > sysdate)

Line 766: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

762: AND AP.USE_PENDING_REQ_FLAG = 'Y'
763: AND UTREG.USER_ID = FU.USER_ID
764: AND FU.CUSTOMER_ID = PREL.PARTY_ID
765: AND PREL.OBJECT_ID = l_company_id
766: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
767: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
768: AND PREL.START_DATE < SYSDATE
769: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
770: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')

Line 767: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

763: AND UTREG.USER_ID = FU.USER_ID
764: AND FU.CUSTOMER_ID = PREL.PARTY_ID
765: AND PREL.OBJECT_ID = l_company_id
766: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
767: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
768: AND PREL.START_DATE < SYSDATE
769: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
770: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')
771: AND nvl (UTREG.EFFECTIVE_END_DATE, sysdate + 1) > sysdate

Line 789: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

785: AND AP.USE_PENDING_REQ_FLAG = 'Y'
786: AND SUBREG.USER_ID = FU.USER_ID
787: AND FU.CUSTOMER_ID = PREL.PARTY_ID
788: AND PREL.OBJECT_ID = l_company_id
789: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
790: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
791: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')
792: AND PREL.START_DATE < SYSDATE
793: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE

Line 790: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

786: AND SUBREG.USER_ID = FU.USER_ID
787: AND FU.CUSTOMER_ID = PREL.PARTY_ID
788: AND PREL.OBJECT_ID = l_company_id
789: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
790: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
791: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')
792: AND PREL.START_DATE < SYSDATE
793: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
794: AND (SUBREG.EFFECTIVE_END_DATE IS null OR SUBREG.EFFECTIVE_END_DATE > sysdate)

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 808: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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'
809: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
810: AND PREL.START_DATE < SYSDATE
811: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
812: AND PREL.RELATIONSHIP_CODE = 'EMPLOYEE_OF';

Line 809: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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'
809: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
810: AND PREL.START_DATE < SYSDATE
811: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
812: AND PREL.RELATIONSHIP_CODE = 'EMPLOYEE_OF';
813:

Line 962: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

958: REG_LAST_UPDATE_DATE, FU.USER_NAME USER_NAME,
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

Line 979: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

975: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
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

Line 1004: HZ_PARTIES PARTY,

1000: PARTY.PARTY_ID PARTY_ID, 'USERTYPE' ENTITY_SOURCE,
1001: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
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

Line 1022: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

1018: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
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

Line 1046: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

1042: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
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

Line 1063: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

1059: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
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

Line 1087: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

1083: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
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

Line 1104: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

1100: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
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

Line 1127: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

1123: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
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

Line 1144: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

1140: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
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

Line 1159: l_party_id HZ_PARTIES.PARTY_ID%TYPE;

1155: AND nvl (UTREG.EFFECTIVE_END_DATE, sysdate + 1) > sysdate
1156: AND SUBREG.APPROVER_USER_ID = p_approver_user_id
1157: ) owner_requests where rownum < l_rownum order by REG_ID;
1158:
1159: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
1160:
1161: CURSOR GET_COMPANY_NAME IS
1162:
1163: SELECT PARTY.PARTY_NAME

Line 1164: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL

1160:
1161: CURSOR GET_COMPANY_NAME IS
1162:
1163: SELECT PARTY.PARTY_NAME
1164: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
1165: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
1166: AND PREL.PARTY_ID = l_party_id
1167: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1168: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 1167: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1163: SELECT PARTY.PARTY_NAME
1164: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
1165: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
1166: AND PREL.PARTY_ID = l_party_id
1167: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1168: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1169: AND PREL.START_DATE < SYSDATE
1170: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
1171: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF');

Line 1168: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1164: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
1165: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
1166: AND PREL.PARTY_ID = l_party_id
1167: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1168: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1169: AND PREL.START_DATE < SYSDATE
1170: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
1171: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF');
1172:

Line 1174: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;

1170: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
1171: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF');
1172:
1173:
1174: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
1175: i NUMBER := 1;
1176:
1177: BEGIN
1178: