APPS.XLA_00275_AAD_S_000016_PKG dependencies on PA_XLA_BC_BUDGET_HEADER_V

Line 58168: WHEN 1 THEN 'PA_XLA_BC_BUDGET_HEADER_V'

58164: FROM (
58165: SELECT xet.event_id event_id
58166: , 0 line_number
58167: , CASE r
58168: WHEN 1 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
58169: WHEN 2 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
58170:
58171: ELSE null
58172: END object_name

Line 58169: WHEN 2 THEN 'PA_XLA_BC_BUDGET_HEADER_V'

58165: SELECT xet.event_id event_id
58166: , 0 line_number
58167: , CASE r
58168: WHEN 1 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
58169: WHEN 2 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
58170:
58171: ELSE null
58172: END object_name
58173: , CASE r

Line 58200: , PA_XLA_BC_BUDGET_HEADER_V h1

58196: ELSE null
58197: END source_value
58198: , null source_meaning
58199: FROM xla_events_gt xet
58200: , PA_XLA_BC_BUDGET_HEADER_V h1
58201: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
58202: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58203: AND xet.event_class_code = C_EVENT_CLASS_CODE
58204: AND h1.event_id = xet.event_id

Line 58488: TYPE t_array_source_88 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

58484: --
58485: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
58486: --
58487:
58488: TYPE t_array_source_88 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
58489: TYPE t_array_source_89 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
58490:
58491: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
58492: TYPE t_array_source_22 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 58489: TYPE t_array_source_89 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;

58485: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
58486: --
58487:
58488: TYPE t_array_source_88 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
58489: TYPE t_array_source_89 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
58490:
58491: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
58492: TYPE t_array_source_22 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
58493: TYPE t_array_source_25 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 58549: , PA_XLA_BC_BUDGET_HEADER_V h1

58545: ,xet.budgetary_control_flag
58546: , h1.GL_DATE source_88
58547: , h1.GL_BUDGET_VERSION_ID source_89
58548: FROM xla_events_gt xet
58549: , PA_XLA_BC_BUDGET_HEADER_V h1
58550: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
58551: and xet.event_class_code = C_EVENT_CLASS_CODE
58552: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
58553: