APPS.JTF_UM_USERTYPE_CREDENTIALS dependencies on HZ_RELATIONSHIPS

Line 177: FROM hz_relationships HZR,FND_USER FU

173:
174: CURSOR ORG_PARTY_ID
175: IS
176: SELECT FU.CUSTOMER_ID,HZR.SUBJECT_ID,HZR.OBJECT_ID
177: FROM hz_relationships HZR,FND_USER FU
178: WHERE FU.USER_ID = X_USER_ID
179: AND FU.CUSTOMER_ID = HZR.PARTY_ID
180: AND HZR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
181: AND HZR.subject_type = 'PERSON'

Line 1534: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f

1530: AND NVL(SUBREG.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE
1531: );
1532: /*
1533: CURSOR PENDING_USERS IS SELECT f.user_name, p.party_name, f.email_address
1534: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f
1535: WHERE UT.USERTYPE_KEY = l_old_ut_key
1536: AND UT.USERTYPE_ID = UTREG.USERTYPE_ID
1537: AND UTREG.user_id = f.user_Id
1538: AND UTREG.STATUS_CODE = 'PENDING'

Line 1544: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f

1540: AND NVL(utreg.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE;
1541: */
1542: CURSOR PENDING_USERS IS
1543: SELECT f.user_name, p.party_name, f.email_address
1544: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f
1545: WHERE UT.USERTYPE_KEY = 'PRIMARYUSER'
1546: AND UT.USERTYPE_ID = UTREG.USERTYPE_ID
1547: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1548: AND R.object_table_name = 'HZ_PARTIES'

Line 1604: from hz_parties p, hz_relationships r, fnd_user f

1600: -- this code can result in exceptions hence enclosing in a seperate block
1601: -- as the following block is used for logging
1602: BEGIN
1603: select f.user_name, p.party_name, f.email_address into l_user_name, l_org_name, l_email
1604: from hz_parties p, hz_relationships r, fnd_user f
1605: where
1606: p.party_id = r.object_id and r.party_id = f.customer_id
1607: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1608: AND R.object_table_name = 'HZ_PARTIES'