[Home] [Help]
9: p_bsv VARCHAR2,
10: p_gl_date DATE)
11: IS
12: SELECT vals.legal_entity_id
13: FROM gl_ledger_le_bsv_specific_v vals
14: WHERE vals.segment_value = p_bsv
15: AND vals.ledger_id = p_ledger_id
16: AND (TRUNC(p_gl_date) BETWEEN TRUNC(NVL(vals.start_date, p_gl_date)) AND
17: TRUNC(NVL(vals.end_date, p_gl_date)));