APPS.PAY_NL_WTS_REPORT dependencies on FND_LOBS

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

1356: l_start_date DATE := TO_DATE('01/01/0001', 'dd/mm/yyyy');
1357: l_end_date DATE := TO_DATE('31/12/4712', 'dd/mm/yyyy');
1358: BEGIN
1359: -- program_name will be used to store the file_name
1360: -- this is bcos the file_name in fnd_lobs contains
1361: -- the full patch of the doc and not just the file name
1362: SELECT program_name
1363: INTO l_file_name
1364: FROM fnd_lobs

Line 1364: FROM fnd_lobs

1360: -- this is bcos the file_name in fnd_lobs contains
1361: -- the full patch of the doc and not just the file name
1362: SELECT program_name
1363: INTO l_file_name
1364: FROM fnd_lobs
1365: WHERE file_id = p_file_id;
1366: -- the delete will ensure that the patch is rerunnable
1367: DELETE FROM per_gb_xdo_templates
1368: WHERE file_name = l_file_name AND

Line 1379: FROM fnd_lobs

1375: effective_start_date,
1376: effective_end_date)
1377: SELECT p_file_id, l_file_name, 'Template for year 0001-4712',
1378: l_start_date, l_end_date
1379: FROM fnd_lobs
1380: WHERE file_id = p_file_id;
1381: END;
1382: END PAY_NL_WTS_REPORT;