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_00275_AAD_S_000004_PKG dependencies on PA_XLA_REVENUE_LINES_ADJ_V

Line 73200: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73196: FROM (
73197: SELECT xet.event_id event_id
73198: , l3.line_number line_number
73199: , CASE r
73200: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73201: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73202: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73203: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73204: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73201: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73197: SELECT xet.event_id event_id
73198: , l3.line_number line_number
73199: , CASE r
73200: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73201: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73202: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73203: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73204: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73205: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73202: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73198: , l3.line_number line_number
73199: , CASE r
73200: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73201: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73202: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73203: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73204: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73205: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73206: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73203: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73199: , CASE r
73200: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73201: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73202: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73203: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73204: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73205: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73206: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73207: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73204: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73200: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73201: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73202: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73203: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73204: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73205: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73206: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73207: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73208: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73205: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73201: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73202: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73203: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73204: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73205: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73206: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73207: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73208: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73209: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73206: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73202: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73203: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73204: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73205: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73206: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73207: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73208: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73209: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73210: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73207: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73203: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73204: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73205: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73206: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73207: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73208: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73209: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73210: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73211: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73208: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73204: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73205: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73206: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73207: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73208: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73209: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73210: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73211: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73212: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73209: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73205: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73206: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73207: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73208: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73209: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73210: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73211: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73212: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73213: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73210: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73206: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73207: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73208: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73209: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73210: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73211: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73212: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73213: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73214: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'

Line 73211: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73207: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73208: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73209: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73210: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73211: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73212: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73213: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73214: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'
73215: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73212: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73208: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73209: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73210: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73211: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73212: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73213: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73214: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'
73215: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73216: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73213: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73209: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73210: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73211: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73212: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73213: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73214: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'
73215: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73216: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73217: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73215: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73211: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73212: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73213: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73214: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'
73215: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73216: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73217: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73218: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73219: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73216: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73212: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73213: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73214: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'
73215: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73216: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73217: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73218: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73219: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73220: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73217: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73213: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73214: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'
73215: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73216: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73217: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73218: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73219: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73220: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73221: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73218: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73214: WHEN 15 THEN 'PA_XLA_EVENT_TYPE_REF_V'
73215: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73216: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73217: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73218: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73219: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73220: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73221: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73222: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 73219: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73215: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73216: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73217: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73218: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73219: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73220: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73221: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73222: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73223:

Line 73220: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73216: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73217: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73218: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73219: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73220: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73221: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73222: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73223:
73224: ELSE null

Line 73221: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73217: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73218: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73219: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73220: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73221: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73222: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73223:
73224: ELSE null
73225: END object_name

Line 73222: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

73218: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73219: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73220: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73221: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73222: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
73223:
73224: ELSE null
73225: END object_name
73226: , CASE r

Line 73342: , PA_XLA_REVENUE_LINES_ADJ_V l3

73338: ELSE null
73339: END source_meaning
73340: FROM xla_events_gt xet
73341: , PA_XLA_EVENT_TYPE_REF_V l1
73342: , PA_XLA_REVENUE_LINES_ADJ_V l3
73343: , fnd_lookup_values fvl58
73344: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
73345: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73346: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 73489: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

73485: TYPE t_array_source_87 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
73486: TYPE t_array_source_91 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73487: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73488:
73489: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73490: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73491: TYPE t_array_source_23 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73492: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73493: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 73490: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;

73486: TYPE t_array_source_91 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73487: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73488:
73489: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73490: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73491: TYPE t_array_source_23 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73492: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73493: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
73494: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 73491: TYPE t_array_source_23 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

73487: TYPE t_array_source_92 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73488:
73489: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73490: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73491: TYPE t_array_source_23 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73492: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73493: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
73494: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
73495: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 73492: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

73488:
73489: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73490: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73491: TYPE t_array_source_23 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73492: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73493: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
73494: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
73495: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73496: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 73493: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

73489: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
73490: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73491: TYPE t_array_source_23 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73492: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73493: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
73494: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
73495: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73496: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73497: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 73494: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

73490: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
73491: TYPE t_array_source_23 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73492: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73493: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
73494: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
73495: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73496: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73497: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
73498: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 73495: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

73491: TYPE t_array_source_23 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73492: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73493: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
73494: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
73495: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73496: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73497: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
73498: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73499: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73496: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

73492: TYPE t_array_source_25 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73493: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
73494: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
73495: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73496: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73497: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
73498: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73499: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73500: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73497: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

73493: TYPE t_array_source_27 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
73494: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
73495: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73496: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73497: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
73498: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73499: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73500: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73501: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 73498: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

73494: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
73495: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73496: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73497: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
73498: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73499: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73500: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73501: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73502: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 73499: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

73495: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73496: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73497: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
73498: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73499: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73500: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73501: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73502: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73503: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;

Line 73500: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

73496: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73497: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
73498: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73499: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73500: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73501: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73502: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73503: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
73504: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 73501: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

73497: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
73498: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73499: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73500: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73501: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73502: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73503: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
73504: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
73505: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 73502: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

73498: TYPE t_array_source_36 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73499: TYPE t_array_source_39 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73500: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73501: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73502: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73503: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
73504: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
73505: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
73506: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73504: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;

73500: TYPE t_array_source_40 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73501: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73502: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73503: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
73504: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
73505: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
73506: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
73507: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
73508: TYPE t_array_source_63 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73505: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;

73501: TYPE t_array_source_41 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73502: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73503: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
73504: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
73505: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
73506: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
73507: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
73508: TYPE t_array_source_63 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73509: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73506: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;

73502: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
73503: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
73504: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
73505: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
73506: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
73507: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
73508: TYPE t_array_source_63 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73509: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
73510: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 73507: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

73503: TYPE t_array_source_58 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
73504: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
73505: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
73506: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
73507: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
73508: TYPE t_array_source_63 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73509: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
73510: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73511: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_DRAFT_REV_NUM_CREDITED%TYPE INDEX BY BINARY_INTEGER;

Line 73508: TYPE t_array_source_63 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

73504: TYPE t_array_source_59 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
73505: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
73506: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
73507: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
73508: TYPE t_array_source_63 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73509: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
73510: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73511: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_DRAFT_REV_NUM_CREDITED%TYPE INDEX BY BINARY_INTEGER;
73512:

Line 73509: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;

73505: TYPE t_array_source_60 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
73506: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
73507: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
73508: TYPE t_array_source_63 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73509: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
73510: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73511: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_DRAFT_REV_NUM_CREDITED%TYPE INDEX BY BINARY_INTEGER;
73512:
73513: l_array_source_38 t_array_source_38;

Line 73510: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

73506: TYPE t_array_source_61 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
73507: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
73508: TYPE t_array_source_63 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73509: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
73510: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73511: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_DRAFT_REV_NUM_CREDITED%TYPE INDEX BY BINARY_INTEGER;
73512:
73513: l_array_source_38 t_array_source_38;
73514: l_array_source_42 t_array_source_42;

Line 73511: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_DRAFT_REV_NUM_CREDITED%TYPE INDEX BY BINARY_INTEGER;

73507: TYPE t_array_source_62 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
73508: TYPE t_array_source_63 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73509: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
73510: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73511: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_DRAFT_REV_NUM_CREDITED%TYPE INDEX BY BINARY_INTEGER;
73512:
73513: l_array_source_38 t_array_source_38;
73514: l_array_source_42 t_array_source_42;
73515: l_array_source_87 t_array_source_87;

Line 73644: , PA_XLA_REVENUE_LINES_ADJ_V l3

73640: , l3.CR_REVENUE_SECOND_DIST_ID source_65
73641: , l3.PDR_DRAFT_REV_NUM_CREDITED source_66
73642: FROM xla_events_gt xet
73643: , PA_XLA_EVENT_TYPE_REF_V l1
73644: , PA_XLA_REVENUE_LINES_ADJ_V l3
73645: , fnd_lookup_values fvl58
73646: WHERE xet.event_id between x_first_event_id and x_last_event_id
73647: and xet.event_date between p_pad_start_date and p_pad_end_date
73648: and xet.event_class_code = C_EVENT_CLASS_CODE