DBA Data[Home] [Help]

APPS.JG_ZZ_COMMON_PKG dependencies on XLA_AE_LINES

Line 55: changed the logic to fetch the amounts from xla ae lines.

51: 120.18 23-Feb-2009 Suresh Bug 9381398:
52: Modified the get_amt_tot function logic. Earlier the invoice amount
53: logic was based on xla distribution links. But due to some limitation
54: while accessing the amounts information for upgrade transactions
55: changed the logic to fetch the amounts from xla ae lines.
56: Refer bug 9386590 for more details on upgrade transanctions issue
57: with xla distribution links.
58: 120.11.12010000.11 13-Sep-2011 sakekuma Bug 12779390: Modified the get_amt_tot function logic to calculate invoice amount.Added
59: and xe.EVENT_TYPE_CODE <> 'PREPAYMENT APPLIED' so that prepayment applied events are

Line 550: xla_ae_lines xal

546: into l_amt
547: FROM xla_transaction_entities xte,
548: xla_events xe,
549: xla_ae_headers xah,
550: xla_ae_lines xal
551: WHERE xte.entity_id = xe.entity_id
552: AND xe.application_id = 200
553: AND xah.event_id = xe.event_id
554: AND xah.application_id = 200