APPS.PAY_NL_WTS_REPORT dependencies on FND_LOBS

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

1434: l_start_date DATE := TO_DATE('01/01/0001', 'dd/mm/yyyy');
1435: l_end_date DATE := TO_DATE('31/12/4712', 'dd/mm/yyyy');
1436: BEGIN
1437: -- program_name will be used to store the file_name
1438: -- this is bcos the file_name in fnd_lobs contains
1439: -- the full patch of the doc and not just the file name
1440: SELECT program_name
1441: INTO l_file_name
1442: FROM fnd_lobs

Line 1442: FROM fnd_lobs

1438: -- this is bcos the file_name in fnd_lobs contains
1439: -- the full patch of the doc and not just the file name
1440: SELECT program_name
1441: INTO l_file_name
1442: FROM fnd_lobs
1443: WHERE file_id = p_file_id;
1444: -- the delete will ensure that the patch is rerunnable
1445: DELETE FROM per_gb_xdo_templates
1446: WHERE file_name = l_file_name AND

Line 1457: FROM fnd_lobs

1453: effective_start_date,
1454: effective_end_date)
1455: SELECT p_file_id, l_file_name, 'Template for year 0001-4712',
1456: l_start_date, l_end_date
1457: FROM fnd_lobs
1458: WHERE file_id = p_file_id;
1459: END;
1460: END PAY_NL_WTS_REPORT;