DBA Data[Home] [Help]

APPS.JE_IT_LISTING_PKG dependencies on GL_LEDGERS

Line 2044: ,gl_ledgers gl

2040: SELECT repent.ledger_id,
2041: repent.balancing_segment_value,
2042: gl.chart_of_accounts_id
2043: FROM jg_zz_vat_rep_entities repent
2044: ,gl_ledgers gl
2045: WHERE vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
2046: AND gl.ledger_id = repent.ledger_id;
2047:
2048: CURSOR c_get_le_and_period_dates

Line 2078: ,gl_ledgers gl

2074: IS
2075: SELECT gllev.currency_code
2076: ,hl.country
2077: FROM gl_ledger_le_v gllev
2078: ,gl_ledgers gl
2079: ,xle_registrations xr
2080: ,xle_entity_profiles xep
2081: ,hr_locations_all hl
2082: WHERE gllev.ledger_category_code='PRIMARY'

Line 2235: gl_ledgers gl

2231:
2232: SELECT application_column_name
2233: INTO l_segment
2234: FROM fnd_segment_attribute_values ,
2235: gl_ledgers gl
2236: WHERE id_flex_code = 'GL#'
2237: AND attribute_value = 'Y'
2238: AND segment_attribute_type = 'GL_BALANCING'
2239: AND application_id = 101