DBA Data[Home] [Help]

APPS.XLA_00275_AAD_S_000016_PKG dependencies on PA_XLA_BC_BUDGET_LINES_V

Line 58271: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58267: FROM (
58268: SELECT xet.event_id event_id
58269: , l2.line_number line_number
58270: , CASE r
58271: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58272: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58273: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58274: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58275: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 58272: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58268: SELECT xet.event_id event_id
58269: , l2.line_number line_number
58270: , CASE r
58271: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58272: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58273: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58274: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58275: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58276: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 58273: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58269: , l2.line_number line_number
58270: , CASE r
58271: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58272: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58273: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58274: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58275: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58276: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58277: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 58274: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58270: , CASE r
58271: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58272: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58273: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58274: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58275: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58276: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58277: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58278: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 58275: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58271: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58272: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58273: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58274: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58275: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58276: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58277: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58278: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58279: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 58276: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58272: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58273: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58274: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58275: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58276: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58277: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58278: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58279: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58280: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 58277: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58273: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58274: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58275: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58276: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58277: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58278: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58279: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58280: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58281:

Line 58278: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58274: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58275: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58276: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58277: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58278: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58279: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58280: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58281:
58282: ELSE null

Line 58279: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58275: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58276: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58277: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58278: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58279: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58280: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58281:
58282: ELSE null
58283: END object_name

Line 58280: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58276: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58277: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58278: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58279: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58280: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58281:
58282: ELSE null
58283: END object_name
58284: , CASE r

Line 58347: , PA_XLA_BC_BUDGET_LINES_V l2

58343:
58344: ELSE null
58345: END source_meaning
58346: FROM xla_events_gt xet
58347: , PA_XLA_BC_BUDGET_LINES_V l2
58348: , fnd_lookup_values fvl34
58349: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
58350: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58351: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 58491: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;

58487:
58488: TYPE t_array_source_88 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
58489: TYPE t_array_source_89 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
58490:
58491: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
58492: TYPE t_array_source_22 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
58493: TYPE t_array_source_25 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58494: TYPE t_array_source_34 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
58495: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 58492: TYPE t_array_source_22 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

58488: TYPE t_array_source_88 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
58489: TYPE t_array_source_89 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
58490:
58491: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
58492: TYPE t_array_source_22 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
58493: TYPE t_array_source_25 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58494: TYPE t_array_source_34 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
58495: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58496: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 58493: TYPE t_array_source_25 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

58489: TYPE t_array_source_89 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
58490:
58491: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
58492: TYPE t_array_source_22 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
58493: TYPE t_array_source_25 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58494: TYPE t_array_source_34 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
58495: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58496: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58497: TYPE t_array_source_53 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 58494: TYPE t_array_source_34 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

58490:
58491: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
58492: TYPE t_array_source_22 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
58493: TYPE t_array_source_25 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58494: TYPE t_array_source_34 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
58495: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58496: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58497: TYPE t_array_source_53 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58498: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 58495: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

58491: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
58492: TYPE t_array_source_22 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
58493: TYPE t_array_source_25 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58494: TYPE t_array_source_34 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
58495: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58496: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58497: TYPE t_array_source_53 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58498: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
58499: TYPE t_array_source_90 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 58496: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

58492: TYPE t_array_source_22 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
58493: TYPE t_array_source_25 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58494: TYPE t_array_source_34 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
58495: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58496: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58497: TYPE t_array_source_53 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58498: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
58499: TYPE t_array_source_90 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
58500: TYPE t_array_source_91 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 58497: TYPE t_array_source_53 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

58493: TYPE t_array_source_25 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58494: TYPE t_array_source_34 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
58495: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58496: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58497: TYPE t_array_source_53 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58498: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
58499: TYPE t_array_source_90 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
58500: TYPE t_array_source_91 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
58501:

Line 58498: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

58494: TYPE t_array_source_34 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
58495: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58496: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58497: TYPE t_array_source_53 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58498: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
58499: TYPE t_array_source_90 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
58500: TYPE t_array_source_91 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
58501:
58502: l_array_source_88 t_array_source_88;

Line 58499: TYPE t_array_source_90 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

58495: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58496: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58497: TYPE t_array_source_53 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58498: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
58499: TYPE t_array_source_90 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
58500: TYPE t_array_source_91 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
58501:
58502: l_array_source_88 t_array_source_88;
58503: l_array_source_89 t_array_source_89;

Line 58500: TYPE t_array_source_91 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

58496: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58497: TYPE t_array_source_53 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58498: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
58499: TYPE t_array_source_90 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
58500: TYPE t_array_source_91 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
58501:
58502: l_array_source_88 t_array_source_88;
58503: l_array_source_89 t_array_source_89;
58504:

Line 58600: , PA_XLA_BC_BUDGET_LINES_V l2

58596: , l2.USE_ENC_UPG_ATTRIB_FLAG source_55
58597: , l2.BUDGET_LINE_ID source_90
58598: , l2.ENC_UPG_ENC_TYPE_ID source_91
58599: FROM xla_events_gt xet
58600: , PA_XLA_BC_BUDGET_LINES_V l2
58601: , fnd_lookup_values fvl34
58602: WHERE xet.event_id between x_first_event_id and x_last_event_id
58603: and xet.event_date between p_pad_start_date and p_pad_end_date
58604: and xet.event_class_code = C_EVENT_CLASS_CODE