APPS.OKL_PARTY_MERGE_PUB dependencies on OKL_K_HEADERS

Line 3370: AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS);

3366: , TAB.last_updated_by = arp_standard.profile.user_id
3367: , TAB.last_update_login = arp_standard.profile.last_update_login
3368: WHERE TAB.OBJECT1_ID1 = TO_CHAR(p_from_fk_id)
3369: AND JTOT_OBJECT1_CODE = 'OKL_PARTYSITE'
3370: AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS);
3371: END IF;
3372: l_count := sql%rowcount;
3373: arp_message.set_name('AR','AR_ROWS_UPDATED');
3374: arp_message.set_token('NUM_ROWS',to_char(l_count));

Line 6224: AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS);

6220: , TAB.last_updated_by = arp_standard.profile.user_id
6221: , TAB.last_update_login = arp_standard.profile.last_update_login
6222: WHERE TAB.OBJECT1_ID1 = TO_CHAR(p_from_fk_id)
6223: AND JTOT_OBJECT1_CODE = 'OKL_PARTYSITE'
6224: AND DNZ_CHR_ID IN (SELECT ID FROM OKL_K_HEADERS);
6225: END IF;
6226: l_count := sql%rowcount;
6227: arp_message.set_name('AR','AR_ROWS_UPDATED');
6228: arp_message.set_token('NUM_ROWS',to_char(l_count));

Line 6297: FROM OKL_K_HEADERS KHR

6293: AND m.process_flag = 'N'
6294: AND m.request_id = req_id
6295: AND m.set_number = set_num
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