APPS.CZ_IMP_AC_MAIN dependencies on CZ_IMP_ADDRESS_USE

Line 189: SELECT DELETED_FLAG, ROWID FROM CZ_IMP_ADDRESS_USE

185: ) IS
186: BEGIN
187: DECLARE
188: CURSOR c_imp_address_uses IS
189: SELECT DELETED_FLAG, ROWID FROM CZ_IMP_ADDRESS_USE
190: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
191: /* Internal vars */
192: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
193: nErrorCount PLS_INTEGER:=0; /*Error index */

Line 212: UPDATE CZ_IMP_ADDRESS_USE

208: EXIT WHEN(NOT x_imp_address_uses_f Or nFailed >= Max_Err);
209:
210: IF(p_imp_address_uses.DELETED_FLAG IS NULL) THEN
211: BEGIN
212: UPDATE CZ_IMP_ADDRESS_USE
213: SET DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG)
214: WHERE ROWID = p_imp_address_uses.ROWID;
215:
216: nCOmmitCount:=nCommitCount+1;

Line 1289: FROM cz_imp_address_use

1285:
1286: DECLARE
1287: CURSOR c_xfr_run_result IS
1288: SELECT DISPOSITION,REC_STATUS,COUNT(*)
1289: FROM cz_imp_address_use
1290: WHERE RUN_ID = inRUN_ID
1291: GROUP BY DISPOSITION,REC_STATUS;
1292:
1293: ins_disposition cz_xfr_run_results.disposition%TYPE;