DBA Data[Home] [Help]

APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on XLA_UPGRADE_DATES

Line 1171: from xla_upgrade_dates xud

1167: and (nvl(oc.flag_post_gl, 'N') = 'N'
1168: or (oc.flag_post_gl = 'Y'
1169: and (exists (
1170: select 'Y'
1171: from xla_upgrade_dates xud
1172: where ract.set_of_books_id = xud.ledger_id
1173: and ((oc.gl_date >= xud.start_date and oc.gl_date < xud.end_date)
1174: or (oc.gl_date IS NULL and oc.creation_date between xud.start_date and xud.end_date)
1175: or (nvl(oc.occurrence_status,'CONFIRMED') <> 'CANCELED'

Line 1495: It is currently commented out because xla_upgrade_dates table is not available in xbuild2.

1491: -------------------------------------------------------------------
1492: -- Create the transaction entities
1493: -------------------------------------------------------------------
1494: /* The following code was modified as per the performance team recommendation to include global temporary tables.
1495: It is currently commented out because xla_upgrade_dates table is not available in xbuild2.
1496: The xla team is planning to release the table for general use post xbuild2. */
1497:
1498: NULL;
1499:

Line 1836: from xla_upgrade_dates xud

1832: and (nvl(oc.flag_post_gl, 'N') = 'N'
1833: or (oc.flag_post_gl = 'Y'
1834: and (exists (
1835: select 'Y'
1836: from xla_upgrade_dates xud
1837: where ract.set_of_books_id = xud.ledger_id
1838: and ((oc.gl_date >= xud.start_date and oc.gl_date < xud.end_date)
1839: or (oc.gl_date IS NULL and oc.creation_date between xud.start_date and xud.end_date)
1840: or (nvl(oc.occurrence_status,'CONFIRMED') <> 'CANCELED'