APPS.PAY_NL_ATS_REPORT dependencies on FND_LOBS

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

3271: l_end_date DATE := TO_DATE('31/12/4712', 'dd/mm/yyyy');
3272:
3273: BEGIN
3274: -- program_name will be used to store the file_name
3275: -- this is bcos the file_name in fnd_lobs contains
3276: -- the full patch of the doc and not just the file name
3277: SELECT program_name
3278: INTO l_file_name
3279: FROM fnd_lobs

Line 3279: FROM fnd_lobs

3275: -- this is bcos the file_name in fnd_lobs contains
3276: -- the full patch of the doc and not just the file name
3277: SELECT program_name
3278: INTO l_file_name
3279: FROM fnd_lobs
3280: WHERE file_id = p_file_id;
3281:
3282: -- the delete will ensure that the patch is rerunnable
3283: DELETE FROM per_gb_xdo_templates

Line 3296: FROM fnd_lobs

3292: effective_start_date,
3293: effective_end_date)
3294: SELECT p_file_id, l_file_name, 'Template for year 0001-4712',
3295: l_start_date, l_end_date
3296: FROM fnd_lobs
3297: WHERE file_id = p_file_id;
3298: END;
3299:
3300: /*-----------------------------------------------------------------------------