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: *********************************************************************************** */

Line 86: ,gl_ledgers GL

82: ,JZVTD.taxpayer_id
83: FROM jg_zz_vat_trx_details JZVTD
84: ,jg_zz_vat_rep_status JZVRS
85: ,jg_zz_vat_rep_entities JZVRE
86: ,gl_ledgers GL
87: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id
88: AND JZVRS.vat_reporting_entity_id= pn_vat_rep_entity_id
89: AND (JZVRS.tax_calendar_period = pv_period_name
90: OR JZVRS.tax_calendar_year = pn_period_year)