APPS.PAY_NL_ATS_REPORT dependencies on FND_LOBS

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

3209: l_end_date DATE := TO_DATE('31/12/4712', 'dd/mm/yyyy');
3210:
3211: BEGIN
3212: -- program_name will be used to store the file_name
3213: -- this is bcos the file_name in fnd_lobs contains
3214: -- the full patch of the doc and not just the file name
3215: SELECT program_name
3216: INTO l_file_name
3217: FROM fnd_lobs

Line 3217: FROM fnd_lobs

3213: -- this is bcos the file_name in fnd_lobs contains
3214: -- the full patch of the doc and not just the file name
3215: SELECT program_name
3216: INTO l_file_name
3217: FROM fnd_lobs
3218: WHERE file_id = p_file_id;
3219:
3220: -- the delete will ensure that the patch is rerunnable
3221: DELETE FROM per_gb_xdo_templates

Line 3234: FROM fnd_lobs

3230: effective_start_date,
3231: effective_end_date)
3232: SELECT p_file_id, l_file_name, 'Template for year 0001-4712',
3233: l_start_date, l_end_date
3234: FROM fnd_lobs
3235: WHERE file_id = p_file_id;
3236: END;
3237:
3238: /*-----------------------------------------------------------------------------