DBA Data[Home] [Help]

APPS.PV_GQ_ELEMENTS_PVT dependencies on PV_GE_QSNR_ELEMENTS_TL

Line 341: FROM pv_ge_qsnr_elements_b b, pv_ge_qsnr_elements_tl tl

337: order by qsnr_element_id;
338:
339: CURSOR c_get_qsnr_element_tl_rec (cv_program_id IN NUMBER) IS
340: SELECT tl.qsnr_element_id, elmt_content, source_lang, language
341: FROM pv_ge_qsnr_elements_b b, pv_ge_qsnr_elements_tl tl
342: WHERE b.qsnr_element_id = tl.qsnr_element_id
343: AND b.arc_used_by_entity_code = 'PRGM'
344: AND b.used_by_entity_id = cv_program_id
345: order by tl.qsnr_element_id;

Line 522: INSERT INTO pv_ge_qsnr_elements_tl(

518:
519: end loop;
520:
521: Forall j in 1..old_qsnr_element_id_array.count
522: INSERT INTO pv_ge_qsnr_elements_tl(
523: qsnr_element_id ,
524: language ,
525: last_update_date ,
526: last_updated_by ,