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_000016_BC_PKG dependencies on PA_XLA_BC_BUDGET_HEADER_V

Line 2070: WHEN 1 THEN 'PA_XLA_BC_BUDGET_HEADER_V'

2066: FROM (
2067: SELECT xet.event_id event_id
2068: , 0 line_number
2069: , CASE r
2070: WHEN 1 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2071: WHEN 2 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2072: WHEN 3 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2073: WHEN 4 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2074: WHEN 5 THEN 'PA_XLA_BC_BUDGET_HEADER_V'

Line 2071: WHEN 2 THEN 'PA_XLA_BC_BUDGET_HEADER_V'

2067: SELECT xet.event_id event_id
2068: , 0 line_number
2069: , CASE r
2070: WHEN 1 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2071: WHEN 2 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2072: WHEN 3 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2073: WHEN 4 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2074: WHEN 5 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2075:

Line 2072: WHEN 3 THEN 'PA_XLA_BC_BUDGET_HEADER_V'

2068: , 0 line_number
2069: , CASE r
2070: WHEN 1 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2071: WHEN 2 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2072: WHEN 3 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2073: WHEN 4 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2074: WHEN 5 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2075:
2076: ELSE null

Line 2073: WHEN 4 THEN 'PA_XLA_BC_BUDGET_HEADER_V'

2069: , CASE r
2070: WHEN 1 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2071: WHEN 2 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2072: WHEN 3 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2073: WHEN 4 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2074: WHEN 5 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2075:
2076: ELSE null
2077: END object_name

Line 2074: WHEN 5 THEN 'PA_XLA_BC_BUDGET_HEADER_V'

2070: WHEN 1 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2071: WHEN 2 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2072: WHEN 3 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2073: WHEN 4 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2074: WHEN 5 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
2075:
2076: ELSE null
2077: END object_name
2078: , CASE r

Line 2117: , PA_XLA_BC_BUDGET_HEADER_V h1

2113: ELSE null
2114: END source_value
2115: , null source_meaning
2116: FROM xla_events_gt xet
2117: , PA_XLA_BC_BUDGET_HEADER_V h1
2118: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
2119: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
2120: AND xet.event_class_code = C_EVENT_CLASS_CODE
2121: AND h1.event_id = xet.event_id

Line 2420: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BUDGET_AMOUNT_CODE%TYPE INDEX BY BINARY_INTEGER;

2416: --
2417: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
2418: --
2419:
2420: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BUDGET_AMOUNT_CODE%TYPE INDEX BY BINARY_INTEGER;
2421: TYPE t_array_source_3 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BC_BALANCE_TYPE%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;

Line 2421: TYPE t_array_source_3 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BC_BALANCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

2417: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
2418: --
2419:
2420: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BUDGET_AMOUNT_CODE%TYPE INDEX BY BINARY_INTEGER;
2421: TYPE t_array_source_3 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BC_BALANCE_TYPE%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:

Line 2422: TYPE t_array_source_16 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.EXTERNAL_BUDGET_CODE%TYPE INDEX BY BINARY_INTEGER;

2418: --
2419:
2420: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BUDGET_AMOUNT_CODE%TYPE INDEX BY BINARY_INTEGER;
2421: TYPE t_array_source_3 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BC_BALANCE_TYPE%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;

Line 2423: TYPE t_array_source_17 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;

2419:
2420: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BUDGET_AMOUNT_CODE%TYPE INDEX BY BINARY_INTEGER;
2421: TYPE t_array_source_3 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BC_BALANCE_TYPE%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;

Line 2424: TYPE t_array_source_18 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

2420: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BUDGET_AMOUNT_CODE%TYPE INDEX BY BINARY_INTEGER;
2421: TYPE t_array_source_3 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BC_BALANCE_TYPE%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;

Line 2496: , PA_XLA_BC_BUDGET_HEADER_V h1

2492: , h1.EXTERNAL_BUDGET_CODE source_16
2493: , h1.GL_BUDGET_VERSION_ID source_17
2494: , h1.GL_DATE source_18
2495: FROM xla_events_gt xet
2496: , PA_XLA_BC_BUDGET_HEADER_V h1
2497: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
2498: and xet.event_class_code = C_EVENT_CLASS_CODE
2499: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
2500: