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.AMS_REGISTRANTS_PVT dependencies on HZ_RELATIONSHIPS

Line 184: SELECT subject_id FROM hz_relationships

180: NO_EMAIL_FOUND CONSTANT NUMBER := 10;
181:
182:
183: CURSOR PARTY_REL_EXISTS(id_in in NUMBER) IS
184: SELECT subject_id FROM hz_relationships
185: WHERE relationship_id = id_in
186: AND subject_type = 'PERSON';
187:
188:

Line 413: -- Replaced HZ_PARTY_RELATIONSHIPS with HZ_RELATIONSHIPS

409:
410: -- Cursor for B2B party type
411:
412: -- Fixed bug#4654679
413: -- Replaced HZ_PARTY_RELATIONSHIPS with HZ_RELATIONSHIPS
414: -- Also, relaced PARTY_RELATIONSHIP_TYPE = 'CONTACT_OF'
415: -- with RELATIONSHIP_CODE = 'CONTACT_OF'
416: CURSOR PARTY_REL_EXISTS IS
417: SELECT party_id FROM hz_relationships

Line 417: SELECT party_id FROM hz_relationships

413: -- Replaced HZ_PARTY_RELATIONSHIPS with HZ_RELATIONSHIPS
414: -- Also, relaced PARTY_RELATIONSHIP_TYPE = 'CONTACT_OF'
415: -- with RELATIONSHIP_CODE = 'CONTACT_OF'
416: CURSOR PARTY_REL_EXISTS IS
417: SELECT party_id FROM hz_relationships
418: WHERE object_id = x_org_party_id
419: AND subject_id = x_per_party_id
420: AND relationship_code = 'CONTACT_OF';
421:

Line 2175: hz_relationships rel,

2171: cursor c_cont_email is
2172: select max(per.party_id) from
2173: hz_parties org,
2174: hz_parties per,
2175: hz_relationships rel,
2176: hz_contact_points cpoint
2177: where org.party_id = p_org_party_id
2178: and org.party_type = 'ORGANIZATION'
2179: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 2197: hz_relationships rel,

2193: cursor c_cont_email_phone is
2194: select max(per.party_id) from
2195: hz_parties org,
2196: hz_parties per,
2197: hz_relationships rel,
2198: hz_contact_points cpoint,
2199: hz_contact_points cpoint1
2200: where org.party_id = p_org_party_id
2201: and org.party_type = 'ORGANIZATION'

Line 2227: hz_relationships rel,

2223: cursor c_cont_phone is
2224: select max(per.party_id) from
2225: hz_parties org,
2226: hz_parties per,
2227: hz_relationships rel,
2228: hz_contact_points cpoint
2229: where org.party_id = p_org_party_id
2230: and org.party_type = 'ORGANIZATION'
2231: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 2391: FROM hz_relationships

2387: l_b2b_flag VARCHAR2(1);
2388:
2389: CURSOR c_relationship_det(p_id NUMBER) IS
2390: SELECT object_id, subject_id
2391: FROM hz_relationships
2392: WHERE party_id = p_id
2393: -- dbiswas 10 Jun 2003 fix for bug 2949603
2394: -- AND directional_flag = 'F';
2395: AND subject_Type = 'PERSON'