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

Line 135: hz_relationships hr

131: hop.organization_name,
132: hop.home_country
133: FROM hz_organization_profiles hop,
134: hz_parties hp,
135: hz_relationships hr
136: WHERE hr.object_id = p_bank_rec.organization_rec.party_rec.party_id
137: AND hr.relationship_type = 'BANK_AND_BRANCH'
138: AND hr.relationship_code = 'HAS_BRANCH'
139: AND hr.object_type = 'ORGANIZATION'

Line 156: FROM hz_relationships hr,

152: CURSOR c_uniquenumberck (
153: p_parent_id NUMBER
154: ) IS
155: SELECT 1
156: FROM hz_relationships hr,
157: hz_organization_profiles hopbb
158: WHERE hr.subject_id = p_parent_id
159: AND hr.relationship_type = 'BANK_AND_BRANCH'
160: AND hr.relationship_code = 'HAS_BRANCH'

Line 178: FROM hz_relationships hr,

174: CURSOR c_uniquenameck (
175: p_parent_id NUMBER
176: ) IS
177: SELECT 1
178: FROM hz_relationships hr,
179: hz_parties hpbb
180: WHERE hr.subject_id = p_parent_id
181: AND hr.relationship_type = 'BANK_AND_BRANCH'
182: AND hr.relationship_code = 'HAS_BRANCH'

Line 1993: FROM hz_relationships hr

1989: CURSOR c_rel IS
1990: SELECT NVL(p_subject_id, hr.subject_id),
1991: NVL(p_object_id, hr.object_id),
1992: hr.object_version_number
1993: FROM hz_relationships hr
1994: WHERE hr.relationship_id = p_relationship_id
1995: AND SYSDATE BETWEEN TRUNC(hr.start_date)
1996: AND NVL(hr.end_date, SYSDATE+1)
1997: AND hr.relationship_type = p_relationship_type