Line 234: select qp_pte_source_system_s.nextval into l_pte_source_system_id from dual;
230: exception
231: when no_data_found then
232: begin
233: 234: select qp_pte_source_system_s.nextval into l_pte_source_system_id from dual; 235:
236: insert into qp_pte_source_systems
237: (pte_source_system_id,
238: pte_code,
Line 328: select qp_pte_ss_fnarea_id_s.nextval into l_pte_sourcesystem_fnarea_id from dual;
324: exception
325: when no_data_found then
326: begin
327: 328: select qp_pte_ss_fnarea_id_s.nextval into l_pte_sourcesystem_fnarea_id from dual; 329:
330: insert into QP_SOURCESYSTEM_FNAREA_MAP ( pte_sourcesystem_fnarea_id,
331: pte_source_system_id,
332: functional_area_id,