eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00707_AAD_S_000007_BC_PKG dependencies on FV_XLA_CST_REF_V

Line 29275: WHEN 1 THEN 'FV_XLA_CST_REF_V'

29271: FROM (
29272: SELECT xet.event_id event_id
29273: , l2.line_number line_number
29274: , CASE r
29275: WHEN 1 THEN 'FV_XLA_CST_REF_V'
29276: WHEN 2 THEN 'FV_XLA_CST_REF_V'
29277: WHEN 3 THEN 'FV_XLA_CST_REF_V'
29278: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
29279: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'

Line 29276: WHEN 2 THEN 'FV_XLA_CST_REF_V'

29272: SELECT xet.event_id event_id
29273: , l2.line_number line_number
29274: , CASE r
29275: WHEN 1 THEN 'FV_XLA_CST_REF_V'
29276: WHEN 2 THEN 'FV_XLA_CST_REF_V'
29277: WHEN 3 THEN 'FV_XLA_CST_REF_V'
29278: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
29279: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
29280: WHEN 6 THEN 'FV_XLA_CST_REF_V'

Line 29277: WHEN 3 THEN 'FV_XLA_CST_REF_V'

29273: , l2.line_number line_number
29274: , CASE r
29275: WHEN 1 THEN 'FV_XLA_CST_REF_V'
29276: WHEN 2 THEN 'FV_XLA_CST_REF_V'
29277: WHEN 3 THEN 'FV_XLA_CST_REF_V'
29278: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
29279: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
29280: WHEN 6 THEN 'FV_XLA_CST_REF_V'
29281: WHEN 7 THEN 'FV_XLA_CST_REF_V'

Line 29280: WHEN 6 THEN 'FV_XLA_CST_REF_V'

29276: WHEN 2 THEN 'FV_XLA_CST_REF_V'
29277: WHEN 3 THEN 'FV_XLA_CST_REF_V'
29278: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
29279: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
29280: WHEN 6 THEN 'FV_XLA_CST_REF_V'
29281: WHEN 7 THEN 'FV_XLA_CST_REF_V'
29282: WHEN 8 THEN 'CST_XLA_RCV_LINES_V'
29283: WHEN 9 THEN 'CST_XLA_RCV_LINES_V'
29284: WHEN 10 THEN 'FV_XLA_CST_REF_V'

Line 29281: WHEN 7 THEN 'FV_XLA_CST_REF_V'

29277: WHEN 3 THEN 'FV_XLA_CST_REF_V'
29278: WHEN 4 THEN 'CST_XLA_RCV_LINES_V'
29279: WHEN 5 THEN 'CST_XLA_RCV_LINES_V'
29280: WHEN 6 THEN 'FV_XLA_CST_REF_V'
29281: WHEN 7 THEN 'FV_XLA_CST_REF_V'
29282: WHEN 8 THEN 'CST_XLA_RCV_LINES_V'
29283: WHEN 9 THEN 'CST_XLA_RCV_LINES_V'
29284: WHEN 10 THEN 'FV_XLA_CST_REF_V'
29285: WHEN 11 THEN 'FV_XLA_CST_REF_V'

Line 29284: WHEN 10 THEN 'FV_XLA_CST_REF_V'

29280: WHEN 6 THEN 'FV_XLA_CST_REF_V'
29281: WHEN 7 THEN 'FV_XLA_CST_REF_V'
29282: WHEN 8 THEN 'CST_XLA_RCV_LINES_V'
29283: WHEN 9 THEN 'CST_XLA_RCV_LINES_V'
29284: WHEN 10 THEN 'FV_XLA_CST_REF_V'
29285: WHEN 11 THEN 'FV_XLA_CST_REF_V'
29286: WHEN 12 THEN 'FV_XLA_CST_REF_V'
29287: WHEN 13 THEN 'FV_XLA_CST_REF_V'
29288: WHEN 14 THEN 'FV_XLA_CST_REF_V'

Line 29285: WHEN 11 THEN 'FV_XLA_CST_REF_V'

29281: WHEN 7 THEN 'FV_XLA_CST_REF_V'
29282: WHEN 8 THEN 'CST_XLA_RCV_LINES_V'
29283: WHEN 9 THEN 'CST_XLA_RCV_LINES_V'
29284: WHEN 10 THEN 'FV_XLA_CST_REF_V'
29285: WHEN 11 THEN 'FV_XLA_CST_REF_V'
29286: WHEN 12 THEN 'FV_XLA_CST_REF_V'
29287: WHEN 13 THEN 'FV_XLA_CST_REF_V'
29288: WHEN 14 THEN 'FV_XLA_CST_REF_V'
29289:

Line 29286: WHEN 12 THEN 'FV_XLA_CST_REF_V'

29282: WHEN 8 THEN 'CST_XLA_RCV_LINES_V'
29283: WHEN 9 THEN 'CST_XLA_RCV_LINES_V'
29284: WHEN 10 THEN 'FV_XLA_CST_REF_V'
29285: WHEN 11 THEN 'FV_XLA_CST_REF_V'
29286: WHEN 12 THEN 'FV_XLA_CST_REF_V'
29287: WHEN 13 THEN 'FV_XLA_CST_REF_V'
29288: WHEN 14 THEN 'FV_XLA_CST_REF_V'
29289:
29290: ELSE null

Line 29287: WHEN 13 THEN 'FV_XLA_CST_REF_V'

29283: WHEN 9 THEN 'CST_XLA_RCV_LINES_V'
29284: WHEN 10 THEN 'FV_XLA_CST_REF_V'
29285: WHEN 11 THEN 'FV_XLA_CST_REF_V'
29286: WHEN 12 THEN 'FV_XLA_CST_REF_V'
29287: WHEN 13 THEN 'FV_XLA_CST_REF_V'
29288: WHEN 14 THEN 'FV_XLA_CST_REF_V'
29289:
29290: ELSE null
29291: END object_name

Line 29288: WHEN 14 THEN 'FV_XLA_CST_REF_V'

29284: WHEN 10 THEN 'FV_XLA_CST_REF_V'
29285: WHEN 11 THEN 'FV_XLA_CST_REF_V'
29286: WHEN 12 THEN 'FV_XLA_CST_REF_V'
29287: WHEN 13 THEN 'FV_XLA_CST_REF_V'
29288: WHEN 14 THEN 'FV_XLA_CST_REF_V'
29289:
29290: ELSE null
29291: END object_name
29292: , CASE r

Line 29368: , FV_XLA_CST_REF_V l4

29364: END source_value
29365: , null source_meaning
29366: FROM xla_events_gt xet
29367: , CST_XLA_RCV_LINES_V l2
29368: , FV_XLA_CST_REF_V l4
29369: , (select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
29370: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
29371: AND xet.event_class_code = C_EVENT_CLASS_CODE
29372: AND l2.event_id = xet.event_id

Line 29524: TYPE t_array_source_1 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

29520: TYPE t_array_source_22 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
29521: TYPE t_array_source_33 IS TABLE OF CST_XLA_RCV_REF_V.PARENT_TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
29522: TYPE t_array_source_36 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
29523:
29524: TYPE t_array_source_1 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
29525: TYPE t_array_source_2 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
29526: TYPE t_array_source_5 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
29527: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
29528: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 29525: TYPE t_array_source_2 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

29521: TYPE t_array_source_33 IS TABLE OF CST_XLA_RCV_REF_V.PARENT_TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
29522: TYPE t_array_source_36 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
29523:
29524: TYPE t_array_source_1 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
29525: TYPE t_array_source_2 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
29526: TYPE t_array_source_5 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
29527: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
29528: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
29529: TYPE t_array_source_18 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 29526: TYPE t_array_source_5 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

29522: TYPE t_array_source_36 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
29523:
29524: TYPE t_array_source_1 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
29525: TYPE t_array_source_2 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
29526: TYPE t_array_source_5 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
29527: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
29528: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
29529: TYPE t_array_source_18 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
29530: TYPE t_array_source_24 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 29529: TYPE t_array_source_18 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

29525: TYPE t_array_source_2 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
29526: TYPE t_array_source_5 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
29527: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
29528: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
29529: TYPE t_array_source_18 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
29530: TYPE t_array_source_24 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
29531: TYPE t_array_source_25 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29532: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29533: TYPE t_array_source_27 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 29530: TYPE t_array_source_24 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

29526: TYPE t_array_source_5 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
29527: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
29528: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
29529: TYPE t_array_source_18 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
29530: TYPE t_array_source_24 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
29531: TYPE t_array_source_25 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29532: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29533: TYPE t_array_source_27 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
29534: TYPE t_array_source_28 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 29533: TYPE t_array_source_27 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;

29529: TYPE t_array_source_18 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
29530: TYPE t_array_source_24 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
29531: TYPE t_array_source_25 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29532: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29533: TYPE t_array_source_27 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
29534: TYPE t_array_source_28 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
29535: TYPE t_array_source_29 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNPAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
29536: TYPE t_array_source_32 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_RCV_SUB_LEDGER_ID%TYPE INDEX BY BINARY_INTEGER;
29537: TYPE t_array_source_34 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 29534: TYPE t_array_source_28 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;

29530: TYPE t_array_source_24 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
29531: TYPE t_array_source_25 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29532: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29533: TYPE t_array_source_27 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
29534: TYPE t_array_source_28 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
29535: TYPE t_array_source_29 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNPAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
29536: TYPE t_array_source_32 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_RCV_SUB_LEDGER_ID%TYPE INDEX BY BINARY_INTEGER;
29537: TYPE t_array_source_34 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
29538:

Line 29535: TYPE t_array_source_29 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNPAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;

29531: TYPE t_array_source_25 IS TABLE OF CST_XLA_RCV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29532: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29533: TYPE t_array_source_27 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
29534: TYPE t_array_source_28 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
29535: TYPE t_array_source_29 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNPAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
29536: TYPE t_array_source_32 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_RCV_SUB_LEDGER_ID%TYPE INDEX BY BINARY_INTEGER;
29537: TYPE t_array_source_34 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
29538:
29539: l_array_source_3 t_array_source_3;

Line 29536: TYPE t_array_source_32 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_RCV_SUB_LEDGER_ID%TYPE INDEX BY BINARY_INTEGER;

29532: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29533: TYPE t_array_source_27 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
29534: TYPE t_array_source_28 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
29535: TYPE t_array_source_29 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNPAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
29536: TYPE t_array_source_32 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_RCV_SUB_LEDGER_ID%TYPE INDEX BY BINARY_INTEGER;
29537: TYPE t_array_source_34 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
29538:
29539: l_array_source_3 t_array_source_3;
29540: l_array_source_7 t_array_source_7;

Line 29537: TYPE t_array_source_34 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;

29533: TYPE t_array_source_27 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
29534: TYPE t_array_source_28 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
29535: TYPE t_array_source_29 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNPAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
29536: TYPE t_array_source_32 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_RCV_SUB_LEDGER_ID%TYPE INDEX BY BINARY_INTEGER;
29537: TYPE t_array_source_34 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
29538:
29539: l_array_source_3 t_array_source_3;
29540: l_array_source_7 t_array_source_7;
29541: l_array_source_8 t_array_source_8;

Line 29692: , FV_XLA_CST_REF_V l4

29688: , l4.FEDERAL_RCV_SUB_LEDGER_ID source_32
29689: , l4.FEDERAL_UNEXP_OBG_AMT source_34
29690: FROM xla_events_gt xet
29691: , CST_XLA_RCV_LINES_V l2
29692: , FV_XLA_CST_REF_V l4
29693: WHERE xet.event_id between x_first_event_id and x_last_event_id
29694: and xet.event_date between p_pad_start_date and p_pad_end_date
29695: and xet.event_class_code = C_EVENT_CLASS_CODE
29696: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 31401: WHEN 1 THEN 'FV_XLA_CST_REF_V'

31397: FROM (
31398: SELECT xet.event_id event_id
31399: , l2.line_number line_number
31400: , CASE r
31401: WHEN 1 THEN 'FV_XLA_CST_REF_V'
31402: WHEN 2 THEN 'FV_XLA_CST_REF_V'
31403: WHEN 3 THEN 'FV_XLA_CST_REF_V'
31404: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
31405: WHEN 5 THEN 'CST_XLA_INV_LINES_V'

Line 31402: WHEN 2 THEN 'FV_XLA_CST_REF_V'

31398: SELECT xet.event_id event_id
31399: , l2.line_number line_number
31400: , CASE r
31401: WHEN 1 THEN 'FV_XLA_CST_REF_V'
31402: WHEN 2 THEN 'FV_XLA_CST_REF_V'
31403: WHEN 3 THEN 'FV_XLA_CST_REF_V'
31404: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
31405: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
31406: WHEN 6 THEN 'FV_XLA_CST_REF_V'

Line 31403: WHEN 3 THEN 'FV_XLA_CST_REF_V'

31399: , l2.line_number line_number
31400: , CASE r
31401: WHEN 1 THEN 'FV_XLA_CST_REF_V'
31402: WHEN 2 THEN 'FV_XLA_CST_REF_V'
31403: WHEN 3 THEN 'FV_XLA_CST_REF_V'
31404: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
31405: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
31406: WHEN 6 THEN 'FV_XLA_CST_REF_V'
31407: WHEN 7 THEN 'CST_XLA_INV_LINES_V'

Line 31406: WHEN 6 THEN 'FV_XLA_CST_REF_V'

31402: WHEN 2 THEN 'FV_XLA_CST_REF_V'
31403: WHEN 3 THEN 'FV_XLA_CST_REF_V'
31404: WHEN 4 THEN 'CST_XLA_INV_LINES_V'
31405: WHEN 5 THEN 'CST_XLA_INV_LINES_V'
31406: WHEN 6 THEN 'FV_XLA_CST_REF_V'
31407: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
31408: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
31409: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
31410: WHEN 10 THEN 'FV_XLA_CST_REF_V'

Line 31410: WHEN 10 THEN 'FV_XLA_CST_REF_V'

31406: WHEN 6 THEN 'FV_XLA_CST_REF_V'
31407: WHEN 7 THEN 'CST_XLA_INV_LINES_V'
31408: WHEN 8 THEN 'CST_XLA_INV_LINES_V'
31409: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
31410: WHEN 10 THEN 'FV_XLA_CST_REF_V'
31411: WHEN 11 THEN 'CST_XLA_INV_LINES_V'
31412: WHEN 12 THEN 'CST_XLA_INV_LINES_V'
31413: WHEN 13 THEN 'FV_XLA_CST_REF_V'
31414: WHEN 14 THEN 'FV_XLA_CST_REF_V'

Line 31413: WHEN 13 THEN 'FV_XLA_CST_REF_V'

31409: WHEN 9 THEN 'CST_XLA_INV_LINES_V'
31410: WHEN 10 THEN 'FV_XLA_CST_REF_V'
31411: WHEN 11 THEN 'CST_XLA_INV_LINES_V'
31412: WHEN 12 THEN 'CST_XLA_INV_LINES_V'
31413: WHEN 13 THEN 'FV_XLA_CST_REF_V'
31414: WHEN 14 THEN 'FV_XLA_CST_REF_V'
31415: WHEN 15 THEN 'FV_XLA_CST_REF_V'
31416: WHEN 16 THEN 'FV_XLA_CST_REF_V'
31417: WHEN 17 THEN 'FV_XLA_CST_REF_V'

Line 31414: WHEN 14 THEN 'FV_XLA_CST_REF_V'

31410: WHEN 10 THEN 'FV_XLA_CST_REF_V'
31411: WHEN 11 THEN 'CST_XLA_INV_LINES_V'
31412: WHEN 12 THEN 'CST_XLA_INV_LINES_V'
31413: WHEN 13 THEN 'FV_XLA_CST_REF_V'
31414: WHEN 14 THEN 'FV_XLA_CST_REF_V'
31415: WHEN 15 THEN 'FV_XLA_CST_REF_V'
31416: WHEN 16 THEN 'FV_XLA_CST_REF_V'
31417: WHEN 17 THEN 'FV_XLA_CST_REF_V'
31418:

Line 31415: WHEN 15 THEN 'FV_XLA_CST_REF_V'

31411: WHEN 11 THEN 'CST_XLA_INV_LINES_V'
31412: WHEN 12 THEN 'CST_XLA_INV_LINES_V'
31413: WHEN 13 THEN 'FV_XLA_CST_REF_V'
31414: WHEN 14 THEN 'FV_XLA_CST_REF_V'
31415: WHEN 15 THEN 'FV_XLA_CST_REF_V'
31416: WHEN 16 THEN 'FV_XLA_CST_REF_V'
31417: WHEN 17 THEN 'FV_XLA_CST_REF_V'
31418:
31419: ELSE null

Line 31416: WHEN 16 THEN 'FV_XLA_CST_REF_V'

31412: WHEN 12 THEN 'CST_XLA_INV_LINES_V'
31413: WHEN 13 THEN 'FV_XLA_CST_REF_V'
31414: WHEN 14 THEN 'FV_XLA_CST_REF_V'
31415: WHEN 15 THEN 'FV_XLA_CST_REF_V'
31416: WHEN 16 THEN 'FV_XLA_CST_REF_V'
31417: WHEN 17 THEN 'FV_XLA_CST_REF_V'
31418:
31419: ELSE null
31420: END object_name

Line 31417: WHEN 17 THEN 'FV_XLA_CST_REF_V'

31413: WHEN 13 THEN 'FV_XLA_CST_REF_V'
31414: WHEN 14 THEN 'FV_XLA_CST_REF_V'
31415: WHEN 15 THEN 'FV_XLA_CST_REF_V'
31416: WHEN 16 THEN 'FV_XLA_CST_REF_V'
31417: WHEN 17 THEN 'FV_XLA_CST_REF_V'
31418:
31419: ELSE null
31420: END object_name
31421: , CASE r

Line 31509: , FV_XLA_CST_REF_V l4

31505: END source_value
31506: , null source_meaning
31507: FROM xla_events_gt xet
31508: , CST_XLA_INV_LINES_V l2
31509: , FV_XLA_CST_REF_V l4
31510: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
31511: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
31512: AND xet.event_class_code = C_EVENT_CLASS_CODE
31513: AND l2.event_id = xet.event_id

Line 31661: TYPE t_array_source_1 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

31657: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
31658: TYPE t_array_source_33 IS TABLE OF CST_XLA_INV_REF_V.PARENT_TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
31659: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
31660:
31661: TYPE t_array_source_1 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
31662: TYPE t_array_source_2 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
31663: TYPE t_array_source_5 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
31664: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
31665: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 31662: TYPE t_array_source_2 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

31658: TYPE t_array_source_33 IS TABLE OF CST_XLA_INV_REF_V.PARENT_TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
31659: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
31660:
31661: TYPE t_array_source_1 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
31662: TYPE t_array_source_2 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
31663: TYPE t_array_source_5 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
31664: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
31665: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
31666: TYPE t_array_source_18 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 31663: TYPE t_array_source_5 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

31659: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
31660:
31661: TYPE t_array_source_1 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
31662: TYPE t_array_source_2 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
31663: TYPE t_array_source_5 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
31664: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
31665: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
31666: TYPE t_array_source_18 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
31667: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 31666: TYPE t_array_source_18 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

31662: TYPE t_array_source_2 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
31663: TYPE t_array_source_5 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
31664: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
31665: TYPE t_array_source_15 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
31666: TYPE t_array_source_18 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
31667: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
31668: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
31669: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31670: TYPE t_array_source_24 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 31670: TYPE t_array_source_24 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

31666: TYPE t_array_source_18 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_ANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
31667: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
31668: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
31669: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31670: TYPE t_array_source_24 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
31671: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31672: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31673: TYPE t_array_source_27 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
31674: TYPE t_array_source_28 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 31673: TYPE t_array_source_27 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;

31669: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31670: TYPE t_array_source_24 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
31671: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31672: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31673: TYPE t_array_source_27 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
31674: TYPE t_array_source_28 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
31675: TYPE t_array_source_29 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNPAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
31676: TYPE t_array_source_32 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_RCV_SUB_LEDGER_ID%TYPE INDEX BY BINARY_INTEGER;
31677: TYPE t_array_source_34 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 31674: TYPE t_array_source_28 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;

31670: TYPE t_array_source_24 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
31671: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31672: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31673: TYPE t_array_source_27 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
31674: TYPE t_array_source_28 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
31675: TYPE t_array_source_29 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNPAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
31676: TYPE t_array_source_32 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_RCV_SUB_LEDGER_ID%TYPE INDEX BY BINARY_INTEGER;
31677: TYPE t_array_source_34 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
31678:

Line 31675: TYPE t_array_source_29 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNPAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;

31671: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31672: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31673: TYPE t_array_source_27 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
31674: TYPE t_array_source_28 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
31675: TYPE t_array_source_29 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNPAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
31676: TYPE t_array_source_32 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_RCV_SUB_LEDGER_ID%TYPE INDEX BY BINARY_INTEGER;
31677: TYPE t_array_source_34 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
31678:
31679: l_array_source_3 t_array_source_3;

Line 31676: TYPE t_array_source_32 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_RCV_SUB_LEDGER_ID%TYPE INDEX BY BINARY_INTEGER;

31672: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31673: TYPE t_array_source_27 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
31674: TYPE t_array_source_28 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
31675: TYPE t_array_source_29 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNPAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
31676: TYPE t_array_source_32 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_RCV_SUB_LEDGER_ID%TYPE INDEX BY BINARY_INTEGER;
31677: TYPE t_array_source_34 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
31678:
31679: l_array_source_3 t_array_source_3;
31680: l_array_source_7 t_array_source_7;

Line 31677: TYPE t_array_source_34 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;

31673: TYPE t_array_source_27 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
31674: TYPE t_array_source_28 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_PAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
31675: TYPE t_array_source_29 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNPAID_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
31676: TYPE t_array_source_32 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_RCV_SUB_LEDGER_ID%TYPE INDEX BY BINARY_INTEGER;
31677: TYPE t_array_source_34 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_UNEXP_OBG_AMT%TYPE INDEX BY BINARY_INTEGER;
31678:
31679: l_array_source_3 t_array_source_3;
31680: l_array_source_7 t_array_source_7;
31681: l_array_source_8 t_array_source_8;

Line 31830: , FV_XLA_CST_REF_V l4

31826: , l4.FEDERAL_RCV_SUB_LEDGER_ID source_32
31827: , l4.FEDERAL_UNEXP_OBG_AMT source_34
31828: FROM xla_events_gt xet
31829: , CST_XLA_INV_LINES_V l2
31830: , FV_XLA_CST_REF_V l4
31831: WHERE xet.event_id between x_first_event_id and x_last_event_id
31832: and xet.event_date between p_pad_start_date and p_pad_end_date
31833: and xet.event_class_code = C_EVENT_CLASS_CODE
31834: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id