APPS.QP_LOADER_PVT dependencies on QP_SOURCESYSTEM_FNAREA_MAP

Line 299: from QP_SOURCESYSTEM_FNAREA_MAP

295: if l_pte_source_system_id is not null then
296: begin
297: select pte_sourcesystem_fnarea_id,last_updated_by, last_update_date
298: into l_pte_sourcesystem_fnarea_id, l_db_last_updated_by, l_db_last_update_date
299: from QP_SOURCESYSTEM_FNAREA_MAP
300: where pte_source_system_id = l_pte_source_system_id
301: and functional_area_id = x_functional_area_id
302: and rownum = 1;
303:

Line 314: update QP_SOURCESYSTEM_FNAREA_MAP

310: x_file_who => l_db_who))
311: THEN
312: null;
313: else
314: update QP_SOURCESYSTEM_FNAREA_MAP
315: set enabled_flag = x_enabled_flag,
316: seeded_flag = x_seeded_flag,
317: last_updated_by = l_user_id,
318: last_update_date =to_date(x_last_update_date,'YYYY/MM/DD'),

Line 330: insert into QP_SOURCESYSTEM_FNAREA_MAP ( pte_sourcesystem_fnarea_id,

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,
333: enabled_flag,
334: seeded_flag,