APPS.ISC_DBI_ACCT_MERGE_PKG dependencies on HZ_CUST_ACCOUNTS

Line 37: l_new_party_id HZ_CUST_ACCOUNTS.PARTY_ID%TYPE;

33: NUM_COL2_ORIG_LIST SHIP_TO_ORG_ID_LIST_TYPE;
34: NUM_COL2_NEW_LIST SHIP_TO_ORG_ID_LIST_TYPE;
35:
36: l_profile_val VARCHAR2(30);
37: l_new_party_id HZ_CUST_ACCOUNTS.PARTY_ID%TYPE;
38: CURSOR merged_records IS
39: SELECT distinct CUSTOMER_MERGE_HEADER_ID
40: ,LINE_ID
41: ,SOLD_TO_ORG_ID

Line 80: from hz_cust_accounts

76: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
77: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
78:
79: select party_id into l_new_party_id
80: from hz_cust_accounts
81: where cust_account_id = NUM_COL1_NEW_LIST(I);
82: NUM_COL0_NEW_LIST(I) := l_new_party_id;
83:
84: END LOOP;

Line 175: l_new_party_id HZ_CUST_ACCOUNTS.PARTY_ID%TYPE;

171: NUM_COL2_ORIG_LIST SHIP_TO_ORG_ID_LIST_TYPE;
172: NUM_COL2_NEW_LIST SHIP_TO_ORG_ID_LIST_TYPE;
173:
174: l_profile_val VARCHAR2(30);
175: l_new_party_id HZ_CUST_ACCOUNTS.PARTY_ID%TYPE;
176: CURSOR merged_records IS
177: SELECT distinct CUSTOMER_MERGE_HEADER_ID
178: ,LINE_ID
179: ,SOLD_TO_ORG_ID

Line 218: from hz_cust_accounts

214: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
215: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
216:
217: select party_id into l_new_party_id
218: from hz_cust_accounts
219: where cust_account_id = NUM_COL1_NEW_LIST(I);
220: NUM_COL0_NEW_LIST(I) := l_new_party_id;
221:
222: END LOOP;

Line 313: l_new_party_id HZ_CUST_ACCOUNTS.PARTY_ID%TYPE;

309: NUM_COL2_ORIG_LIST SHIP_TO_ORG_ID_LIST_TYPE;
310: NUM_COL2_NEW_LIST SHIP_TO_ORG_ID_LIST_TYPE;
311:
312: l_profile_val VARCHAR2(30);
313: l_new_party_id HZ_CUST_ACCOUNTS.PARTY_ID%TYPE;
314: CURSOR merged_records IS
315: SELECT distinct CUSTOMER_MERGE_HEADER_ID
316: ,LINE_ID
317: ,SOLD_TO_ORG_ID

Line 356: from hz_cust_accounts

352: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
353: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
354:
355: select party_id into l_new_party_id
356: from hz_cust_accounts
357: where cust_account_id = NUM_COL1_NEW_LIST(I);
358: NUM_COL0_NEW_LIST(I) := l_new_party_id;
359:
360: END LOOP;