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_HEADER_V

Line 76853: WHEN 1 THEN 'PA_XLA_BC_BUDGET_HEADER_V'

76849: FROM (
76850: SELECT xet.event_id event_id
76851: , 0 line_number
76852: , CASE r
76853: WHEN 1 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
76854: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
76855: WHEN 3 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
76856: WHEN 4 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
76857: WHEN 5 THEN 'PA_XLA_BC_BUDGET_HEADER_V'

Line 76855: WHEN 3 THEN 'PA_XLA_BC_BUDGET_HEADER_V'

76851: , 0 line_number
76852: , CASE r
76853: WHEN 1 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
76854: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
76855: WHEN 3 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
76856: WHEN 4 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
76857: WHEN 5 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
76858:
76859: ELSE null

Line 76856: WHEN 4 THEN 'PA_XLA_BC_BUDGET_HEADER_V'

76852: , CASE r
76853: WHEN 1 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
76854: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
76855: WHEN 3 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
76856: WHEN 4 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
76857: WHEN 5 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
76858:
76859: ELSE null
76860: END object_name

Line 76857: WHEN 5 THEN 'PA_XLA_BC_BUDGET_HEADER_V'

76853: WHEN 1 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
76854: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
76855: WHEN 3 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
76856: WHEN 4 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
76857: WHEN 5 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
76858:
76859: ELSE null
76860: END object_name
76861: , CASE r

Line 76904: , PA_XLA_BC_BUDGET_HEADER_V h1

76900:
76901: ELSE null
76902: END source_meaning
76903: FROM xla_events_gt xet
76904: , PA_XLA_BC_BUDGET_HEADER_V h1
76905: , PA_XLA_PROJECT_REF_V h3
76906: , fnd_lookup_values fvl38
76907: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
76908: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 77213: TYPE t_array_source_37 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BUDGET_AMOUNT_CODE%TYPE INDEX BY BINARY_INTEGER;

77209: --
77210: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
77211: --
77212:
77213: TYPE t_array_source_37 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BUDGET_AMOUNT_CODE%TYPE INDEX BY BINARY_INTEGER;
77214: TYPE t_array_source_38 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_TYPE_CLASS_CODE%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;

Line 77215: TYPE t_array_source_39 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BC_BALANCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

77211: --
77212:
77213: TYPE t_array_source_37 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BUDGET_AMOUNT_CODE%TYPE INDEX BY BINARY_INTEGER;
77214: TYPE t_array_source_38 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_TYPE_CLASS_CODE%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;

Line 77216: TYPE t_array_source_75 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

77212:
77213: TYPE t_array_source_37 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BUDGET_AMOUNT_CODE%TYPE INDEX BY BINARY_INTEGER;
77214: TYPE t_array_source_38 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_TYPE_CLASS_CODE%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;

Line 77217: TYPE t_array_source_76 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;

77213: TYPE t_array_source_37 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.BUDGET_AMOUNT_CODE%TYPE INDEX BY BINARY_INTEGER;
77214: TYPE t_array_source_38 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_TYPE_CLASS_CODE%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;

Line 77291: , PA_XLA_BC_BUDGET_HEADER_V h1

77287: , h1.BC_BALANCE_TYPE source_39
77288: , h1.GL_DATE source_75
77289: , h1.GL_BUDGET_VERSION_ID source_76
77290: FROM xla_events_gt xet
77291: , PA_XLA_BC_BUDGET_HEADER_V h1
77292: , PA_XLA_PROJECT_REF_V h3
77293: , fnd_lookup_values fvl38
77294: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
77295: and xet.event_class_code = C_EVENT_CLASS_CODE