APPS.XLA_00275_AAD_S_000016_PKG dependencies on PA_XLA_PROJECT_REF_V

Line 67962: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'

67958: SELECT xet.event_id event_id
67959: , 0 line_number
67960: , CASE r
67961: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
67962: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
67963: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
67964:
67965: ELSE null
67966: END object_name

Line 67999: , PA_XLA_PROJECT_REF_V h3

67995: END source_value
67996: , null source_meaning
67997: FROM xla_events_gt xet
67998: , PA_XLA_EXP_HEADER_V h2
67999: , PA_XLA_PROJECT_REF_V h3
68000: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
68001: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68002: AND xet.event_class_code = C_EVENT_CLASS_CODE
68003: AND h2.event_id = xet.event_id

Line 68334: TYPE t_array_source_68 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

68330: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
68331: --
68332:
68333: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
68334: TYPE t_array_source_68 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
68335: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
68336:
68337: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
68338: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 68414: , PA_XLA_PROJECT_REF_V h3

68410: , h3.PROJECT_NUMBER source_68
68411: , h2.GL_DATE source_88
68412: FROM xla_events_gt xet
68413: , PA_XLA_EXP_HEADER_V h2
68414: , PA_XLA_PROJECT_REF_V h3
68415: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
68416: and xet.event_class_code = C_EVENT_CLASS_CODE
68417: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
68418: AND h3.PROJECT_ID=h2.PROJECT_ID

Line 69274: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'

69270: SELECT xet.event_id event_id
69271: , 0 line_number
69272: , CASE r
69273: WHEN 1 THEN 'PA_XLA_EXP_HEADER_V'
69274: WHEN 2 THEN 'PA_XLA_PROJECT_REF_V'
69275: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
69276:
69277: ELSE null
69278: END object_name

Line 69311: , PA_XLA_PROJECT_REF_V h3

69307: END source_value
69308: , null source_meaning
69309: FROM xla_events_gt xet
69310: , PA_XLA_EXP_HEADER_V h2
69311: , PA_XLA_PROJECT_REF_V h3
69312: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
69313: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69314: AND xet.event_class_code = C_EVENT_CLASS_CODE
69315: AND h2.event_id = xet.event_id

Line 69646: TYPE t_array_source_68 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

69642: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
69643: --
69644:
69645: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
69646: TYPE t_array_source_68 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
69647: TYPE t_array_source_88 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
69648:
69649: TYPE t_array_source_3 IS TABLE OF PA_XLA_CDL_LINES_V.COST_CCID%TYPE INDEX BY BINARY_INTEGER;
69650: TYPE t_array_source_4 IS TABLE OF PA_XLA_CDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 69726: , PA_XLA_PROJECT_REF_V h3

69722: , h3.PROJECT_NUMBER source_68
69723: , h2.GL_DATE source_88
69724: FROM xla_events_gt xet
69725: , PA_XLA_EXP_HEADER_V h2
69726: , PA_XLA_PROJECT_REF_V h3
69727: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
69728: and xet.event_class_code = C_EVENT_CLASS_CODE
69729: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
69730: AND h3.PROJECT_ID=h2.PROJECT_ID