APPS.XLA_00275_AAD_S_000004_PKG dependencies on PA_XLA_BC_BUDGET_HEADER_V

Line 58088: WHEN 1 THEN 'PA_XLA_BC_BUDGET_HEADER_V'

58084: FROM (
58085: SELECT xet.event_id event_id
58086: , 0 line_number
58087: , CASE r
58088: WHEN 1 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
58089: WHEN 2 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
58090:
58091: ELSE null
58092: END object_name

Line 58089: WHEN 2 THEN 'PA_XLA_BC_BUDGET_HEADER_V'

58085: SELECT xet.event_id event_id
58086: , 0 line_number
58087: , CASE r
58088: WHEN 1 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
58089: WHEN 2 THEN 'PA_XLA_BC_BUDGET_HEADER_V'
58090:
58091: ELSE null
58092: END object_name
58093: , CASE r

Line 58120: , PA_XLA_BC_BUDGET_HEADER_V h1

58116: ELSE null
58117: END source_value
58118: , null source_meaning
58119: FROM xla_events_gt xet
58120: , PA_XLA_BC_BUDGET_HEADER_V h1
58121: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
58122: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58123: AND xet.event_class_code = C_EVENT_CLASS_CODE
58124: AND h1.event_id = xet.event_id

Line 58408: TYPE t_array_source_87 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

58404: --
58405: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
58406: --
58407:
58408: TYPE t_array_source_87 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
58409: TYPE t_array_source_88 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
58410:
58411: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
58412: TYPE t_array_source_22 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 58409: TYPE t_array_source_88 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;

58405: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
58406: --
58407:
58408: TYPE t_array_source_87 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
58409: TYPE t_array_source_88 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
58410:
58411: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
58412: TYPE t_array_source_22 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
58413: TYPE t_array_source_25 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 58469: , PA_XLA_BC_BUDGET_HEADER_V h1

58465: ,xet.budgetary_control_flag
58466: , h1.GL_DATE source_87
58467: , h1.GL_BUDGET_VERSION_ID source_88
58468: FROM xla_events_gt xet
58469: , PA_XLA_BC_BUDGET_HEADER_V h1
58470: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
58471: and xet.event_class_code = C_EVENT_CLASS_CODE
58472: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
58473: