DBA Data[Home] [Help]

APPS.XLA_JE_VALIDATION_PKG dependencies on GL_LEDGER_SEGMENT_VALUES

Line 3606: LEFT OUTER JOIN gl_ledger_segment_values s

3602: IS
3603: CURSOR c_invalid_bal_segment IS
3604: SELECT t.*
3605: FROM xla_validation_lines_gt t
3606: LEFT OUTER JOIN gl_ledger_segment_values s
3607: ON s.segment_value = t.bal_seg_value
3608: AND s.segment_type_code = C_BAL_SEGMENT
3609: AND s.ledger_id = p_seg_ledger_id
3610: AND t.accounting_date BETWEEN NVL(s.start_date, t.accounting_date)

Line 3728: LEFT OUTER JOIN gl_ledger_segment_values s

3724: IS
3725: CURSOR c_invalid_mgt_segment IS
3726: SELECT t.*
3727: FROM xla_validation_lines_gt t
3728: LEFT OUTER JOIN gl_ledger_segment_values s
3729: ON s.segment_value = t.mgt_seg_value
3730: AND s.segment_type_code = C_MGT_SEGMENT
3731: AND s.ledger_id = p_seg_ledger_id
3732: AND t.accounting_date BETWEEN NVL(s.start_date, t.accounting_date)