DBA Data[Home] [Help]

APPS.XLA_JE_VALIDATION_PKG dependencies on GL_LEDGER_SEGMENT_VALUES

Line 3887: LEFT OUTER JOIN gl_ledger_segment_values s

3883: IS
3884: CURSOR c_invalid_bal_segment IS
3885: SELECT t.*
3886: FROM xla_validation_lines_gt t
3887: LEFT OUTER JOIN gl_ledger_segment_values s
3888: ON s.segment_value = t.bal_seg_value
3889: AND s.segment_type_code = C_BAL_SEGMENT
3890: AND s.ledger_id = p_seg_ledger_id
3891: AND t.accounting_date BETWEEN NVL(s.start_date, t.accounting_date)

Line 4009: LEFT OUTER JOIN gl_ledger_segment_values s

4005: IS
4006: CURSOR c_invalid_mgt_segment IS
4007: SELECT t.*
4008: FROM xla_validation_lines_gt t
4009: LEFT OUTER JOIN gl_ledger_segment_values s
4010: ON s.segment_value = t.mgt_seg_value
4011: AND s.segment_type_code = C_MGT_SEGMENT
4012: AND s.ledger_id = p_seg_ledger_id
4013: AND t.accounting_date BETWEEN NVL(s.start_date, t.accounting_date)