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 1479: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f

1475: AND NVL(SUBREG.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE
1476: );
1477: /*
1478: CURSOR PENDING_USERS IS SELECT f.user_name, p.party_name, f.email_address
1479: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f
1480: WHERE UT.USERTYPE_KEY = l_old_ut_key
1481: AND UT.USERTYPE_ID = UTREG.USERTYPE_ID
1482: AND UTREG.user_id = f.user_Id
1483: AND UTREG.STATUS_CODE = 'PENDING'

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

1485: AND NVL(utreg.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE;
1486: */
1487: CURSOR PENDING_USERS IS
1488: SELECT f.user_name, p.party_name, f.email_address
1489: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f
1490: WHERE UT.USERTYPE_KEY = 'PRIMARYUSER'
1491: AND UT.USERTYPE_ID = UTREG.USERTYPE_ID
1492: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1493: AND R.object_table_name = 'HZ_PARTIES'

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

1544: -- this code can result in exceptions hence enclosing in a seperate block
1545: -- as the following block is used for logging
1546: BEGIN
1547: select f.user_name, p.party_name, f.email_address into l_user_name, l_org_name, l_email
1548: from hz_parties p, hz_relationships r, fnd_user f
1549: where
1550: p.party_id = r.object_id and r.party_id = f.customer_id
1551: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1552: AND R.object_table_name = 'HZ_PARTIES'