APPS.PAY_NL_XDO_REPORT dependencies on FND_DATE

Line 382: fnd_date.canonical_to_date(p_year) between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE);

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