APPS.IGS_GE_GEN_002 dependencies on DUAL

Line 953: FROM DUAL;

949: v_is_right_length BOOLEAN DEFAULT TRUE;
950: v_id_generated BOOLEAN DEFAULT FALSE;
951: CURSOR c_get_nxt_seq_num IS
952: SELECT IGS_PE_PERSON_PE_ID_S.nextval
953: FROM DUAL;
954: --skpandey, Bug#4937960: Changed c_chk_id_exists cursor definition to optimize query
955: CURSOR c_chk_id_exists (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
956: SELECT 'x'
957: FROM IGS_PE_PERSON_BASE_V