APPS.JG_ZZ_PTCE_DT_PKG dependencies on GL_LEDGERS

Line 39: ,gl_ledgers gl

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
43: AND gl.ledger_id = gllev.ledger_id

Line 49: gl_ledgers gl

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 ;
53:

Line 154: ,gl_ledgers gl

150: SELECT repent.ledger_id,
151: repent.balancing_segment_value,
152: gl.CHART_OF_ACCOUNTS_ID
153: FROM jg_zz_vat_rep_entities repent
154: ,gl_ledgers gl
155: WHERE vat_reporting_entity_id = p_reporting_entity_id
156: AND gl.ledger_id = repent.ledger_id;
157:
158: begin

Line 312: gl_ledgers gl

308:
309: SELECT application_column_name
310: INTO l_segment
311: FROM fnd_segment_attribute_values ,
312: gl_ledgers gl
313: WHERE id_flex_code = 'GL#'
314: AND attribute_value = 'Y'
315: AND segment_attribute_type = 'GL_BALANCING'
316: AND application_id = 101