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

Line 725: hz_relationships where subject_id = c_party_id

721: l_object_version_number NUMBER;
722: l_party_object_version_number NUMBER;
723:
724: cursor C_REFERENCE_FOR is select relationship_id from
725: hz_relationships where subject_id = c_party_id
726: and relationship_code = 'REFERENCE_FOR'
727: and subject_table_name = 'HZ_PARTIES'
728: AND object_table_name = 'HZ_PARTIES'
729: AND directional_flag = 'F';

Line 734: hz_relationships where subject_id = c_party_id

730: x_party_last_update_date date;
731: X_PARTY_REL_LAST_UPDATE_DATE date;
732:
733: cursor C_PARTNER_OF is select relationship_id from
734: hz_relationships where subject_id = c_party_id
735: and relationship_code = 'PARTNER_OF'
736: and subject_table_name = 'HZ_PARTIES'
737: and object_table_name = 'HZ_PARTIES'
738: and directional_flag = 'F';

Line 741: hz_relationships where subject_id = c_party_id

737: and object_table_name = 'HZ_PARTIES'
738: and directional_flag = 'F';
739:
740: cursor C_COMPETITOR_OF is select relationship_id from
741: hz_relationships where subject_id = c_party_id
742: and relationship_code = 'COMPETITOR_OF'
743: and subject_table_name = 'HZ_PARTIES'
744: and object_table_name = 'HZ_PARTIES'
745: and directional_flag = 'F';

Line 1118: from hz_relationships where relationship_id = x_party_rel_id;

1114: select last_update_date into x_party_last_update_date
1115: from hz_parties where party_id = c_party_id;*/
1116:
1117: select object_version_number into l_object_version_number
1118: from hz_relationships where relationship_id = x_party_rel_id;
1119:
1120: select object_version_number into l_party_object_version_number
1121: from hz_parties where party_id = c_party_id;
1122:

Line 1203: from hz_relationships where relationship_id = x_party_rel_id;

1199: select last_update_date into x_party_last_update_date
1200: from hz_parties where party_id = c_party_id;*/
1201:
1202: select object_version_number into l_object_version_number
1203: from hz_relationships where relationship_id = x_party_rel_id;
1204:
1205: select object_version_number into l_party_object_version_number
1206: from hz_parties where party_id = c_party_id;
1207:

Line 1290: from hz_relationships where relationship_id = x_party_rel_id;

1286: select last_update_date into x_party_last_update_date
1287: from hz_parties where party_id = c_party_id;*/
1288:
1289: select object_version_number into l_object_version_number
1290: from hz_relationships where relationship_id = x_party_rel_id;
1291:
1292: select object_version_number into l_party_object_version_number
1293: from hz_parties where party_id = c_party_id;
1294: