APPS.JTY_TERR_ENGINE_GEN2_PVT dependencies on DUAL

Line 101: FROM dual;

97: IF (l_no_of_records = 0) THEN
98:
99: SELECT jty_terr_values_idx_header_s.nextval
100: INTO l_header_seq
101: FROM dual;
102:
103: SELECT 'JTY_DNM_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_RN' ||
104: (nvl(max(to_number(substr(index_name, instr(index_name, '_RN')+3))), 0) + 1)
105: INTO l_index_name

Line 603: FROM dual;

599: IF (l_no_of_records = 0) THEN
600:
601: SELECT jty_dea_values_idx_header_s.nextval
602: INTO l_header_seq
603: FROM dual;
604:
605: INSERT INTO jty_dea_values_idx_header (
606: dea_values_idx_header_id
607: ,source_id