APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on PO_PRINT_FORM_FORMATS

Line 5161: l_template_code po_print_form_formats.DOC_FORMAT_TMPL_CODE%TYPE;

5157: l_doc_type VARCHAR2(10);
5158: x_progress varchar2(1000);
5159: l_request_id number;
5160: l_revision_number NUMBER;
5161: l_template_code po_print_form_formats.DOC_FORMAT_TMPL_CODE%TYPE;
5162: l_cd_territory fnd_languages.iso_territory%TYPE;
5163: l_lang_code fnd_languages.language_code%TYPE;
5164: l_application_name VARCHAR(2):= 'PO';
5165: BEGIN

Line 5202: from po_print_form_formats pf, po_drafts h, po_headers_all h1, fnd_languages f

5198:
5199:
5200: select pf.DOC_FORMAT_TMPL_CODE, f.iso_territory, f.language_code
5201: into l_template_code,l_cd_territory,l_lang_code
5202: from po_print_form_formats pf, po_drafts h, po_headers_all h1, fnd_languages f
5203: where pf.FORM_SOURCE = 'PO' and pf.DOCUMENT_TYPE = 'PO_MOD_STD_FORM' and pf.STANDARD_FORM = h.CLM_STANDARD_FORM
5204: and pf.DOCUMENT_FORMAT = h.CLM_DOCUMENT_FORMAT and h1.po_header_id = h.document_id
5205: and pf.STYLE_ID = h1.STYLE_ID and h.draft_id = l_draft_id and f.language_code = USERENV('LANG');
5206: