APPS.IGS_AV_UNT_LGCY_PUB dependencies on DUAL

Line 800: select igs_av_stnd_unit_s.nextval from dual ;

796: x_return_status BOOLEAN := TRUE;
797: l_c_tmp_msg VARCHAR2(30);
798: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;
799: CURSOR c_igs_av_stnd_unit_seq IS
800: select igs_av_stnd_unit_s.nextval from dual ;
801:
802: BEGIN
803:
804: OPEN c_igs_av_stnd_unit_seq ;

Line 1610: select IGS_AV_UNT_REF_CDS_S.nextval from dual;

1606: l_reference_code_id igs_ge_ref_cd.reference_code_id%TYPE;
1607: l_AVU_REFERENCE_CD_ID IGS_AV_UNT_REF_CDS.AVU_REFERENCE_CD_ID%TYPE;
1608:
1609: CURSOR c_unit_ref_id is
1610: select IGS_AV_UNT_REF_CDS_S.nextval from dual;
1611:
1612: BEGIN
1613: mydebug('ENTERED create_adv_stnd_unit ');
1614: --Standard start of API savepoint