297: WHERE a.interface_id = cp_interface_id
298: AND a.status = '3';
299: l_interface_stat_rec c_stat_int%ROWTYPE ;
300:
301: l_imp_batch_id igs_ad_interface_all.batch_id%TYPE ;
302: l_interface_id igs_ad_interface_all.interface_id%TYPE ;
303: l_interface_stat_id igs_ad_stat_int_all.interface_stat_id%TYPE;
304: l_chk_per_present VARCHAR2(1) := 'Y';
305: l_col_ad_null VARCHAR2(1) := 'Y';
298: AND a.status = '3';
299: l_interface_stat_rec c_stat_int%ROWTYPE ;
300:
301: l_imp_batch_id igs_ad_interface_all.batch_id%TYPE ;
302: l_interface_id igs_ad_interface_all.interface_id%TYPE ;
303: l_interface_stat_id igs_ad_stat_int_all.interface_stat_id%TYPE;
304: l_chk_per_present VARCHAR2(1) := 'Y';
305: l_col_ad_null VARCHAR2(1) := 'Y';
306: l_col_spa_null VARCHAR2(1) := 'Y';