APPS.RRS_IMPORT_INTERFACE_PKG dependencies on DUAL

Line 183: FROM DUAL;

179: -- l_data_set_id := RRS_SITE_INTF_SETS_S.NEXTVAL;
180:
181: SELECT RRS_SITE_INTF_SETS_S.NEXTVAL
182: INTO l_data_set_id
183: FROM DUAL;
184:
185: If l_site_exist = 'Y' then
186: UPDATE RRS_SITE_UA_INTF
187: SET DATA_SET_ID = l_data_set_id,

Line 586: FROM DUAL;

582:
583: -- l_site_id_num := rrs_default_site_number_s.nextval;
584: SELECT RRS_DEFAULT_SITE_NUMBER_S.NEXTVAL
585: INTO l_site_id_num
586: FROM DUAL;
587:
588: Begin
589: Select site_identification_number
590: into l_site_id_num_exist