APPS.PA_PURGE_VALIDATE_COSTING dependencies on FND_PROFILE

Line 304: and aid.expenditure_item_date >= nvl(to_date(fnd_profile.value_specific('PA_DISC_PULL_START_DATE'),'YYYY/MM/DD'),to_date('01/01/2051','DD/MM/YYYY')) /* Bug 3134267 */ /*Bug4124600*/ /* Bug 4468796 */

300: and paydist.amount <> 0
301: and ai.invoice_type_lookup_code <> 'EXPENSE REPORT'
302: and paydist.pay_dist_lookup_code = 'DISCOUNT'
303: and paydist.pa_addition_flag = 'N'
304: and aid.expenditure_item_date >= nvl(to_date(fnd_profile.value_specific('PA_DISC_PULL_START_DATE'),'YYYY/MM/DD'),to_date('01/01/2051','DD/MM/YYYY')) /* Bug 3134267 */ /*Bug4124600*/ /* Bug 4468796 */
305: /* --Commented for R12
306: and not exists
307: ( select 'X' from pa_cost_distribution_lines cdl
308: where cdl.system_reference2=to_char(aid.invoice_id)