APPS.IGS_AD_INS_ADMPERD dependencies on DUAL

Line 161: SELECT IGS_AD_PRD_PS_OF_OPT_SEQ_NUM_S.NEXTVAL FROM DUAL;

157: v_apcoo_one_not_insert BOOLEAN DEFAULT FALSE;
158: v_apcoo_one_insert BOOLEAN DEFAULT FALSE;
159: v_apcoo_one_apcoo BOOLEAN DEFAULT FALSE;
160: CURSOR C_IGS_ADPRD_NUM_S IS
161: SELECT IGS_AD_PRD_PS_OF_OPT_SEQ_NUM_S.NEXTVAL FROM DUAL;
162: CURSOR c_apapc IS
163: SELECT s_admission_process_type
164: FROM IGS_AD_PRD_AD_PRC_CA
165: WHERE adm_cal_type = p_adm_cal_type AND