DBA Data[Home] [Help]

APPS.IGF_AW_LI_IMPORT dependencies on DUAL

Line 755: SELECT igf_aw_award_level_hist_s.NEXTVAL INTO l_award_hist_tran_id from dual;

751: CLOSE c_get_awd_details;
752:
753: IF g_old_award_rec.award_id IS NOT NULL AND g_new_award_rec.award_id IS NOT NULL THEN
754: -- Get the new transaction Id
755: SELECT igf_aw_award_level_hist_s.NEXTVAL INTO l_award_hist_tran_id from dual;
756: -- insert history record for the 6 attributes IF any change
757: l_row_id := null;
758: OPEN c_lookup_attribute;
759: LOOP