76977: FROM (
76978: SELECT xet.event_id event_id
76979: , l2.line_number line_number
76980: , CASE r
76981: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76982: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76983: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76984: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76985: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76978: SELECT xet.event_id event_id
76979: , l2.line_number line_number
76980: , CASE r
76981: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76982: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76983: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76984: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76985: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76986: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76979: , l2.line_number line_number
76980: , CASE r
76981: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76982: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76983: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76984: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76985: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76986: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76987: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76980: , CASE r
76981: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76982: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76983: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76984: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76985: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76986: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76987: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76988: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76981: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76982: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76983: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76984: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76985: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76986: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76987: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76988: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76989: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76982: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76983: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76984: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76985: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76986: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76987: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76988: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76989: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76990: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76983: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76984: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76985: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76986: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76987: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76988: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76989: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76990: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76991: WHEN 11 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76984: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76985: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76986: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76987: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76988: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76989: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76990: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76991: WHEN 11 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76992: WHEN 12 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76985: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76986: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76987: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76988: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76989: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76990: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76991: WHEN 11 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76992: WHEN 12 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76993: WHEN 13 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76986: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76987: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76988: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76989: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76990: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76991: WHEN 11 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76992: WHEN 12 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76993: WHEN 13 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76994:
76987: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76988: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76989: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76990: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76991: WHEN 11 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76992: WHEN 12 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76993: WHEN 13 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76994:
76995: ELSE null
76988: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76989: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76990: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76991: WHEN 11 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76992: WHEN 12 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76993: WHEN 13 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76994:
76995: ELSE null
76996: END object_name
76989: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76990: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76991: WHEN 11 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76992: WHEN 12 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76993: WHEN 13 THEN 'PA_XLA_BC_BUDGET_LINES_V'
76994:
76995: ELSE null
76996: END object_name
76997: , CASE r
77068:
77069: ELSE null
77070: END source_meaning
77071: FROM xla_events_gt xet
77072: , PA_XLA_BC_BUDGET_LINES_V l2
77073: , fnd_lookup_values fvl35
77074: , (select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
77075: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77076: AND xet.event_class_code = C_EVENT_CLASS_CODE
77215: TYPE t_array_source_39 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BC_BALANCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77216: TYPE t_array_source_75 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
77217: TYPE t_array_source_76 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
77218:
77219: TYPE t_array_source_3 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
77220: TYPE t_array_source_23 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
77221: TYPE t_array_source_26 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77222: TYPE t_array_source_28 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
77223: TYPE t_array_source_29 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
77216: TYPE t_array_source_75 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
77217: TYPE t_array_source_76 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
77218:
77219: TYPE t_array_source_3 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
77220: TYPE t_array_source_23 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
77221: TYPE t_array_source_26 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77222: TYPE t_array_source_28 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
77223: TYPE t_array_source_29 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
77224: TYPE t_array_source_30 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77217: TYPE t_array_source_76 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
77218:
77219: TYPE t_array_source_3 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
77220: TYPE t_array_source_23 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
77221: TYPE t_array_source_26 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77222: TYPE t_array_source_28 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
77223: TYPE t_array_source_29 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
77224: TYPE t_array_source_30 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77225: TYPE t_array_source_35 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77218:
77219: TYPE t_array_source_3 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
77220: TYPE t_array_source_23 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
77221: TYPE t_array_source_26 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77222: TYPE t_array_source_28 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
77223: TYPE t_array_source_29 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
77224: TYPE t_array_source_30 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77225: TYPE t_array_source_35 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77226: TYPE t_array_source_40 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77219: TYPE t_array_source_3 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
77220: TYPE t_array_source_23 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
77221: TYPE t_array_source_26 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77222: TYPE t_array_source_28 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
77223: TYPE t_array_source_29 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
77224: TYPE t_array_source_30 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77225: TYPE t_array_source_35 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77226: TYPE t_array_source_40 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77227: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
77220: TYPE t_array_source_23 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
77221: TYPE t_array_source_26 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77222: TYPE t_array_source_28 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
77223: TYPE t_array_source_29 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
77224: TYPE t_array_source_30 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77225: TYPE t_array_source_35 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77226: TYPE t_array_source_40 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77227: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
77228: TYPE t_array_source_42 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
77221: TYPE t_array_source_26 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77222: TYPE t_array_source_28 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
77223: TYPE t_array_source_29 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
77224: TYPE t_array_source_30 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77225: TYPE t_array_source_35 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77226: TYPE t_array_source_40 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77227: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
77228: TYPE t_array_source_42 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
77229: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
77222: TYPE t_array_source_28 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
77223: TYPE t_array_source_29 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
77224: TYPE t_array_source_30 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77225: TYPE t_array_source_35 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77226: TYPE t_array_source_40 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77227: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
77228: TYPE t_array_source_42 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
77229: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
77230: TYPE t_array_source_44 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
77223: TYPE t_array_source_29 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
77224: TYPE t_array_source_30 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77225: TYPE t_array_source_35 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77226: TYPE t_array_source_40 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77227: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
77228: TYPE t_array_source_42 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
77229: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
77230: TYPE t_array_source_44 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
77231: TYPE t_array_source_45 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
77224: TYPE t_array_source_30 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77225: TYPE t_array_source_35 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77226: TYPE t_array_source_40 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77227: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
77228: TYPE t_array_source_42 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
77229: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
77230: TYPE t_array_source_44 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
77231: TYPE t_array_source_45 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
77232:
77225: TYPE t_array_source_35 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77226: TYPE t_array_source_40 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77227: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
77228: TYPE t_array_source_42 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
77229: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
77230: TYPE t_array_source_44 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
77231: TYPE t_array_source_45 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
77232:
77233: l_array_source_37 t_array_source_37;
77226: TYPE t_array_source_40 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77227: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
77228: TYPE t_array_source_42 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
77229: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
77230: TYPE t_array_source_44 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
77231: TYPE t_array_source_45 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
77232:
77233: l_array_source_37 t_array_source_37;
77234: l_array_source_38 t_array_source_38;
77227: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
77228: TYPE t_array_source_42 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
77229: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
77230: TYPE t_array_source_44 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
77231: TYPE t_array_source_45 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
77232:
77233: l_array_source_37 t_array_source_37;
77234: l_array_source_38 t_array_source_38;
77235: l_array_source_38_meaning t_array_lookup_meaning;
77347: , l2.ACCT_AMOUNT source_43
77348: , l2.USE_ENC_UPG_ATTRIB_FLAG source_44
77349: , l2.ENC_UPG_ENC_TYPE_ID source_45
77350: FROM xla_events_gt xet
77351: , PA_XLA_BC_BUDGET_LINES_V l2
77352: , fnd_lookup_values fvl35
77353: WHERE xet.event_id between x_first_event_id and x_last_event_id
77354: and xet.event_date between p_pad_start_date and p_pad_end_date
77355: and xet.event_class_code = C_EVENT_CLASS_CODE