APPS.OKL_PARTY_MERGE_PUB dependencies on HZ_CUST_ACCOUNTS

Line 86: FROM HZ_CUST_ACCOUNTS_ALL HCA

82: WHERE party_site_id = p_old_party_site_id;
83:
84: --Obtain the Party of the given Customer Account
85: SELECT PARTY_ID INTO p_party_site_rec.party_id
86: FROM HZ_CUST_ACCOUNTS_ALL HCA
87: WHERE HCA.CUST_ACCOUNT_ID = p_cust_acct_id;
88:
89: p_party_site_rec.identifying_address_flag := 'N';
90: p_party_site_rec.status := 'A';

Line 349: FROM HZ_CUST_ACCOUNTS_ALL HCA1

345: ret_val BOOLEAN DEFAULT FALSE;
346: --Cursor to check if Parties of both the Customer Accounts is same.
347: CURSOR same_party_csr(l_orig_cust_acct_id NUMBER, l_new_cust_acct_id NUMBER) IS
348: SELECT 1
349: FROM HZ_CUST_ACCOUNTS_ALL HCA1
350: , HZ_CUST_ACCOUNTS_ALL HCA2
351: WHERE HCA1.CUST_ACCOUNT_ID = l_orig_cust_acct_id
352: AND HCA2.CUST_ACCOUNT_ID = l_new_cust_acct_id
353: AND HCA1.PARTY_ID = HCA2.PARTY_ID;

Line 350: , HZ_CUST_ACCOUNTS_ALL HCA2

346: --Cursor to check if Parties of both the Customer Accounts is same.
347: CURSOR same_party_csr(l_orig_cust_acct_id NUMBER, l_new_cust_acct_id NUMBER) IS
348: SELECT 1
349: FROM HZ_CUST_ACCOUNTS_ALL HCA1
350: , HZ_CUST_ACCOUNTS_ALL HCA2
351: WHERE HCA1.CUST_ACCOUNT_ID = l_orig_cust_acct_id
352: AND HCA2.CUST_ACCOUNT_ID = l_new_cust_acct_id
353: AND HCA1.PARTY_ID = HCA2.PARTY_ID;
354: same_party_val VARCHAR2(1);

Line 395: , HZ_CUST_ACCOUNTS_ALL HCA

391: new_party_site_id NUMBER;
392: CURSOR new_party_site_csr(l_old_party_site_id NUMBER, l_new_cust_acct_id NUMBER) IS
393: SELECT HPSN.PARTY_SITE_ID
394: FROM HZ_PARTY_SITES HPS
395: , HZ_CUST_ACCOUNTS_ALL HCA
396: , HZ_PARTY_SITES HPSN
397: WHERE HPS.PARTY_SITE_ID = l_old_party_site_id
398: AND HCA.CUST_ACCOUNT_ID = l_new_cust_acct_id
399: AND HCA.PARTY_ID = HPSN.PARTY_ID

Line 432: , HZ_CUST_ACCOUNTS_ALL HCA

428: new_party_site_use_id NUMBER;
429: CURSOR new_party_site_use_csr(l_old_party_site_use_id NUMBER, l_new_cust_acct_id NUMBER) IS
430: SELECT HPSUN.PARTY_SITE_USE_ID
431: FROM HZ_PARTY_SITES HPS
432: , HZ_CUST_ACCOUNTS_ALL HCA
433: , HZ_PARTY_SITES HPSN
434: , HZ_PARTY_SITE_USES HPSU
435: , HZ_PARTY_SITE_USES HPSUN
436: WHERE HPSU.PARTY_SITE_USE_ID = l_old_party_site_use_id

Line 3509: FROM HZ_CUST_ACCOUNTS_ALL

3505: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
3506: IF(NOT CHECK_IF_SAME_PARTY(NUM_COL1_ORIG_LIST(I), NUM_COL1_NEW_LIST(I)))
3507: THEN
3508: SELECT PARTY_ID INTO PROSPECT_ID_LIST(I)
3509: FROM HZ_CUST_ACCOUNTS_ALL
3510: WHERE CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I);
3511: --check if there exists a party site with same location id under new party
3512: SELECT PROSPECT_ID
3513: , PROSPECT_ADDRESS_ID

Line 4039: FROM HZ_CUST_ACCOUNTS_ALL

4035: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
4036: IF(NOT CHECK_IF_SAME_PARTY(NUM_COL1_ORIG_LIST(I), NUM_COL1_NEW_LIST(I)))
4037: THEN
4038: SELECT PARTY_ID INTO PROSPECT_ID_LIST(I)
4039: FROM HZ_CUST_ACCOUNTS_ALL
4040: WHERE CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I);
4041:
4042: --check if there exists a party site with same location id under new party
4043: SELECT PROSPECT_ID

Line 6300: CURSOR get_new_party(cp_cust_acct_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE)

6296: AND EXISTS( SELECT 1
6297: FROM OKL_K_HEADERS KHR
6298: WHERE yt.DNZ_CHR_ID = KHR.ID);
6299:
6300: CURSOR get_new_party(cp_cust_acct_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE)
6301: IS
6302: SELECT PARTY_ID
6303: FROM HZ_CUST_ACCOUNTS
6304: WHERE CUST_ACCOUNT_ID = cp_cust_acct_id;

Line 6303: FROM HZ_CUST_ACCOUNTS

6299:
6300: CURSOR get_new_party(cp_cust_acct_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE)
6301: IS
6302: SELECT PARTY_ID
6303: FROM HZ_CUST_ACCOUNTS
6304: WHERE CUST_ACCOUNT_ID = cp_cust_acct_id;
6305:
6306: l_last_fetch BOOLEAN := FALSE;
6307: l_count NUMBER;