APPS.FII_GL_JE_B_C dependencies on GL_JE_HEADERS

Line 1430: gl_je_headers jeh,

1426: fii_source_ledger_groups fslg
1427: WHERE slga.je_rule_set_id = rule.je_rule_set_id (+)
1428: AND slga.source_ledger_group_id = fslg.source_ledger_group_id
1429: AND fslg.usage_code = g_usage_code) fset,
1430: gl_je_headers jeh,
1431: fii_encum_type_mappings etype,
1432: fii_gl_processed_header_ids fgph,
1433: gl_periods per2,
1434: gl_ledgers_public_v s2

Line 1980: FROM gl_je_headers jeh,

1976: jeh.encumbrance_type_id, --Added for PSI
1977: jeh.actual_flag, --Added for PSI
1978: org.req_encumbrance_type_id,
1979: org.purch_encumbrance_type_id
1980: FROM gl_je_headers jeh,
1981: (select distinct hdrs.ledger_id, hdrs.je_batch_id, bat.org_id
1982: from gl_je_headers hdrs, gl_je_batches bat
1983: where hdrs.je_batch_id = bat.je_batch_id
1984: ) jeb,

Line 1982: from gl_je_headers hdrs, gl_je_batches bat

1978: org.req_encumbrance_type_id,
1979: org.purch_encumbrance_type_id
1980: FROM gl_je_headers jeh,
1981: (select distinct hdrs.ledger_id, hdrs.je_batch_id, bat.org_id
1982: from gl_je_headers hdrs, gl_je_batches bat
1983: where hdrs.je_batch_id = bat.je_batch_id
1984: ) jeb,
1985: financials_system_params_all org,
1986: (

Line 2039: gl_je_headers jeh,

2035: 'C', NULL) encumbrance_type
2036: FROM gl_ledgers_public_v s,
2037: gl_periods p,
2038: gl_periods p2,
2039: gl_je_headers jeh,
2040: fii_encum_type_mappings etype,
2041: (SELECT /*+ no_merge */ DISTINCT
2042: slga.ledger_id,
2043: DECODE(slga.je_rule_set_id, NULL, '-1', rule.JE_SOURCE_NAME) je_source_name,