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 794: hz_relationships where subject_id = c_party_id

790: l_object_version_number NUMBER;
791: l_party_object_version_number NUMBER;
792:
793: cursor C_REFERENCE_FOR is select relationship_id from
794: hz_relationships where subject_id = c_party_id
795: and relationship_code = 'REFERENCE_FOR'
796: and subject_table_name = 'HZ_PARTIES'
797: AND object_table_name = 'HZ_PARTIES'
798: AND directional_flag = 'F';

Line 803: hz_relationships where subject_id = c_party_id

799: x_party_last_update_date date;
800: X_PARTY_REL_LAST_UPDATE_DATE date;
801:
802: cursor C_PARTNER_OF is select relationship_id from
803: hz_relationships where subject_id = c_party_id
804: and relationship_code = 'PARTNER_OF'
805: and subject_table_name = 'HZ_PARTIES'
806: and object_table_name = 'HZ_PARTIES'
807: and directional_flag = 'F';

Line 810: hz_relationships where subject_id = c_party_id

806: and object_table_name = 'HZ_PARTIES'
807: and directional_flag = 'F';
808:
809: cursor C_COMPETITOR_OF is select relationship_id from
810: hz_relationships where subject_id = c_party_id
811: and relationship_code = 'COMPETITOR_OF'
812: and subject_table_name = 'HZ_PARTIES'
813: and object_table_name = 'HZ_PARTIES'
814: and directional_flag = 'F';

Line 1187: from hz_relationships where relationship_id = x_party_rel_id;

1183: select last_update_date into x_party_last_update_date
1184: from hz_parties where party_id = c_party_id;*/
1185:
1186: select object_version_number into l_object_version_number
1187: from hz_relationships where relationship_id = x_party_rel_id;
1188:
1189: select object_version_number into l_party_object_version_number
1190: from hz_parties where party_id = c_party_id;
1191:

Line 1272: from hz_relationships where relationship_id = x_party_rel_id;

1268: select last_update_date into x_party_last_update_date
1269: from hz_parties where party_id = c_party_id;*/
1270:
1271: select object_version_number into l_object_version_number
1272: from hz_relationships where relationship_id = x_party_rel_id;
1273:
1274: select object_version_number into l_party_object_version_number
1275: from hz_parties where party_id = c_party_id;
1276:

Line 1359: from hz_relationships where relationship_id = x_party_rel_id;

1355: select last_update_date into x_party_last_update_date
1356: from hz_parties where party_id = c_party_id;*/
1357:
1358: select object_version_number into l_object_version_number
1359: from hz_relationships where relationship_id = x_party_rel_id;
1360:
1361: select object_version_number into l_party_object_version_number
1362: from hz_parties where party_id = c_party_id;
1363: