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.CSC_SERVICE_KEY_PVT dependencies on HZ_PARTIES

Line 150: WHERE owner_party_source_table = 'HZ_PARTIES'

146: -- Instance Name
147: CURSOR instance_name_cur IS
148: SELECT owner_party_id, owner_party_account_id, instance_id
149: FROM csi_item_instances
150: WHERE owner_party_source_table = 'HZ_PARTIES'
151: AND instance_description IS NOT NULL
152: AND instance_description = l_skey_value;
153:
154: -- Instance Number

Line 158: WHERE owner_party_source_table = 'HZ_PARTIES'

154: -- Instance Number
155: CURSOR instance_num_cur IS
156: SELECT owner_party_id, owner_party_account_id, instance_id
157: FROM csi_item_instances
158: WHERE owner_party_source_table = 'HZ_PARTIES'
159: AND instance_number IS NOT NULL
160: AND instance_number = l_skey_value;
161:
162: --SSN

Line 165: FROM hz_parties

161:
162: --SSN
163: CURSOR SSN_cur IS
164: SELECT party_id
165: FROM hz_parties
166: WHERE jgzz_fiscal_code = l_skey_value;
167:
168:
169: BEGIN