APPS.JTY_TERR_ENGINE_GEN2_PVT dependencies on DUAL

Line 111: FROM dual;

107: IF (l_no_of_records = 0) THEN
108:
109: SELECT jty_terr_values_idx_header_s.nextval
110: INTO l_header_seq
111: FROM dual;
112:
113: SELECT 'JTY_DNM_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_RN' ||
114: (nvl(max(to_number(substr(index_name, instr(index_name, '_RN')+3))), 0) + 1)
115: INTO l_index_name

Line 609: FROM dual;

605: IF (l_no_of_records = 0) THEN
606:
607: SELECT jty_dea_values_idx_header_s.nextval
608: INTO l_header_seq
609: FROM dual;
610:
611: INSERT INTO jty_dea_values_idx_header (
612: dea_values_idx_header_id
613: ,source_id