APPS.PAY_NL_XDO_REPORT dependencies on FND_DATE

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

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
386: null;
387: END fetch_pdf_blob;