APPS.XLA_00275_AAD_S_000015_PKG dependencies on GMS_XLA_AWARD_REF_V

Line 95694: WHEN 1 THEN 'GMS_XLA_AWARD_REF_V'

95690: FROM (
95691: SELECT xet.event_id event_id
95692: , 0 line_number
95693: , CASE r
95694: WHEN 1 THEN 'GMS_XLA_AWARD_REF_V'
95695: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
95696: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
95697: WHEN 4 THEN 'PA_XLA_EXP_HEADER_V'
95698:

Line 95745: , GMS_XLA_AWARD_REF_V h1

95741:
95742: ELSE null
95743: END source_meaning
95744: FROM xla_events_gt xet
95745: , GMS_XLA_AWARD_REF_V h1
95746: , PA_XLA_EXP_HEADER_V h3
95747: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
95748: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
95749: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 96080: TYPE t_array_source_2 IS TABLE OF GMS_XLA_AWARD_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

96076: --
96077: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
96078: --
96079:
96080: TYPE t_array_source_2 IS TABLE OF GMS_XLA_AWARD_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
96081: TYPE t_array_source_22 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
96082: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
96083: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
96084:

Line 96163: , GMS_XLA_AWARD_REF_V h1

96159: , h3.EXCHANGE_RATE_VARIANCE_FLAG source_22
96160: , h3.EXPENDITURE_ITEM_ID source_33
96161: , h3.GL_DATE source_75
96162: FROM xla_events_gt xet
96163: , GMS_XLA_AWARD_REF_V h1
96164: , PA_XLA_EXP_HEADER_V h3
96165: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
96166: and xet.event_class_code = C_EVENT_CLASS_CODE
96167: and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id

Line 97255: WHEN 1 THEN 'GMS_XLA_AWARD_REF_V'

97251: FROM (
97252: SELECT xet.event_id event_id
97253: , 0 line_number
97254: , CASE r
97255: WHEN 1 THEN 'GMS_XLA_AWARD_REF_V'
97256: WHEN 2 THEN 'PA_XLA_EXP_HEADER_V'
97257: WHEN 3 THEN 'PA_XLA_EXP_HEADER_V'
97258: WHEN 4 THEN 'PA_XLA_EXP_HEADER_V'
97259:

Line 97306: , GMS_XLA_AWARD_REF_V h1

97302:
97303: ELSE null
97304: END source_meaning
97305: FROM xla_events_gt xet
97306: , GMS_XLA_AWARD_REF_V h1
97307: , PA_XLA_EXP_HEADER_V h3
97308: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
97309: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
97310: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 97641: TYPE t_array_source_2 IS TABLE OF GMS_XLA_AWARD_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

97637: --
97638: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
97639: --
97640:
97641: TYPE t_array_source_2 IS TABLE OF GMS_XLA_AWARD_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
97642: TYPE t_array_source_22 IS TABLE OF PA_XLA_EXP_HEADER_V.EXCHANGE_RATE_VARIANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
97643: TYPE t_array_source_33 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
97644: TYPE t_array_source_75 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
97645:

Line 97724: , GMS_XLA_AWARD_REF_V h1

97720: , h3.EXCHANGE_RATE_VARIANCE_FLAG source_22
97721: , h3.EXPENDITURE_ITEM_ID source_33
97722: , h3.GL_DATE source_75
97723: FROM xla_events_gt xet
97724: , GMS_XLA_AWARD_REF_V h1
97725: , PA_XLA_EXP_HEADER_V h3
97726: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
97727: and xet.event_class_code = C_EVENT_CLASS_CODE
97728: and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id