APPS.PAY_NL_XDO_REPORT dependencies on PER_GB_XDO_TEMPLATES

Line 381: Where file_id = (select file_id from per_gb_xdo_templates

377: BEGIN
378:
379: Select file_data Into p_pdf_blob
380: From fnd_lobs
381: Where file_id = (select file_id from per_gb_xdo_templates
382: where file_id=p_template_id and
383: fnd_date.canonical_to_date(p_year) between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE);
384: EXCEPTION
385: when no_data_found then