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 155: FROM hz_relationships hr,

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

Line 177: FROM hz_relationships hr,

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

Line 1981: FROM hz_relationships hr

1977: CURSOR c_rel IS
1978: SELECT NVL(p_subject_id, hr.subject_id),
1979: NVL(p_object_id, hr.object_id),
1980: hr.object_version_number
1981: FROM hz_relationships hr
1982: WHERE hr.relationship_id = p_relationship_id
1983: AND SYSDATE BETWEEN TRUNC(hr.start_date)
1984: AND NVL(hr.end_date, SYSDATE+1)
1985: AND hr.relationship_type = p_relationship_type