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_PARTIES

Line 796: and subject_table_name = 'HZ_PARTIES'

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';
799: x_party_last_update_date date;
800: X_PARTY_REL_LAST_UPDATE_DATE date;

Line 797: AND object_table_name = 'HZ_PARTIES'

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';
799: x_party_last_update_date date;
800: X_PARTY_REL_LAST_UPDATE_DATE date;
801:

Line 805: and subject_table_name = 'HZ_PARTIES'

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';
808:
809: cursor C_COMPETITOR_OF is select relationship_id from

Line 806: and object_table_name = 'HZ_PARTIES'

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';
808:
809: cursor C_COMPETITOR_OF is select relationship_id from
810: hz_relationships where subject_id = c_party_id

Line 812: and subject_table_name = 'HZ_PARTIES'

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';
815:
816: begin

Line 813: and object_table_name = 'HZ_PARTIES'

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';
815:
816: begin
817: /*

Line 1184: from hz_parties where party_id = c_party_id;*/

1180: /* select last_update_date into x_party_rel_last_update_date
1181: from hz_party_relationships where party_relationship_id = x_party_rel_id;
1182:
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:

Line 1190: from hz_parties where party_id = c_party_id;

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:
1192: prel_rec.relationship_id := x_party_rel_id;
1193: if C_Reference_Use_Flag = 'N' then
1194: prel_rec.end_date := sysdate;

Line 1269: from hz_parties where party_id = c_party_id;*/

1265: /* select last_update_date into x_party_rel_last_update_date
1266: from hz_party_relationships where party_relationship_id = x_party_rel_id;
1267:
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:

Line 1275: from hz_parties where party_id = c_party_id;

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:
1277: prel_rec.relationship_id := x_party_rel_id;
1278: if C_Third_Party_Flag = 'N' then
1279: prel_rec.end_date := sysdate;

Line 1356: from hz_parties where party_id = c_party_id;*/

1352: /*select last_update_date,object_version_number into x_party_rel_last_update_date,l_object_version_number
1353: from hz_party_relationships where party_relationship_id = x_party_rel_id;
1354:
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:

Line 1362: from hz_parties where party_id = c_party_id;

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:
1364: prel_rec.relationship_id := x_party_rel_id;
1365: if c_competitor_flag = 'N' then
1366: prel_rec.end_date := sysdate;