APPS.XLA_00201_AAD_S_000005_BC_PKG dependencies on PA_XLA_BC_PKT_REQ_HEADER_V

Line 58386: WHEN 1 THEN 'PA_XLA_BC_PKT_REQ_HEADER_V'

58382: FROM (
58383: SELECT xet.event_id event_id
58384: , 0 line_number
58385: , CASE r
58386: WHEN 1 THEN 'PA_XLA_BC_PKT_REQ_HEADER_V'
58387:
58388: ELSE null
58389: END object_name
58390: , CASE r

Line 58413: , PA_XLA_BC_PKT_REQ_HEADER_V h2

58409: ELSE null
58410: END source_value
58411: , null source_meaning
58412: FROM xla_events_gt xet
58413: , PA_XLA_BC_PKT_REQ_HEADER_V h2
58414: ,(select rownum r from all_objects where rownum <= 1 and owner = p_apps_owner)
58415: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58416: AND xet.event_class_code = C_EVENT_CLASS_CODE
58417: AND h2.event_id = xet.event_id

Line 58859: TYPE t_array_source_79 IS TABLE OF PA_XLA_BC_PKT_REQ_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

58855: --
58856: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
58857: --
58858:
58859: TYPE t_array_source_79 IS TABLE OF PA_XLA_BC_PKT_REQ_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
58860:
58861: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;
58862: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NAME%TYPE INDEX BY BINARY_INTEGER;
58863: TYPE t_array_source_5 IS TABLE OF PA_XLA_BC_PKT_REQ_DETAIL_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 58977: , PA_XLA_BC_PKT_REQ_HEADER_V h2

58973: ,xet.event_created_by
58974: ,xet.budgetary_control_flag
58975: , h2.GL_DATE source_79
58976: FROM xla_events_gt xet
58977: , PA_XLA_BC_PKT_REQ_HEADER_V h2
58978: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
58979: and xet.event_class_code = C_EVENT_CLASS_CODE
58980: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
58981: