DBA Data[Home] [Help]

APPS.PQP_EXR_SWI dependencies on XDO_TEMPLATES_VL

Line 403: SELECT xtv.template_id FROM xdo_templates_vl xtv

399: l_temp_id number;
400:
401: -- bug 16421152
402: CURSOR c_template_code is
403: SELECT xtv.template_id FROM xdo_templates_vl xtv
404: where xtv.application_id=8303
405: and xtv.data_source_code = 'PQPRPEXR'
406: and xtv.template_name = p_template_name;
407:

Line 721: from xdo_templates_vl

717:
718:
719: cursor c_rtf_data(c_template_name in varchar2) is
720: Select application_short_name,template_code,default_language,default_territory
721: from xdo_templates_vl
722: where template_name =c_template_name
723: and application_id=8303;
724:
725: CURSOR c_rep_id (c_exception_report_id IN VARCHAR2