DBA Data[Home] [Help]

APPS.PAY_NL_IZA_REPORT dependencies on FND_LOBS

Line 326: -- this is bcos the file_name in fnd_lobs contains

322: l_end_date DATE := TO_DATE('31/12/4712', 'dd/mm/yyyy');
323:
324: BEGIN
325: -- program_name will be used to store the file_name
326: -- this is bcos the file_name in fnd_lobs contains
327: -- the full patch of the doc and not just the file name
328: SELECT program_name
329: INTO l_file_name
330: FROM fnd_lobs

Line 330: FROM fnd_lobs

326: -- this is bcos the file_name in fnd_lobs contains
327: -- the full patch of the doc and not just the file name
328: SELECT program_name
329: INTO l_file_name
330: FROM fnd_lobs
331: WHERE file_id = p_file_id;
332:
333: -- the delete will ensure that the patch is rerunnable
334: DELETE FROM per_gb_xdo_templates

Line 347: FROM fnd_lobs

343: effective_start_date,
344: effective_end_date)
345: SELECT p_file_id, l_file_name, 'Template for year 0001-4712',
346: l_start_date, l_end_date
347: FROM fnd_lobs
348: WHERE file_id = p_file_id;
349: END;
350:
351: