DBA Data[Home] [Help]

APPS.XLA_00201_AAD_S_000005_BC_PKG dependencies on PA_XLA_BC_PKT_PO_HEADER_V

Line 48475: WHEN 1 THEN 'PA_XLA_BC_PKT_PO_HEADER_V'

48471: FROM (
48472: SELECT xet.event_id event_id
48473: , 0 line_number
48474: , CASE r
48475: WHEN 1 THEN 'PA_XLA_BC_PKT_PO_HEADER_V'
48476:
48477: ELSE null
48478: END object_name
48479: , CASE r

Line 48502: , PA_XLA_BC_PKT_PO_HEADER_V h2

48498: ELSE null
48499: END source_value
48500: , null source_meaning
48501: FROM xla_events_gt xet
48502: , PA_XLA_BC_PKT_PO_HEADER_V h2
48503: ,(select rownum r from all_objects where rownum <= 1 and owner = p_apps_owner)
48504: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
48505: AND xet.event_class_code = C_EVENT_CLASS_CODE
48506: AND h2.event_id = xet.event_id

Line 48978: TYPE t_array_source_79 IS TABLE OF PA_XLA_BC_PKT_PO_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

48974: --
48975: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
48976: --
48977:
48978: TYPE t_array_source_79 IS TABLE OF PA_XLA_BC_PKT_PO_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
48979:
48980: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;
48981: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NAME%TYPE INDEX BY BINARY_INTEGER;
48982: TYPE t_array_source_5 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 49108: , PA_XLA_BC_PKT_PO_HEADER_V h2

49104: ,xet.event_created_by
49105: ,xet.budgetary_control_flag
49106: , h2.GL_DATE source_79
49107: FROM xla_events_gt xet
49108: , PA_XLA_BC_PKT_PO_HEADER_V h2
49109: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
49110: and xet.event_class_code = C_EVENT_CLASS_CODE
49111: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
49112:

Line 54419: WHEN 1 THEN 'PA_XLA_BC_PKT_PO_HEADER_V'

54415: FROM (
54416: SELECT xet.event_id event_id
54417: , 0 line_number
54418: , CASE r
54419: WHEN 1 THEN 'PA_XLA_BC_PKT_PO_HEADER_V'
54420:
54421: ELSE null
54422: END object_name
54423: , CASE r

Line 54446: , PA_XLA_BC_PKT_PO_HEADER_V h2

54442: ELSE null
54443: END source_value
54444: , null source_meaning
54445: FROM xla_events_gt xet
54446: , PA_XLA_BC_PKT_PO_HEADER_V h2
54447: ,(select rownum r from all_objects where rownum <= 1 and owner = p_apps_owner)
54448: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
54449: AND xet.event_class_code = C_EVENT_CLASS_CODE
54450: AND h2.event_id = xet.event_id

Line 54922: TYPE t_array_source_79 IS TABLE OF PA_XLA_BC_PKT_PO_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;

54918: --
54919: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
54920: --
54921:
54922: TYPE t_array_source_79 IS TABLE OF PA_XLA_BC_PKT_PO_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
54923:
54924: TYPE t_array_source_3 IS TABLE OF PA_XLA_PROJECT_REF_V.PROJECT_NAME%TYPE INDEX BY BINARY_INTEGER;
54925: TYPE t_array_source_4 IS TABLE OF PA_XLA_TASK_REF_V.TASK_NAME%TYPE INDEX BY BINARY_INTEGER;
54926: TYPE t_array_source_5 IS TABLE OF PA_XLA_BC_PKT_PO_DETAIL_V.EXPENDITURE_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 55052: , PA_XLA_BC_PKT_PO_HEADER_V h2

55048: ,xet.event_created_by
55049: ,xet.budgetary_control_flag
55050: , h2.GL_DATE source_79
55051: FROM xla_events_gt xet
55052: , PA_XLA_BC_PKT_PO_HEADER_V h2
55053: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
55054: and xet.event_class_code = C_EVENT_CLASS_CODE
55055: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
55056: