DBA Data[Home] [Help]

APPS.AP_PERIOD_CLOSE_PKG dependencies on DUAL

Line 466: select 1 from dual where ail.discarded_flag = 'Y'

462:
463: --Bug 7242216 Excluding invoices having discarded lines with
464: --no distributions
465: union
466: select 1 from dual where ail.discarded_flag = 'Y'
467: )
468: and ail.amount <> 0
469: and ai.cancelled_date is null
470: and ail.set_of_books_id = g_ledger_id

Line 528: select 1 from dual where ail.discarded_flag = 'Y'

524:
525: --Bug 7242216 Excluding invoices having discarded lines with
526: --no distributions
527: union
528: select 1 from dual where ail.discarded_flag = 'Y'
529: )
530: and ail.amount <> 0
531: and ai.cancelled_date is null
532: and ail.set_of_books_id = g_ledger_id