DBA Data[Home] [Help]

APPS.JG_ZZ_COMMON_PKG dependencies on GL_LEDGERS

Line 47: jgzzvattrxdetails else if LEDGER then from gl_ledgers for bug 7287545

43: 120.10 25-Jul-2008 Varun Kejriwal Modified the code in the function funct_curr_legal in the cursor
44: lc_funct_curr_legal. Here the currency is no more fetched from
45: jg_zz_vat_trx_details. First it is verified for what the
46: Selection process was run. If for LE(Legal Entity) then from
47: jgzzvattrxdetails else if LEDGER then from gl_ledgers for bug 7287545
48: 120.13 09-Jan-2009 Varun Kejriwal Added a function get_amt_tot which takes invoice_id and ledger_id as parameters
49: and based on the type of the reporting entity ( LE/ Primary Ledger/ Secondary Ledger ),
50: it returns the appropriate invoice_amount.
51: 120.18 23-Feb-2009 Suresh Bug 9381398:

Line 97: ,gl_ledgers GL

93: ,JZVTD.taxpayer_id
94: FROM jg_zz_vat_trx_details JZVTD
95: ,jg_zz_vat_rep_status JZVRS
96: ,jg_zz_vat_rep_entities JZVRE
97: ,gl_ledgers GL
98: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id
99: AND JZVRS.vat_reporting_entity_id= pn_vat_rep_entity_id
100: AND (JZVRS.tax_calendar_period = pv_period_name
101: OR JZVRS.tax_calendar_year = pn_period_year)