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_000004_BC_PKG dependencies on PA_XLA_BC_BUDGET_LINES_V

Line 2188: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'

2184: FROM (
2185: SELECT xet.event_id event_id
2186: , l2.line_number line_number
2187: , CASE r
2188: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2189: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2190: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2191: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2192: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 2189: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'

2185: SELECT xet.event_id event_id
2186: , l2.line_number line_number
2187: , CASE r
2188: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2189: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2190: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2191: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2192: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2193: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 2190: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'

2186: , l2.line_number line_number
2187: , CASE r
2188: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2189: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2190: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2191: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2192: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2193: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2194: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 2191: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'

2187: , CASE r
2188: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2189: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2190: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2191: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2192: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2193: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2194: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2195: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 2192: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'

2188: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2189: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2190: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2191: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2192: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2193: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2194: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2195: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2196: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 2193: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'

2189: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2190: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2191: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2192: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2193: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2194: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2195: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2196: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2197: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 2194: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'

2190: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2191: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2192: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2193: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2194: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2195: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2196: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2197: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2198: WHEN 11 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 2195: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'

2191: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2192: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2193: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2194: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2195: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2196: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2197: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2198: WHEN 11 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2199: WHEN 12 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 2196: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'

2192: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2193: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2194: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2195: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2196: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2197: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2198: WHEN 11 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2199: WHEN 12 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2200: WHEN 13 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 2197: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'

2193: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2194: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2195: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2196: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2197: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2198: WHEN 11 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2199: WHEN 12 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2200: WHEN 13 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2201:

Line 2198: WHEN 11 THEN 'PA_XLA_BC_BUDGET_LINES_V'

2194: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2195: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2196: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2197: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2198: WHEN 11 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2199: WHEN 12 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2200: WHEN 13 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2201:
2202: ELSE null

Line 2199: WHEN 12 THEN 'PA_XLA_BC_BUDGET_LINES_V'

2195: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2196: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2197: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2198: WHEN 11 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2199: WHEN 12 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2200: WHEN 13 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2201:
2202: ELSE null
2203: END object_name

Line 2200: WHEN 13 THEN 'PA_XLA_BC_BUDGET_LINES_V'

2196: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2197: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2198: WHEN 11 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2199: WHEN 12 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2200: WHEN 13 THEN 'PA_XLA_BC_BUDGET_LINES_V'
2201:
2202: ELSE null
2203: END object_name
2204: , CASE r

Line 2279: , PA_XLA_BC_BUDGET_LINES_V l2

2275:
2276: ELSE null
2277: END source_meaning
2278: FROM xla_events_gt xet
2279: , PA_XLA_BC_BUDGET_LINES_V l2
2280: , fnd_lookup_values fvl6
2281: , (select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
2282: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
2283: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 2426: TYPE t_array_source_1 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;

2422: TYPE t_array_source_16 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.EXTERNAL_BUDGET_CODE%TYPE INDEX BY BINARY_INTEGER;
2423: TYPE t_array_source_17 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
2424: TYPE t_array_source_18 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
2425:
2426: TYPE t_array_source_1 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
2427: TYPE t_array_source_4 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2428: TYPE t_array_source_5 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
2429: TYPE t_array_source_6 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
2430: TYPE t_array_source_7 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 2427: TYPE t_array_source_4 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

2423: TYPE t_array_source_17 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
2424: TYPE t_array_source_18 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
2425:
2426: TYPE t_array_source_1 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
2427: TYPE t_array_source_4 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2428: TYPE t_array_source_5 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
2429: TYPE t_array_source_6 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
2430: TYPE t_array_source_7 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
2431: TYPE t_array_source_8 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 2428: TYPE t_array_source_5 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

2424: TYPE t_array_source_18 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
2425:
2426: TYPE t_array_source_1 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
2427: TYPE t_array_source_4 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2428: TYPE t_array_source_5 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
2429: TYPE t_array_source_6 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
2430: TYPE t_array_source_7 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
2431: TYPE t_array_source_8 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
2432: TYPE t_array_source_9 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 2429: TYPE t_array_source_6 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

2425:
2426: TYPE t_array_source_1 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
2427: TYPE t_array_source_4 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2428: TYPE t_array_source_5 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
2429: TYPE t_array_source_6 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
2430: TYPE t_array_source_7 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
2431: TYPE t_array_source_8 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
2432: TYPE t_array_source_9 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
2433: TYPE t_array_source_10 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 2430: TYPE t_array_source_7 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

2426: TYPE t_array_source_1 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
2427: TYPE t_array_source_4 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2428: TYPE t_array_source_5 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
2429: TYPE t_array_source_6 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
2430: TYPE t_array_source_7 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
2431: TYPE t_array_source_8 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
2432: TYPE t_array_source_9 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
2433: TYPE t_array_source_10 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
2434: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 2431: TYPE t_array_source_8 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

2427: TYPE t_array_source_4 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2428: TYPE t_array_source_5 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
2429: TYPE t_array_source_6 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
2430: TYPE t_array_source_7 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
2431: TYPE t_array_source_8 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
2432: TYPE t_array_source_9 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
2433: TYPE t_array_source_10 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
2434: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
2435: TYPE t_array_source_12 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 2432: TYPE t_array_source_9 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

2428: TYPE t_array_source_5 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
2429: TYPE t_array_source_6 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
2430: TYPE t_array_source_7 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
2431: TYPE t_array_source_8 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
2432: TYPE t_array_source_9 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
2433: TYPE t_array_source_10 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
2434: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
2435: TYPE t_array_source_12 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
2436: TYPE t_array_source_13 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 2433: TYPE t_array_source_10 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

2429: TYPE t_array_source_6 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
2430: TYPE t_array_source_7 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
2431: TYPE t_array_source_8 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
2432: TYPE t_array_source_9 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
2433: TYPE t_array_source_10 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
2434: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
2435: TYPE t_array_source_12 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
2436: TYPE t_array_source_13 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
2437: TYPE t_array_source_14 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 2434: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

2430: TYPE t_array_source_7 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
2431: TYPE t_array_source_8 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
2432: TYPE t_array_source_9 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
2433: TYPE t_array_source_10 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
2434: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
2435: TYPE t_array_source_12 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
2436: TYPE t_array_source_13 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
2437: TYPE t_array_source_14 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
2438: TYPE t_array_source_15 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 2435: TYPE t_array_source_12 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

2431: TYPE t_array_source_8 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
2432: TYPE t_array_source_9 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
2433: TYPE t_array_source_10 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
2434: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
2435: TYPE t_array_source_12 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
2436: TYPE t_array_source_13 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
2437: TYPE t_array_source_14 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
2438: TYPE t_array_source_15 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
2439:

Line 2436: TYPE t_array_source_13 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

2432: TYPE t_array_source_9 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
2433: TYPE t_array_source_10 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
2434: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
2435: TYPE t_array_source_12 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
2436: TYPE t_array_source_13 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
2437: TYPE t_array_source_14 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
2438: TYPE t_array_source_15 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
2439:
2440: l_array_source_2 t_array_source_2;

Line 2437: TYPE t_array_source_14 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

2433: TYPE t_array_source_10 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
2434: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
2435: TYPE t_array_source_12 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
2436: TYPE t_array_source_13 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
2437: TYPE t_array_source_14 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
2438: TYPE t_array_source_15 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
2439:
2440: l_array_source_2 t_array_source_2;
2441: l_array_source_3 t_array_source_3;

Line 2438: TYPE t_array_source_15 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

2434: TYPE t_array_source_11 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
2435: TYPE t_array_source_12 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
2436: TYPE t_array_source_13 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
2437: TYPE t_array_source_14 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
2438: TYPE t_array_source_15 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
2439:
2440: l_array_source_2 t_array_source_2;
2441: l_array_source_3 t_array_source_3;
2442: l_array_source_16 t_array_source_16;

Line 2550: , PA_XLA_BC_BUDGET_LINES_V l2

2546: , l2.EXCHANGE_RATE source_13
2547: , l2.EXCHANGE_RATE_TYPE source_14
2548: , l2.ENC_UPG_ENC_TYPE_ID source_15
2549: FROM xla_events_gt xet
2550: , PA_XLA_BC_BUDGET_LINES_V l2
2551: , fnd_lookup_values fvl6
2552: WHERE xet.event_id between x_first_event_id and x_last_event_id
2553: and xet.event_date between p_pad_start_date and p_pad_end_date
2554: and xet.event_class_code = C_EVENT_CLASS_CODE