APPS.CZ_IMP_AC_MAIN dependencies on CZ_IMP_CONTACT

Line 12: SELECT DELETED_FLAG, ROWID FROM CZ_IMP_CONTACT WHERE REC_STATUS IS NULL

8: ) IS
9: BEGIN
10: DECLARE
11: CURSOR c_imp_contact IS
12: SELECT DELETED_FLAG, ROWID FROM CZ_IMP_CONTACT WHERE REC_STATUS IS NULL
13: AND RUN_ID = inRUN_ID;
14: /* Internal vars */
15: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
16: nErrorCount PLS_INTEGER:=0; /*Error index */

Line 36: UPDATE CZ_IMP_CONTACT

32:
33: EXIT WHEN(NOT x_imp_contact_f Or nFailed >= Max_Err);
34: IF (p_imp_contact.DELETED_FLAG IS NULL) THEN
35: BEGIN
36: UPDATE CZ_IMP_CONTACT
37: SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG)
38: WHERE ROWID = p_imp_contact.ROWID;
39: nCOmmitCount:=nCommitCount+1;
40: /* COMMIT if the buffer size is reached */

Line 1095: FROM cz_imp_contact

1091:
1092: DECLARE
1093: CURSOR c_xfr_run_result IS
1094: SELECT DISPOSITION,REC_STATUS,COUNT(*)
1095: FROM cz_imp_contact
1096: WHERE RUN_ID = inRUN_ID
1097: GROUP BY DISPOSITION,REC_STATUS;
1098:
1099: ins_disposition cz_xfr_run_results.disposition%TYPE;