DBA Data[Home] [Help]

APPS.JG_ZZ_PTCE_DT_PKG dependencies on GL_LEDGER_LE_V

Line 38: FROM gl_ledger_le_v gllev

34: SELECT gllev.currency_code
35: ,gl.name
36: ,fsp.vat_registration_num
37: ,fsp.vat_country_code
38: FROM gl_ledger_le_v gllev
39: ,gl_ledgers gl
40: ,financials_system_parameters fsp
41: WHERE gllev.ledger_category_code='PRIMARY'
42: AND gllev.legal_entity_id = gn_legal_entity_id

Line 48: FROM gl_ledger_le_v glle,

44: AND fsp.set_of_books_id = gllev.ledger_id ;
45:
46: CURSOR c_get_gl_name IS
47: SELECT gl.name
48: FROM gl_ledger_le_v glle,
49: gl_ledgers gl
50: WHERE
51: glle.legal_entity_id = gn_legal_entity_id
52: AND gl.ledger_id = glle.ledger_id ;