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 157: ,gl_ledgers gl

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

Line 315: gl_ledgers gl

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