APPS.IGR_IMP_001 dependencies on IGS_AD_EXCURR_INT_S

Line 191: l_sub_interest_type_code igs_ad_excurr_int.sub_interest_type_code%TYPE;

187: lookup_code = cp_interest_type_code AND
188: lookup_type in ( 'ENTERTAINMENT', 'INTEREST_TYPE') AND
189: enabled_flag = 'Y';
190:
191: l_sub_interest_type_code igs_ad_excurr_int.sub_interest_type_code%TYPE;
192:
193: CURSOR inq_per_test_cur(l_person_id igr_is_test.inq_person_id%TYPE) IS
194: SELECT
195: inq_test_id,

Line 1491: igs_ad_excurr_int_s.nextval ,

1487: null ,
1488: inq_per_extra_rec.interest_name,
1489: null ,
1490: inq_rec.org_id ,
1491: igs_ad_excurr_int_s.nextval ,
1492: l_interface_id ,
1493: null ,
1494: inq_per_extra_rec.start_date ,
1495: inq_per_extra_rec.end_date ,