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

Line 92279: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92275: FROM (
92276: SELECT xet.event_id event_id
92277: , l3.line_number line_number
92278: , CASE r
92279: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92280: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92281: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92282: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92283: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92280: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92276: SELECT xet.event_id event_id
92277: , l3.line_number line_number
92278: , CASE r
92279: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92280: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92281: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92282: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92283: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92284: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92281: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92277: , l3.line_number line_number
92278: , CASE r
92279: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92280: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92281: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92282: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92283: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92284: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92285: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92282: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92278: , CASE r
92279: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92280: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92281: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92282: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92283: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92284: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92285: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92286: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92283: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92279: WHEN 1 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92280: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92281: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92282: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92283: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92284: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92285: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92286: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92287: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92284: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92280: WHEN 2 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92281: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92282: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92283: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92284: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92285: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92286: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92287: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92288: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92285: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92281: WHEN 3 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92282: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92283: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92284: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92285: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92286: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92287: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92288: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92289: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92286: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92282: WHEN 4 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92283: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92284: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92285: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92286: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92287: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92288: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92289: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92290: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92287: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92283: WHEN 5 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92284: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92285: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92286: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92287: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92288: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92289: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92290: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92291: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92288: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92284: WHEN 6 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92285: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92286: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92287: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92288: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92289: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92290: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92291: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92292: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92289: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92285: WHEN 7 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92286: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92287: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92288: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92289: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92290: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92291: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92292: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92293: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92290: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92286: WHEN 8 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92287: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92288: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92289: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92290: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92291: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92292: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92293: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92294: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92291: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92287: WHEN 9 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92288: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92289: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92290: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92291: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92292: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92293: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92294: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92295: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92292: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92288: WHEN 10 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92289: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92290: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92291: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92292: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92293: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92294: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92295: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92296: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92293: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92289: WHEN 11 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92290: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92291: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92292: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92293: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92294: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92295: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92296: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92297: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92294: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92290: WHEN 12 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92291: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92292: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92293: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92294: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92295: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92296: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92297: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92298: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92295: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92291: WHEN 13 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92292: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92293: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92294: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92295: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92296: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92297: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92298: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92299: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92296: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92292: WHEN 14 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92293: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92294: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92295: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92296: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92297: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92298: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92299: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92300: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92297: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92293: WHEN 15 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92294: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92295: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92296: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92297: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92298: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92299: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92300: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92301: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92298: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92294: WHEN 16 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92295: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92296: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92297: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92298: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92299: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92300: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92301: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92302: WHEN 24 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

Line 92299: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92295: WHEN 17 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92296: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92297: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92298: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92299: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92300: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92301: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92302: WHEN 24 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92303: WHEN 25 THEN 'PA_XLA_EVENT_TYPE_REF_V'

Line 92300: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92296: WHEN 18 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92297: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92298: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92299: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92300: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92301: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92302: WHEN 24 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92303: WHEN 25 THEN 'PA_XLA_EVENT_TYPE_REF_V'
92304:

Line 92301: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92297: WHEN 19 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92298: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92299: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92300: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92301: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92302: WHEN 24 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92303: WHEN 25 THEN 'PA_XLA_EVENT_TYPE_REF_V'
92304:
92305: ELSE null

Line 92302: WHEN 24 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'

92298: WHEN 20 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92299: WHEN 21 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92300: WHEN 22 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92301: WHEN 23 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92302: WHEN 24 THEN 'PA_XLA_REVENUE_LINES_ADJ_V'
92303: WHEN 25 THEN 'PA_XLA_EVENT_TYPE_REF_V'
92304:
92305: ELSE null
92306: END object_name

Line 92431: , PA_XLA_REVENUE_LINES_ADJ_V l3

92427: ELSE null
92428: END source_meaning
92429: FROM xla_events_gt xet
92430: , PA_XLA_EVENT_TYPE_REF_V l1
92431: , PA_XLA_REVENUE_LINES_ADJ_V l3
92432: , fnd_lookup_values fvl72
92433: , (select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)
92434: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
92435: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 92578: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

92574: TYPE t_array_source_75 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
92575: TYPE t_array_source_77 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
92576: TYPE t_array_source_78 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
92577:
92578: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
92579: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
92580: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
92581: TYPE t_array_source_21 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
92582: TYPE t_array_source_24 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 92579: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

92575: TYPE t_array_source_77 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UER_CCID%TYPE INDEX BY BINARY_INTEGER;
92576: TYPE t_array_source_78 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
92577:
92578: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
92579: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
92580: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
92581: TYPE t_array_source_21 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
92582: TYPE t_array_source_24 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
92583: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 92580: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;

92576: TYPE t_array_source_78 IS TABLE OF PA_XLA_REVENUE_HEADERS_V.UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
92577:
92578: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
92579: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
92580: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
92581: TYPE t_array_source_21 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
92582: TYPE t_array_source_24 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
92583: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
92584: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 92581: TYPE t_array_source_21 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;

92577:
92578: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
92579: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
92580: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
92581: TYPE t_array_source_21 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
92582: TYPE t_array_source_24 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
92583: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
92584: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
92585: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 92582: TYPE t_array_source_24 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

92578: TYPE t_array_source_1 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PERDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
92579: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
92580: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
92581: TYPE t_array_source_21 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
92582: TYPE t_array_source_24 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
92583: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
92584: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
92585: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
92586: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 92583: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

92579: TYPE t_array_source_19 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PRDL_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
92580: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
92581: TYPE t_array_source_21 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
92582: TYPE t_array_source_24 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
92583: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
92584: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
92585: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
92586: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
92587: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 92584: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

92580: TYPE t_array_source_20 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UBR_CCID%TYPE INDEX BY BINARY_INTEGER;
92581: TYPE t_array_source_21 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
92582: TYPE t_array_source_24 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
92583: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
92584: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
92585: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
92586: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
92587: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
92588: TYPE t_array_source_32 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 92585: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

92581: TYPE t_array_source_21 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_UER_CCID%TYPE INDEX BY BINARY_INTEGER;
92582: TYPE t_array_source_24 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
92583: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
92584: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
92585: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
92586: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
92587: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
92588: TYPE t_array_source_32 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
92589: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 92586: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

92582: TYPE t_array_source_24 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
92583: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
92584: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
92585: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
92586: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
92587: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
92588: TYPE t_array_source_32 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
92589: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
92590: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 92587: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

92583: TYPE t_array_source_26 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
92584: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
92585: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
92586: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
92587: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
92588: TYPE t_array_source_32 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
92589: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
92590: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
92591: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 92588: TYPE t_array_source_32 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

92584: TYPE t_array_source_28 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
92585: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
92586: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
92587: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
92588: TYPE t_array_source_32 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
92589: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
92590: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
92591: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
92592: TYPE t_array_source_49 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 92589: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

92585: TYPE t_array_source_29 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
92586: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
92587: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
92588: TYPE t_array_source_32 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
92589: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
92590: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
92591: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
92592: TYPE t_array_source_49 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92593: TYPE t_array_source_50 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

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

92586: TYPE t_array_source_30 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
92587: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
92588: TYPE t_array_source_32 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
92589: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
92590: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
92591: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
92592: TYPE t_array_source_49 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92593: TYPE t_array_source_50 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92594: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 92591: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

92587: TYPE t_array_source_31 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
92588: TYPE t_array_source_32 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
92589: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
92590: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
92591: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
92592: TYPE t_array_source_49 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92593: TYPE t_array_source_50 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92594: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
92595: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 92592: TYPE t_array_source_49 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

92588: TYPE t_array_source_32 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
92589: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
92590: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
92591: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
92592: TYPE t_array_source_49 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92593: TYPE t_array_source_50 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92594: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
92595: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
92596: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 92593: TYPE t_array_source_50 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

92589: TYPE t_array_source_42 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
92590: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
92591: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
92592: TYPE t_array_source_49 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92593: TYPE t_array_source_50 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92594: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
92595: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
92596: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
92597: TYPE t_array_source_67 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 92594: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;

92590: TYPE t_array_source_43 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
92591: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
92592: TYPE t_array_source_49 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92593: TYPE t_array_source_50 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92594: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
92595: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
92596: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
92597: TYPE t_array_source_67 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
92598: TYPE t_array_source_68 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 92595: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;

92591: TYPE t_array_source_46 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
92592: TYPE t_array_source_49 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92593: TYPE t_array_source_50 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92594: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
92595: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
92596: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
92597: TYPE t_array_source_67 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
92598: TYPE t_array_source_68 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92599: TYPE t_array_source_69 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 92596: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;

92592: TYPE t_array_source_49 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92593: TYPE t_array_source_50 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92594: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
92595: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
92596: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
92597: TYPE t_array_source_67 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
92598: TYPE t_array_source_68 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92599: TYPE t_array_source_69 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
92600: TYPE t_array_source_70 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

Line 92597: TYPE t_array_source_67 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

92593: TYPE t_array_source_50 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92594: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
92595: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
92596: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
92597: TYPE t_array_source_67 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
92598: TYPE t_array_source_68 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92599: TYPE t_array_source_69 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
92600: TYPE t_array_source_70 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92601: TYPE t_array_source_71 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_DRAFT_REV_NUM_CREDITED%TYPE INDEX BY BINARY_INTEGER;

Line 92598: TYPE t_array_source_68 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

92594: TYPE t_array_source_64 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_CR_CCID%TYPE INDEX BY BINARY_INTEGER;
92595: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
92596: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
92597: TYPE t_array_source_67 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
92598: TYPE t_array_source_68 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92599: TYPE t_array_source_69 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
92600: TYPE t_array_source_70 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92601: TYPE t_array_source_71 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_DRAFT_REV_NUM_CREDITED%TYPE INDEX BY BINARY_INTEGER;
92602: TYPE t_array_source_72 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;

Line 92599: TYPE t_array_source_69 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;

92595: TYPE t_array_source_65 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.ACTUAL_UPG_DR_CCID%TYPE INDEX BY BINARY_INTEGER;
92596: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
92597: TYPE t_array_source_67 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
92598: TYPE t_array_source_68 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92599: TYPE t_array_source_69 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
92600: TYPE t_array_source_70 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92601: TYPE t_array_source_71 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_DRAFT_REV_NUM_CREDITED%TYPE INDEX BY BINARY_INTEGER;
92602: TYPE t_array_source_72 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
92603:

Line 92600: TYPE t_array_source_70 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

92596: TYPE t_array_source_66 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
92597: TYPE t_array_source_67 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
92598: TYPE t_array_source_68 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92599: TYPE t_array_source_69 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
92600: TYPE t_array_source_70 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92601: TYPE t_array_source_71 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_DRAFT_REV_NUM_CREDITED%TYPE INDEX BY BINARY_INTEGER;
92602: TYPE t_array_source_72 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
92603:
92604: l_array_source_48 t_array_source_48;

Line 92601: TYPE t_array_source_71 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_DRAFT_REV_NUM_CREDITED%TYPE INDEX BY BINARY_INTEGER;

92597: TYPE t_array_source_67 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.REVENUE_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
92598: TYPE t_array_source_68 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_FIRST_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92599: TYPE t_array_source_69 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PROJECT_ID%TYPE INDEX BY BINARY_INTEGER;
92600: TYPE t_array_source_70 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.CR_REVENUE_SECOND_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
92601: TYPE t_array_source_71 IS TABLE OF PA_XLA_REVENUE_LINES_ADJ_V.PDR_DRAFT_REV_NUM_CREDITED%TYPE INDEX BY BINARY_INTEGER;
92602: TYPE t_array_source_72 IS TABLE OF PA_XLA_EVENT_TYPE_REF_V.REV_EVENT_TYPE_CLASSIFICATION%TYPE INDEX BY BINARY_INTEGER;
92603:
92604: l_array_source_48 t_array_source_48;
92605: l_array_source_51 t_array_source_51;

Line 92739: , PA_XLA_REVENUE_LINES_ADJ_V l3

92735: , l1.REV_EVENT_TYPE_CLASSIFICATION source_72
92736: , fvl72.meaning source_72_meaning
92737: FROM xla_events_gt xet
92738: , PA_XLA_EVENT_TYPE_REF_V l1
92739: , PA_XLA_REVENUE_LINES_ADJ_V l3
92740: , fnd_lookup_values fvl72
92741: WHERE xet.event_id between x_first_event_id and x_last_event_id
92742: and xet.event_date between p_pad_start_date and p_pad_end_date
92743: and xet.event_class_code = C_EVENT_CLASS_CODE