eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00275_AAD_S_000015_PKG dependencies on PA_XLA_BC_BUDGET_LINES_V

Line 76981: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'

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'

Line 76982: WHEN 2 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'

Line 76983: WHEN 3 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'

Line 76984: WHEN 4 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'

Line 76985: WHEN 5 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'

Line 76986: WHEN 6 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'

Line 76987: WHEN 7 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'

Line 76988: WHEN 8 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'

Line 76989: WHEN 9 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'

Line 76990: WHEN 10 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:

Line 76991: WHEN 11 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:
76995: ELSE null

Line 76992: WHEN 12 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
76996: END object_name

Line 76993: WHEN 13 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
76997: , CASE r

Line 77072: , PA_XLA_BC_BUDGET_LINES_V l2

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

Line 77219: TYPE t_array_source_3 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;

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;

Line 77220: TYPE t_array_source_23 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%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;

Line 77221: TYPE t_array_source_26 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%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;

Line 77222: TYPE t_array_source_28 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_DATE%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;

Line 77223: TYPE t_array_source_29 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE%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;

Line 77224: TYPE t_array_source_30 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_TYPE%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;

Line 77225: TYPE t_array_source_35 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%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;

Line 77226: TYPE t_array_source_40 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%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;

Line 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;

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;

Line 77228: TYPE t_array_source_42 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%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:

Line 77229: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%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:
77233: l_array_source_37 t_array_source_37;

Line 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;

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;

Line 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;

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;

Line 77351: , PA_XLA_BC_BUDGET_LINES_V l2

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