DBA Data[Home] [Help]

APPS.PAY_KW_PAYROLL_REGISTER dependencies on FND_LOBS

Line 1836: FROM fnd_lobs

1832: BEGIN
1833: If p_report = 'MAIN' then
1834: SELECT file_data
1835: INTO p_pdf_blob
1836: FROM fnd_lobs
1837: WHERE file_id = (SELECT MAX(file_id)
1838: FROM fnd_lobs
1839: WHERE file_name like '%PAY_PRG_ar_KW.pdf');
1840: /* Else

Line 1838: FROM fnd_lobs

1834: SELECT file_data
1835: INTO p_pdf_blob
1836: FROM fnd_lobs
1837: WHERE file_id = (SELECT MAX(file_id)
1838: FROM fnd_lobs
1839: WHERE file_name like '%PAY_PRG_ar_KW.pdf');
1840: /* Else
1841: SELECT file_data
1842: INTO p_pdf_blob

Line 1843: FROM fnd_lobs

1839: WHERE file_name like '%PAY_PRG_ar_KW.pdf');
1840: /* Else
1841: SELECT file_data
1842: INTO p_pdf_blob
1843: FROM fnd_lobs
1844: WHERE file_id = (SELECT MAX(file_id)
1845: FROM fnd_lobs
1846: WHERE file_name like '%PAY_PRG_SUMMARY_ar_KW.pdf');*/
1847: End If;

Line 1845: FROM fnd_lobs

1841: SELECT file_data
1842: INTO p_pdf_blob
1843: FROM fnd_lobs
1844: WHERE file_id = (SELECT MAX(file_id)
1845: FROM fnd_lobs
1846: WHERE file_name like '%PAY_PRG_SUMMARY_ar_KW.pdf');*/
1847: End If;
1848: EXCEPTION
1849: when no_data_found then