DBA Data[Home] [Help]

APPS.HZ_PURGE dependencies on HZ_NON_PURGE_CANDIDATES

Line 419: insert into hz_non_purge_candidates(BATCH_ID,CANDIDATE_PARTY_ID,APPL_ID,

415: FETCH appl_trans into app_id, p_id;
416: exit when appl_trans%NOTFOUND;
417: x_sysdate :=x_sysdate+0.00001;
418: --dbms_output.put_line('sysdate='||x_sysdate);
419: insert into hz_non_purge_candidates(BATCH_ID,CANDIDATE_PARTY_ID,APPL_ID,
420: PARTY_NAME,PARTY_NUMBER,ADDRESSES,PHONE_NUMBERS,COUNTRY,CREATION_DATE,
421: LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATED_BY)
422: select to_number(batchid), p_id, app_id, substr(a.party_name,1,250), a.party_number,
423: null, null, null,