DBA Data[Home] [Help]

APPS.JG_ZZ_COMMON_PKG dependencies on JG_ZZ_VAT_TRX_DETAILS

Line 45: jg_zz_vat_trx_details. First it is verified for what the

41: Company Info should be populated. Only Contact and telephone will be blank if there is no
42: Contact info, other data in the headers will be populated normally
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 ),

Line 83: FROM jg_zz_vat_trx_details JZVTD

79: SELECT DECODE(JZVRE.entity_level_code,'LEDGER',GL.currency_code,nvl(JZVTD.functional_currency_code, jzvtd.trx_currency_code))
80: ,JZVTD.rep_context_entity_name
81: ,JZVTD.rep_entity_id
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