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_00201_AAD_S_000004_BC_PKG dependencies on PO_EXTRACT_DETAIL_V

Line 47351: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'

47347: FROM (
47348: SELECT xet.event_id event_id
47349: , l3.line_number line_number
47350: , CASE r
47351: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
47352: WHEN 2 THEN 'FV_XLA_PO_REF_V'
47353: WHEN 3 THEN 'FV_XLA_PO_REF_V'
47354: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
47355: WHEN 5 THEN 'FV_XLA_PO_REF_V'

Line 47354: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'

47350: , CASE r
47351: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
47352: WHEN 2 THEN 'FV_XLA_PO_REF_V'
47353: WHEN 3 THEN 'FV_XLA_PO_REF_V'
47354: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
47355: WHEN 5 THEN 'FV_XLA_PO_REF_V'
47356: WHEN 6 THEN 'FV_XLA_PO_REF_V'
47357: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
47358: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'

Line 47357: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'

47353: WHEN 3 THEN 'FV_XLA_PO_REF_V'
47354: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
47355: WHEN 5 THEN 'FV_XLA_PO_REF_V'
47356: WHEN 6 THEN 'FV_XLA_PO_REF_V'
47357: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
47358: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
47359: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
47360: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
47361: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'

Line 47358: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'

47354: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
47355: WHEN 5 THEN 'FV_XLA_PO_REF_V'
47356: WHEN 6 THEN 'FV_XLA_PO_REF_V'
47357: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
47358: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
47359: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
47360: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
47361: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
47362: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'

Line 47359: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'

47355: WHEN 5 THEN 'FV_XLA_PO_REF_V'
47356: WHEN 6 THEN 'FV_XLA_PO_REF_V'
47357: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
47358: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
47359: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
47360: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
47361: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
47362: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
47363: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'

Line 47360: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'

47356: WHEN 6 THEN 'FV_XLA_PO_REF_V'
47357: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
47358: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
47359: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
47360: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
47361: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
47362: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
47363: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
47364: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'

Line 47361: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'

47357: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
47358: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
47359: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
47360: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
47361: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
47362: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
47363: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
47364: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
47365: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'

Line 47362: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'

47358: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
47359: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
47360: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
47361: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
47362: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
47363: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
47364: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
47365: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
47366: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'

Line 47363: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'

47359: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
47360: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
47361: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
47362: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
47363: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
47364: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
47365: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
47366: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
47367: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'

Line 47364: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'

47360: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
47361: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
47362: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
47363: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
47364: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
47365: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
47366: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
47367: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
47368: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'

Line 47365: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'

47361: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
47362: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
47363: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
47364: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
47365: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
47366: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
47367: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
47368: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
47369: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'

Line 47366: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'

47362: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
47363: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
47364: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
47365: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
47366: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
47367: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
47368: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
47369: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
47370: WHEN 20 THEN 'PO_EXTRACT_DETAIL_V'

Line 47367: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'

47363: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
47364: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
47365: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
47366: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
47367: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
47368: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
47369: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
47370: WHEN 20 THEN 'PO_EXTRACT_DETAIL_V'
47371: WHEN 21 THEN 'FV_XLA_PO_REF_V'

Line 47368: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'

47364: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
47365: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
47366: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
47367: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
47368: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
47369: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
47370: WHEN 20 THEN 'PO_EXTRACT_DETAIL_V'
47371: WHEN 21 THEN 'FV_XLA_PO_REF_V'
47372: WHEN 22 THEN 'PO_EXTRACT_DETAIL_V'

Line 47369: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'

47365: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
47366: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
47367: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
47368: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
47369: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
47370: WHEN 20 THEN 'PO_EXTRACT_DETAIL_V'
47371: WHEN 21 THEN 'FV_XLA_PO_REF_V'
47372: WHEN 22 THEN 'PO_EXTRACT_DETAIL_V'
47373: WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'

Line 47370: WHEN 20 THEN 'PO_EXTRACT_DETAIL_V'

47366: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
47367: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
47368: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
47369: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
47370: WHEN 20 THEN 'PO_EXTRACT_DETAIL_V'
47371: WHEN 21 THEN 'FV_XLA_PO_REF_V'
47372: WHEN 22 THEN 'PO_EXTRACT_DETAIL_V'
47373: WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'
47374: WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'

Line 47372: WHEN 22 THEN 'PO_EXTRACT_DETAIL_V'

47368: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
47369: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
47370: WHEN 20 THEN 'PO_EXTRACT_DETAIL_V'
47371: WHEN 21 THEN 'FV_XLA_PO_REF_V'
47372: WHEN 22 THEN 'PO_EXTRACT_DETAIL_V'
47373: WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'
47374: WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'
47375: WHEN 25 THEN 'PO_EXTRACT_DETAIL_V'
47376: WHEN 26 THEN 'PO_DISTS_REF_V'

Line 47373: WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'

47369: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
47370: WHEN 20 THEN 'PO_EXTRACT_DETAIL_V'
47371: WHEN 21 THEN 'FV_XLA_PO_REF_V'
47372: WHEN 22 THEN 'PO_EXTRACT_DETAIL_V'
47373: WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'
47374: WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'
47375: WHEN 25 THEN 'PO_EXTRACT_DETAIL_V'
47376: WHEN 26 THEN 'PO_DISTS_REF_V'
47377: WHEN 27 THEN 'PO_DISTS_REF_V'

Line 47374: WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'

47370: WHEN 20 THEN 'PO_EXTRACT_DETAIL_V'
47371: WHEN 21 THEN 'FV_XLA_PO_REF_V'
47372: WHEN 22 THEN 'PO_EXTRACT_DETAIL_V'
47373: WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'
47374: WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'
47375: WHEN 25 THEN 'PO_EXTRACT_DETAIL_V'
47376: WHEN 26 THEN 'PO_DISTS_REF_V'
47377: WHEN 27 THEN 'PO_DISTS_REF_V'
47378: WHEN 28 THEN 'PO_DISTS_REF_V'

Line 47375: WHEN 25 THEN 'PO_EXTRACT_DETAIL_V'

47371: WHEN 21 THEN 'FV_XLA_PO_REF_V'
47372: WHEN 22 THEN 'PO_EXTRACT_DETAIL_V'
47373: WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'
47374: WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'
47375: WHEN 25 THEN 'PO_EXTRACT_DETAIL_V'
47376: WHEN 26 THEN 'PO_DISTS_REF_V'
47377: WHEN 27 THEN 'PO_DISTS_REF_V'
47378: WHEN 28 THEN 'PO_DISTS_REF_V'
47379: WHEN 29 THEN 'FV_XLA_PO_REF_V'

Line 47530: , PO_EXTRACT_DETAIL_V l3

47526: , null source_meaning
47527: FROM xla_events_gt xet
47528: , FV_XLA_PO_REF_V l1
47529: , PO_DISTS_REF_V l2
47530: , PO_EXTRACT_DETAIL_V l3
47531: , (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
47532: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
47533: AND xet.event_class_code = C_EVENT_CLASS_CODE
47534: AND l3.event_id = xet.event_id

Line 47672: TYPE t_array_source_3 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

47668: TYPE t_array_source_20 IS TABLE OF PO_EXTRACT_HEADER_V.PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
47669: TYPE t_array_source_48 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
47670: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
47671:
47672: TYPE t_array_source_3 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
47673: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
47674: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
47675: TYPE t_array_source_9 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
47676: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 47675: TYPE t_array_source_9 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

47671:
47672: TYPE t_array_source_3 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
47673: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
47674: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
47675: TYPE t_array_source_9 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
47676: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
47677: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
47678: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
47679: TYPE t_array_source_14 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 47678: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;

47674: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
47675: TYPE t_array_source_9 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
47676: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
47677: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
47678: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
47679: TYPE t_array_source_14 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
47680: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
47681: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
47682: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 47679: TYPE t_array_source_14 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

47675: TYPE t_array_source_9 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
47676: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
47677: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
47678: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
47679: TYPE t_array_source_14 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
47680: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
47681: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
47682: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
47683: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 47680: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

47676: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
47677: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
47678: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
47679: TYPE t_array_source_14 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
47680: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
47681: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
47682: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
47683: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
47684: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 47681: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

47677: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
47678: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
47679: TYPE t_array_source_14 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
47680: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
47681: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
47682: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
47683: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
47684: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
47685: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 47682: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

47678: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
47679: TYPE t_array_source_14 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
47680: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
47681: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
47682: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
47683: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
47684: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
47685: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
47686: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

Line 47683: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

47679: TYPE t_array_source_14 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
47680: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
47681: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
47682: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
47683: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
47684: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
47685: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
47686: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
47687: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;

Line 47684: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

47680: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
47681: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
47682: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
47683: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
47684: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
47685: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
47686: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
47687: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
47688: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 47685: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

47681: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
47682: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
47683: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
47684: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
47685: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
47686: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
47687: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
47688: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
47689: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 47686: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

47682: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
47683: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
47684: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
47685: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
47686: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
47687: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
47688: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
47689: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
47690: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 47687: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;

47683: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
47684: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
47685: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
47686: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
47687: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
47688: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
47689: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
47690: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
47691: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 47688: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;

47684: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
47685: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
47686: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
47687: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
47688: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
47689: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
47690: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
47691: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
47692: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 47689: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

47685: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
47686: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
47687: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
47688: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
47689: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
47690: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
47691: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
47692: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
47693: TYPE t_array_source_31 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;

Line 47690: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;

47686: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
47687: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
47688: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
47689: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
47690: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
47691: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
47692: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
47693: TYPE t_array_source_31 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
47694: TYPE t_array_source_32 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 47691: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

47687: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
47688: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
47689: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
47690: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
47691: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
47692: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
47693: TYPE t_array_source_31 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
47694: TYPE t_array_source_32 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
47695: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 47693: TYPE t_array_source_31 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;

47689: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
47690: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
47691: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
47692: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
47693: TYPE t_array_source_31 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
47694: TYPE t_array_source_32 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
47695: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
47696: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
47697: TYPE t_array_source_35 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 47694: TYPE t_array_source_32 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

47690: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
47691: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
47692: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
47693: TYPE t_array_source_31 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
47694: TYPE t_array_source_32 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
47695: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
47696: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
47697: TYPE t_array_source_35 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
47698: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 47695: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

47691: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
47692: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
47693: TYPE t_array_source_31 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
47694: TYPE t_array_source_32 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
47695: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
47696: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
47697: TYPE t_array_source_35 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
47698: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
47699: TYPE t_array_source_37 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 47696: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

47692: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
47693: TYPE t_array_source_31 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
47694: TYPE t_array_source_32 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
47695: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
47696: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
47697: TYPE t_array_source_35 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
47698: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
47699: TYPE t_array_source_37 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
47700: TYPE t_array_source_38 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PYA_DIFF_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 47850: , PO_EXTRACT_DETAIL_V l3

47846: , l1.FEDERAL_PYA_AMT source_40
47847: FROM xla_events_gt xet
47848: , FV_XLA_PO_REF_V l1
47849: , PO_DISTS_REF_V l2
47850: , PO_EXTRACT_DETAIL_V l3
47851: WHERE xet.event_id between x_first_event_id and x_last_event_id
47852: and xet.event_date between p_pad_start_date and p_pad_end_date
47853: and xet.event_class_code = C_EVENT_CLASS_CODE
47854: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 50156: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'

50152: FROM (
50153: SELECT xet.event_id event_id
50154: , l3.line_number line_number
50155: , CASE r
50156: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
50157: WHEN 2 THEN 'FV_XLA_PO_REF_V'
50158: WHEN 3 THEN 'FV_XLA_PO_REF_V'
50159: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
50160: WHEN 5 THEN 'FV_XLA_PO_REF_V'

Line 50159: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'

50155: , CASE r
50156: WHEN 1 THEN 'PO_EXTRACT_DETAIL_V'
50157: WHEN 2 THEN 'FV_XLA_PO_REF_V'
50158: WHEN 3 THEN 'FV_XLA_PO_REF_V'
50159: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
50160: WHEN 5 THEN 'FV_XLA_PO_REF_V'
50161: WHEN 6 THEN 'FV_XLA_PO_REF_V'
50162: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
50163: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'

Line 50162: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'

50158: WHEN 3 THEN 'FV_XLA_PO_REF_V'
50159: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
50160: WHEN 5 THEN 'FV_XLA_PO_REF_V'
50161: WHEN 6 THEN 'FV_XLA_PO_REF_V'
50162: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
50163: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
50164: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
50165: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
50166: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'

Line 50163: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'

50159: WHEN 4 THEN 'PO_EXTRACT_DETAIL_V'
50160: WHEN 5 THEN 'FV_XLA_PO_REF_V'
50161: WHEN 6 THEN 'FV_XLA_PO_REF_V'
50162: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
50163: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
50164: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
50165: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
50166: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
50167: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'

Line 50164: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'

50160: WHEN 5 THEN 'FV_XLA_PO_REF_V'
50161: WHEN 6 THEN 'FV_XLA_PO_REF_V'
50162: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
50163: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
50164: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
50165: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
50166: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
50167: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
50168: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'

Line 50165: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'

50161: WHEN 6 THEN 'FV_XLA_PO_REF_V'
50162: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
50163: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
50164: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
50165: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
50166: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
50167: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
50168: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
50169: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'

Line 50166: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'

50162: WHEN 7 THEN 'PO_EXTRACT_DETAIL_V'
50163: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
50164: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
50165: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
50166: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
50167: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
50168: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
50169: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
50170: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'

Line 50167: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'

50163: WHEN 8 THEN 'PO_EXTRACT_DETAIL_V'
50164: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
50165: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
50166: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
50167: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
50168: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
50169: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
50170: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
50171: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'

Line 50168: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'

50164: WHEN 9 THEN 'PO_EXTRACT_DETAIL_V'
50165: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
50166: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
50167: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
50168: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
50169: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
50170: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
50171: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
50172: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'

Line 50169: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'

50165: WHEN 10 THEN 'PO_EXTRACT_DETAIL_V'
50166: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
50167: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
50168: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
50169: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
50170: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
50171: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
50172: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
50173: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'

Line 50170: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'

50166: WHEN 11 THEN 'PO_EXTRACT_DETAIL_V'
50167: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
50168: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
50169: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
50170: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
50171: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
50172: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
50173: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
50174: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'

Line 50171: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'

50167: WHEN 12 THEN 'PO_EXTRACT_DETAIL_V'
50168: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
50169: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
50170: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
50171: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
50172: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
50173: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
50174: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
50175: WHEN 20 THEN 'FV_XLA_PO_REF_V'

Line 50172: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'

50168: WHEN 13 THEN 'PO_EXTRACT_DETAIL_V'
50169: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
50170: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
50171: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
50172: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
50173: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
50174: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
50175: WHEN 20 THEN 'FV_XLA_PO_REF_V'
50176: WHEN 21 THEN 'PO_EXTRACT_DETAIL_V'

Line 50173: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'

50169: WHEN 14 THEN 'PO_EXTRACT_DETAIL_V'
50170: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
50171: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
50172: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
50173: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
50174: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
50175: WHEN 20 THEN 'FV_XLA_PO_REF_V'
50176: WHEN 21 THEN 'PO_EXTRACT_DETAIL_V'
50177: WHEN 22 THEN 'PO_EXTRACT_DETAIL_V'

Line 50174: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'

50170: WHEN 15 THEN 'PO_EXTRACT_DETAIL_V'
50171: WHEN 16 THEN 'PO_EXTRACT_DETAIL_V'
50172: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
50173: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
50174: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
50175: WHEN 20 THEN 'FV_XLA_PO_REF_V'
50176: WHEN 21 THEN 'PO_EXTRACT_DETAIL_V'
50177: WHEN 22 THEN 'PO_EXTRACT_DETAIL_V'
50178: WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'

Line 50176: WHEN 21 THEN 'PO_EXTRACT_DETAIL_V'

50172: WHEN 17 THEN 'PO_EXTRACT_DETAIL_V'
50173: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
50174: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
50175: WHEN 20 THEN 'FV_XLA_PO_REF_V'
50176: WHEN 21 THEN 'PO_EXTRACT_DETAIL_V'
50177: WHEN 22 THEN 'PO_EXTRACT_DETAIL_V'
50178: WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'
50179: WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'
50180: WHEN 25 THEN 'PO_DISTS_REF_V'

Line 50177: WHEN 22 THEN 'PO_EXTRACT_DETAIL_V'

50173: WHEN 18 THEN 'PO_EXTRACT_DETAIL_V'
50174: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
50175: WHEN 20 THEN 'FV_XLA_PO_REF_V'
50176: WHEN 21 THEN 'PO_EXTRACT_DETAIL_V'
50177: WHEN 22 THEN 'PO_EXTRACT_DETAIL_V'
50178: WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'
50179: WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'
50180: WHEN 25 THEN 'PO_DISTS_REF_V'
50181: WHEN 26 THEN 'PO_DISTS_REF_V'

Line 50178: WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'

50174: WHEN 19 THEN 'PO_EXTRACT_DETAIL_V'
50175: WHEN 20 THEN 'FV_XLA_PO_REF_V'
50176: WHEN 21 THEN 'PO_EXTRACT_DETAIL_V'
50177: WHEN 22 THEN 'PO_EXTRACT_DETAIL_V'
50178: WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'
50179: WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'
50180: WHEN 25 THEN 'PO_DISTS_REF_V'
50181: WHEN 26 THEN 'PO_DISTS_REF_V'
50182: WHEN 27 THEN 'PO_DISTS_REF_V'

Line 50179: WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'

50175: WHEN 20 THEN 'FV_XLA_PO_REF_V'
50176: WHEN 21 THEN 'PO_EXTRACT_DETAIL_V'
50177: WHEN 22 THEN 'PO_EXTRACT_DETAIL_V'
50178: WHEN 23 THEN 'PO_EXTRACT_DETAIL_V'
50179: WHEN 24 THEN 'PO_EXTRACT_DETAIL_V'
50180: WHEN 25 THEN 'PO_DISTS_REF_V'
50181: WHEN 26 THEN 'PO_DISTS_REF_V'
50182: WHEN 27 THEN 'PO_DISTS_REF_V'
50183: WHEN 28 THEN 'FV_XLA_PO_REF_V'

Line 50330: , PO_EXTRACT_DETAIL_V l3

50326: , null source_meaning
50327: FROM xla_events_gt xet
50328: , FV_XLA_PO_REF_V l1
50329: , PO_DISTS_REF_V l2
50330: , PO_EXTRACT_DETAIL_V l3
50331: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
50332: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
50333: AND xet.event_class_code = C_EVENT_CLASS_CODE
50334: AND l3.event_id = xet.event_id

Line 50473: TYPE t_array_source_3 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;

50469: TYPE t_array_source_41 IS TABLE OF PO_EXTRACT_HEADER_V.PO_RELEASE_ID%TYPE INDEX BY BINARY_INTEGER;
50470: TYPE t_array_source_48 IS TABLE OF PO_EXTRACT_HEADER_V.ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
50471: TYPE t_array_source_49 IS TABLE OF PO_EXTRACT_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
50472:
50473: TYPE t_array_source_3 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
50474: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
50475: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
50476: TYPE t_array_source_9 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
50477: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 50476: TYPE t_array_source_9 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

50472:
50473: TYPE t_array_source_3 IS TABLE OF PO_EXTRACT_DETAIL_V.JE_LINE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
50474: TYPE t_array_source_7 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
50475: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
50476: TYPE t_array_source_9 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
50477: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
50478: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
50479: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
50480: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 50479: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;

50475: TYPE t_array_source_8 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
50476: TYPE t_array_source_9 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
50477: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
50478: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
50479: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
50480: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
50481: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
50482: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
50483: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 50480: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

50476: TYPE t_array_source_9 IS TABLE OF PO_EXTRACT_DETAIL_V.BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
50477: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
50478: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
50479: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
50480: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
50481: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
50482: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
50483: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
50484: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 50481: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

50477: TYPE t_array_source_10 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
50478: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
50479: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
50480: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
50481: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
50482: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
50483: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
50484: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
50485: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 50482: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

50478: TYPE t_array_source_11 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_NET_PYA_ADJ_AMT%TYPE INDEX BY BINARY_INTEGER;
50479: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
50480: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
50481: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
50482: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
50483: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
50484: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
50485: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
50486: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

Line 50483: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

50479: TYPE t_array_source_13 IS TABLE OF PO_EXTRACT_DETAIL_V.MAIN_OR_BACKING_CODE%TYPE INDEX BY BINARY_INTEGER;
50480: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
50481: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
50482: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
50483: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
50484: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
50485: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
50486: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
50487: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;

Line 50484: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

50480: TYPE t_array_source_15 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTING_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
50481: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
50482: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
50483: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
50484: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
50485: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
50486: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
50487: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
50488: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 50485: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

50481: TYPE t_array_source_17 IS TABLE OF PO_EXTRACT_DETAIL_V.DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
50482: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
50483: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
50484: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
50485: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
50486: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
50487: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
50488: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
50489: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 50486: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

50482: TYPE t_array_source_19 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
50483: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
50484: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
50485: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
50486: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
50487: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
50488: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
50489: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
50490: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 50487: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;

50483: TYPE t_array_source_21 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
50484: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
50485: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
50486: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
50487: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
50488: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
50489: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
50490: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
50491: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 50488: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;

50484: TYPE t_array_source_22 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
50485: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
50486: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
50487: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
50488: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
50489: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
50490: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
50491: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
50492: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 50489: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

50485: TYPE t_array_source_23 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
50486: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
50487: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
50488: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
50489: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
50490: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
50491: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
50492: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
50493: TYPE t_array_source_31 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;

Line 50490: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;

50486: TYPE t_array_source_24 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
50487: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
50488: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
50489: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
50490: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
50491: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
50492: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
50493: TYPE t_array_source_31 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
50494: TYPE t_array_source_32 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 50491: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

50487: TYPE t_array_source_25 IS TABLE OF PO_EXTRACT_DETAIL_V.APPLIED_TO_HEADER_ID_1%TYPE INDEX BY BINARY_INTEGER;
50488: TYPE t_array_source_26 IS TABLE OF PO_EXTRACT_DETAIL_V.ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
50489: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
50490: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
50491: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
50492: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
50493: TYPE t_array_source_31 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
50494: TYPE t_array_source_32 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
50495: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 50493: TYPE t_array_source_31 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;

50489: TYPE t_array_source_27 IS TABLE OF PO_EXTRACT_DETAIL_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
50490: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
50491: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
50492: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
50493: TYPE t_array_source_31 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
50494: TYPE t_array_source_32 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
50495: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
50496: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
50497: TYPE t_array_source_35 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 50494: TYPE t_array_source_32 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

50490: TYPE t_array_source_28 IS TABLE OF PO_EXTRACT_DETAIL_V.ACCOUNTED_AMT%TYPE INDEX BY BINARY_INTEGER;
50491: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
50492: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
50493: TYPE t_array_source_31 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
50494: TYPE t_array_source_32 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
50495: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
50496: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
50497: TYPE t_array_source_35 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
50498: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 50495: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

50491: TYPE t_array_source_29 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
50492: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
50493: TYPE t_array_source_31 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
50494: TYPE t_array_source_32 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
50495: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
50496: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
50497: TYPE t_array_source_35 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
50498: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
50499: TYPE t_array_source_37 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 50496: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;

50492: TYPE t_array_source_30 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_UNANTICIPATED_AMT%TYPE INDEX BY BINARY_INTEGER;
50493: TYPE t_array_source_31 IS TABLE OF PO_EXTRACT_DETAIL_V.JFMIP_REFERENCE%TYPE INDEX BY BINARY_INTEGER;
50494: TYPE t_array_source_32 IS TABLE OF PO_EXTRACT_DETAIL_V.PO_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
50495: TYPE t_array_source_33 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
50496: TYPE t_array_source_34 IS TABLE OF PO_EXTRACT_DETAIL_V.ALLOC_TO_DIST_ID_1%TYPE INDEX BY BINARY_INTEGER;
50497: TYPE t_array_source_35 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
50498: TYPE t_array_source_36 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
50499: TYPE t_array_source_37 IS TABLE OF PO_DISTS_REF_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
50500: TYPE t_array_source_38 IS TABLE OF FV_XLA_PO_REF_V.FEDERAL_PYA_DIFF_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 50651: , PO_EXTRACT_DETAIL_V l3

50647: , l1.FEDERAL_PYA_AMT source_40
50648: FROM xla_events_gt xet
50649: , FV_XLA_PO_REF_V l1
50650: , PO_DISTS_REF_V l2
50651: , PO_EXTRACT_DETAIL_V l3
50652: WHERE xet.event_id between x_first_event_id and x_last_event_id
50653: and xet.event_date between p_pad_start_date and p_pad_end_date
50654: and xet.event_class_code = C_EVENT_CLASS_CODE
50655: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id