APPS.JTF_UM_APPROVAL_REQUESTS_PVT dependencies on HZ_RELATIONSHIPS

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

73: AND FU2.USER_ID (+) = SUBREG.APPROVER_USER_ID
74: ) sys_requests ';
75: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
76: CURSOR GET_COMPANY_NAME IS
77: SELECT PARTY.PARTY_NAME FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
78: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
79: AND PREL.PARTY_ID = l_party_id
80: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
81: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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 185: HZ_RELATIONSHIPS PREL, JTF_UM_SUBSCRIPTION_REG SUBREG,

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

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 336: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL

332: ) owner_requests ';
333: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
334: CURSOR GET_COMPANY_NAME IS
335: SELECT PARTY.PARTY_NAME
336: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
337: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
338: AND PREL.PARTY_ID = l_party_id
339: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
340: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'