APPS.XLA_00275_AAD_S_000015_PKG dependencies on PA_XLA_PROJECT_REF_V

Line 76854: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'

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'
76858:

Line 76905: , PA_XLA_PROJECT_REF_V h3

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
76909: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 77214: TYPE t_array_source_38 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_TYPE_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;

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;
77218:

Line 77292: , PA_XLA_PROJECT_REF_V h3

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
77296: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id