APPS.HZ_ACCT_CREATE_PKG dependencies on HZ_RELATIONSHIPS

Line 221: from hz_relationships

217: IS
218: cursor C_REFERENCE_FOR is
219: select relationship_id ,
220: end_date
221: from hz_relationships
222: where subject_id = c_party_id
223: and relationship_code = 'REFERENCE_FOR'
224: and subject_table_name = 'HZ_PARTIES'
225: and object_table_name = 'HZ_PARTIES'

Line 231: from hz_relationships

227:
228: cursor C_PARTNER_OF is
229: select relationship_id ,
230: end_date
231: from hz_relationships
232: where subject_id = c_party_id
233: and relationship_code = 'PARTNER_OF'
234: and subject_table_name = 'HZ_PARTIES'
235: and object_table_name = 'HZ_PARTIES'

Line 241: from hz_relationships

237:
238: cursor C_COMPETITOR_OF is
239: select relationship_id,
240: end_date
241: from hz_relationships
242: where subject_id = c_party_id
243: and relationship_code = 'COMPETITOR_OF'
244: and subject_table_name = 'HZ_PARTIES'
245: and object_table_name = 'HZ_PARTIES'

Line 325: FROM hz_relationships

321: SELECT last_update_date ,
322: object_version_number
323: INTO x_party_rel_last_update_date ,
324: l_party_rel_object_version
325: FROM hz_relationships
326: WHERE relationship_id = x_party_rel_id
327: AND subject_table_name = 'HZ_PARTIES'
328: AND object_table_name = 'HZ_PARTIES'
329: AND directional_flag = 'F';

Line 380: FROM hz_relationships

376: SELECT last_update_date ,
377: object_version_number
378: INTO x_party_rel_last_update_date ,
379: l_party_rel_object_version
380: FROM hz_relationships
381: WHERE relationship_id = x_party_rel_id
382: AND subject_table_name = 'HZ_PARTIES'
383: AND object_table_name = 'HZ_PARTIES'
384: AND directional_flag = 'F';

Line 2088: from hz_relationships

2084: i_internal_party_id number;
2085:
2086: cursor C_REFERENCE_FOR is
2087: select relationship_id
2088: from hz_relationships
2089: where subject_id = c_party_id
2090: and relationship_code = 'REFERENCE_FOR'
2091: and subject_table_name = 'HZ_PARTIES'
2092: and object_table_name = 'HZ_PARTIES'

Line 2097: from hz_relationships

2093: and directional_flag = 'F';
2094:
2095: cursor C_PARTNER_OF is
2096: select relationship_id
2097: from hz_relationships
2098: where subject_id = c_party_id
2099: and relationship_code = 'PARTNER_OF'
2100: and subject_table_name = 'HZ_PARTIES'
2101: and object_table_name = 'HZ_PARTIES'

Line 2106: from hz_relationships

2102: and directional_flag = 'F';
2103:
2104: cursor C_COMPETITOR_OF is
2105: select relationship_id
2106: from hz_relationships
2107: where subject_id = c_party_id
2108: and relationship_code = 'COMPETITOR_OF'
2109: and subject_table_name = 'HZ_PARTIES'
2110: and object_table_name = 'HZ_PARTIES'