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_CCDL_LINES_V

Line 55389: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'

55385: FROM (
55386: SELECT xet.event_id event_id
55387: , l1.line_number line_number
55388: , CASE r
55389: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
55390: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
55391: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
55392: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
55393: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'

Line 55390: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'

55386: SELECT xet.event_id event_id
55387: , l1.line_number line_number
55388: , CASE r
55389: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
55390: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
55391: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
55392: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
55393: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
55394: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'

Line 55391: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'

55387: , l1.line_number line_number
55388: , CASE r
55389: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
55390: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
55391: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
55392: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
55393: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
55394: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
55395: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'

Line 55392: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'

55388: , CASE r
55389: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
55390: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
55391: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
55392: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
55393: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
55394: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
55395: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
55396: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'

Line 55393: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'

55389: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
55390: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
55391: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
55392: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
55393: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
55394: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
55395: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
55396: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
55397: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'

Line 55394: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'

55390: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
55391: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
55392: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
55393: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
55394: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
55395: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
55396: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
55397: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
55398: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'

Line 55395: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'

55391: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
55392: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
55393: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
55394: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
55395: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
55396: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
55397: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
55398: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
55399: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'

Line 55396: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'

55392: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
55393: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
55394: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
55395: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
55396: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
55397: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
55398: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
55399: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
55400: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'

Line 55397: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'

55393: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
55394: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
55395: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
55396: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
55397: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
55398: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
55399: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
55400: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
55401: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'

Line 55398: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'

55394: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
55395: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
55396: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
55397: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
55398: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
55399: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
55400: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
55401: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
55402: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'

Line 55399: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'

55395: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
55396: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
55397: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
55398: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
55399: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
55400: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
55401: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
55402: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
55403: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'

Line 55400: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'

55396: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
55397: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
55398: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
55399: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
55400: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
55401: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
55402: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
55403: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
55404: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'

Line 55401: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'

55397: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
55398: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
55399: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
55400: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
55401: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
55402: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
55403: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
55404: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
55405: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'

Line 55402: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'

55398: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
55399: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
55400: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
55401: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
55402: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
55403: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
55404: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
55405: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
55406: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'

Line 55403: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'

55399: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
55400: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
55401: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
55402: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
55403: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
55404: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
55405: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
55406: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
55407:

Line 55404: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'

55400: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
55401: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
55402: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
55403: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
55404: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
55405: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
55406: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
55407:
55408: ELSE null

Line 55405: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'

55401: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
55402: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
55403: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
55404: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
55405: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
55406: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
55407:
55408: ELSE null
55409: END object_name

Line 55406: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'

55402: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
55403: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
55404: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
55405: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
55406: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
55407:
55408: ELSE null
55409: END object_name
55410: , CASE r

Line 55511: , PA_XLA_CCDL_LINES_V l1

55507:
55508: ELSE null
55509: END source_meaning
55510: FROM xla_events_gt xet
55511: , PA_XLA_CCDL_LINES_V l1
55512: , fnd_lookup_values fvl34
55513: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
55514: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55515: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 55656: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

55652: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
55653: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
55654: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
55655:
55656: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
55657: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55658: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55659: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55660: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 55657: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

55653: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
55654: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
55655:
55656: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
55657: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55658: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55659: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55660: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55661: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 55658: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

55654: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
55655:
55656: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
55657: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55658: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55659: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55660: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55661: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
55662: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 55659: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;

55655:
55656: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
55657: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55658: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55659: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55660: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55661: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
55662: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55663: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 55660: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;

55656: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
55657: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55658: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55659: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55660: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55661: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
55662: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55663: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
55664: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 55661: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

55657: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55658: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55659: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55660: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55661: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
55662: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55663: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
55664: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
55665: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 55662: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

55658: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
55659: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55660: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55661: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
55662: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55663: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
55664: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
55665: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
55666: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 55663: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

55659: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55660: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55661: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
55662: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55663: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
55664: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
55665: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
55666: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55667: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 55664: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

55660: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
55661: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
55662: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55663: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
55664: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
55665: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
55666: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55667: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55668: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 55665: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

55661: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
55662: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55663: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
55664: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
55665: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
55666: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55667: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55668: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
55669: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 55666: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

55662: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55663: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
55664: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
55665: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
55666: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55667: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55668: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
55669: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
55670: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 55667: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

55663: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
55664: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
55665: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
55666: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55667: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55668: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
55669: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
55670: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55671: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

Line 55668: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

55664: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
55665: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
55666: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55667: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55668: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
55669: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
55670: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55671: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
55672: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 55669: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

55665: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
55666: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55667: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55668: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
55669: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
55670: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55671: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
55672: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55673: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 55670: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

55666: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55667: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55668: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
55669: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
55670: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55671: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
55672: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55673: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55674:

Line 55671: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

55667: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
55668: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
55669: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
55670: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55671: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
55672: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55673: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55674:
55675: l_array_source_32 t_array_source_32;

Line 55672: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

55668: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
55669: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
55670: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55671: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
55672: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55673: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55674:
55675: l_array_source_32 t_array_source_32;
55676: l_array_source_67 t_array_source_67;

Line 55673: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

55669: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
55670: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55671: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
55672: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55673: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
55674:
55675: l_array_source_32 t_array_source_32;
55676: l_array_source_67 t_array_source_67;
55677: l_array_source_67_meaning t_array_lookup_meaning;

Line 55798: , PA_XLA_CCDL_LINES_V l1

55794: , l1.LINE_NUM_REVERSED source_35
55795: , l1.ENTERED_AMOUNT source_41
55796: , l1.ACCT_AMOUNT source_43
55797: FROM xla_events_gt xet
55798: , PA_XLA_CCDL_LINES_V l1
55799: , fnd_lookup_values fvl34
55800: WHERE xet.event_id between x_first_event_id and x_last_event_id
55801: and xet.event_date between p_pad_start_date and p_pad_end_date
55802: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 56797: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'

56793: FROM (
56794: SELECT xet.event_id event_id
56795: , l1.line_number line_number
56796: , CASE r
56797: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
56798: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
56799: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
56800: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
56801: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'

Line 56798: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'

56794: SELECT xet.event_id event_id
56795: , l1.line_number line_number
56796: , CASE r
56797: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
56798: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
56799: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
56800: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
56801: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
56802: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'

Line 56799: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'

56795: , l1.line_number line_number
56796: , CASE r
56797: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
56798: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
56799: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
56800: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
56801: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
56802: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
56803: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'

Line 56800: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'

56796: , CASE r
56797: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
56798: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
56799: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
56800: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
56801: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
56802: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
56803: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
56804: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'

Line 56801: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'

56797: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
56798: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
56799: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
56800: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
56801: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
56802: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
56803: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
56804: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
56805: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'

Line 56802: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'

56798: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
56799: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
56800: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
56801: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
56802: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
56803: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
56804: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
56805: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
56806: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'

Line 56803: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'

56799: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
56800: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
56801: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
56802: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
56803: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
56804: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
56805: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
56806: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
56807: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'

Line 56804: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'

56800: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
56801: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
56802: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
56803: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
56804: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
56805: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
56806: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
56807: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
56808: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'

Line 56805: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'

56801: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
56802: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
56803: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
56804: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
56805: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
56806: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
56807: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
56808: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
56809: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'

Line 56806: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'

56802: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
56803: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
56804: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
56805: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
56806: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
56807: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
56808: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
56809: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
56810: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'

Line 56807: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'

56803: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
56804: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
56805: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
56806: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
56807: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
56808: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
56809: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
56810: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
56811: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'

Line 56808: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'

56804: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
56805: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
56806: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
56807: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
56808: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
56809: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
56810: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
56811: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
56812: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'

Line 56809: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'

56805: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
56806: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
56807: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
56808: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
56809: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
56810: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
56811: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
56812: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
56813: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'

Line 56810: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'

56806: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
56807: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
56808: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
56809: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
56810: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
56811: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
56812: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
56813: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
56814: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'

Line 56811: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'

56807: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
56808: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
56809: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
56810: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
56811: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
56812: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
56813: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
56814: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
56815:

Line 56812: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'

56808: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
56809: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
56810: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
56811: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
56812: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
56813: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
56814: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
56815:
56816: ELSE null

Line 56813: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'

56809: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
56810: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
56811: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
56812: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
56813: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
56814: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
56815:
56816: ELSE null
56817: END object_name

Line 56814: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'

56810: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
56811: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
56812: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
56813: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
56814: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
56815:
56816: ELSE null
56817: END object_name
56818: , CASE r

Line 56919: , PA_XLA_CCDL_LINES_V l1

56915:
56916: ELSE null
56917: END source_meaning
56918: FROM xla_events_gt xet
56919: , PA_XLA_CCDL_LINES_V l1
56920: , fnd_lookup_values fvl34
56921: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
56922: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
56923: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 57064: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

57060: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
57061: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
57062: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
57063:
57064: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
57065: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57066: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57067: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57068: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 57065: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

57061: TYPE t_array_source_67 IS TABLE OF PA_XLA_EXP_HEADER_V.TP_AMT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
57062: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
57063:
57064: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
57065: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57066: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57067: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57068: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57069: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 57066: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;

57062: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
57063:
57064: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
57065: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57066: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57067: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57068: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57069: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
57070: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 57067: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;

57063:
57064: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
57065: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57066: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57067: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57068: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57069: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
57070: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57071: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 57068: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;

57064: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
57065: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57066: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57067: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57068: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57069: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
57070: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57071: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57072: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 57069: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

57065: TYPE t_array_source_8 IS TABLE OF PA_XLA_CCDL_LINES_V.PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57066: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57067: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57068: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57069: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
57070: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57071: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57072: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
57073: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 57070: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

57066: TYPE t_array_source_9 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_PROVIDER_CCID%TYPE INDEX BY BINARY_INTEGER;
57067: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57068: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57069: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
57070: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57071: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57072: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
57073: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
57074: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 57071: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

57067: TYPE t_array_source_10 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57068: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57069: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
57070: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57071: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57072: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
57073: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
57074: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57075: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 57072: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

57068: TYPE t_array_source_15 IS TABLE OF PA_XLA_CCDL_LINES_V.RECEIVER_CCID%TYPE INDEX BY BINARY_INTEGER;
57069: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
57070: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57071: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57072: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
57073: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
57074: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57075: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57076: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 57073: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

57069: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
57070: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57071: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57072: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
57073: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
57074: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57075: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57076: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
57077: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 57074: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

57070: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57071: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57072: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
57073: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
57074: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57075: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57076: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
57077: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57078: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 57075: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

57071: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
57072: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
57073: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
57074: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57075: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57076: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
57077: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57078: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57079: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

Line 57076: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

57072: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
57073: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
57074: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57075: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57076: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
57077: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57078: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57079: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
57080: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 57077: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

57073: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
57074: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57075: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57076: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
57077: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57078: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57079: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
57080: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57081: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 57078: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

57074: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57075: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57076: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
57077: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57078: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57079: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
57080: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57081: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57082:

Line 57079: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

57075: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57076: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
57077: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57078: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57079: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
57080: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57081: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57082:
57083: l_array_source_32 t_array_source_32;

Line 57080: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

57076: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
57077: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57078: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57079: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
57080: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57081: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57082:
57083: l_array_source_32 t_array_source_32;
57084: l_array_source_67 t_array_source_67;

Line 57081: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

57077: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
57078: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
57079: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
57080: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57081: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
57082:
57083: l_array_source_32 t_array_source_32;
57084: l_array_source_67 t_array_source_67;
57085: l_array_source_67_meaning t_array_lookup_meaning;

Line 57206: , PA_XLA_CCDL_LINES_V l1

57202: , l1.LINE_NUM_REVERSED source_35
57203: , l1.ENTERED_AMOUNT source_41
57204: , l1.ACCT_AMOUNT source_43
57205: FROM xla_events_gt xet
57206: , PA_XLA_CCDL_LINES_V l1
57207: , fnd_lookup_values fvl34
57208: WHERE xet.event_id between x_first_event_id and x_last_event_id
57209: and xet.event_date between p_pad_start_date and p_pad_end_date
57210: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 70580: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'

70576: FROM (
70577: SELECT xet.event_id event_id
70578: , l1.line_number line_number
70579: , CASE r
70580: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
70581: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
70582: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
70583: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
70584: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'

Line 70581: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'

70577: SELECT xet.event_id event_id
70578: , l1.line_number line_number
70579: , CASE r
70580: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
70581: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
70582: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
70583: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
70584: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
70585: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'

Line 70582: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'

70578: , l1.line_number line_number
70579: , CASE r
70580: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
70581: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
70582: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
70583: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
70584: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
70585: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
70586: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'

Line 70583: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'

70579: , CASE r
70580: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
70581: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
70582: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
70583: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
70584: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
70585: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
70586: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
70587: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'

Line 70584: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'

70580: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
70581: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
70582: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
70583: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
70584: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
70585: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
70586: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
70587: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
70588: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'

Line 70585: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'

70581: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
70582: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
70583: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
70584: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
70585: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
70586: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
70587: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
70588: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
70589: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'

Line 70586: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'

70582: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
70583: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
70584: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
70585: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
70586: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
70587: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
70588: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
70589: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
70590: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'

Line 70587: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'

70583: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
70584: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
70585: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
70586: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
70587: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
70588: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
70589: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
70590: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
70591: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'

Line 70588: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'

70584: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
70585: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
70586: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
70587: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
70588: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
70589: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
70590: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
70591: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
70592: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'

Line 70589: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'

70585: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
70586: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
70587: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
70588: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
70589: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
70590: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
70591: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
70592: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
70593: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'

Line 70590: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'

70586: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
70587: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
70588: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
70589: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
70590: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
70591: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
70592: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
70593: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
70594: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'

Line 70591: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'

70587: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
70588: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
70589: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
70590: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
70591: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
70592: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
70593: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
70594: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
70595: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'

Line 70592: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'

70588: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
70589: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
70590: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
70591: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
70592: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
70593: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
70594: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
70595: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
70596: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'

Line 70593: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'

70589: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
70590: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
70591: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
70592: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
70593: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
70594: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
70595: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
70596: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
70597: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'

Line 70594: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'

70590: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
70591: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
70592: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
70593: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
70594: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
70595: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
70596: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
70597: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
70598:

Line 70595: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'

70591: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
70592: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
70593: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
70594: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
70595: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
70596: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
70597: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
70598:
70599: ELSE null

Line 70596: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'

70592: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
70593: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
70594: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
70595: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
70596: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
70597: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
70598:
70599: ELSE null
70600: END object_name

Line 70597: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'

70593: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
70594: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
70595: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
70596: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
70597: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
70598:
70599: ELSE null
70600: END object_name
70601: , CASE r

Line 70702: , PA_XLA_CCDL_LINES_V l1

70698:
70699: ELSE null
70700: END source_meaning
70701: FROM xla_events_gt xet
70702: , PA_XLA_CCDL_LINES_V l1
70703: , fnd_lookup_values fvl34
70704: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
70705: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70706: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 70846: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

70842:
70843: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
70844: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
70845:
70846: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
70847: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70848: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70849: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70850: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 70847: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

70843: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
70844: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
70845:
70846: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
70847: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70848: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70849: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70850: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70851: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 70848: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

70844: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
70845:
70846: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
70847: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70848: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70849: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70850: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70851: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
70852: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 70849: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;

70845:
70846: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
70847: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70848: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70849: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70850: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70851: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
70852: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70853: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 70850: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;

70846: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
70847: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70848: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70849: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70850: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70851: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
70852: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70853: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70854: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 70851: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

70847: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70848: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70849: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70850: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70851: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
70852: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70853: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70854: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
70855: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 70852: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

70848: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
70849: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70850: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70851: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
70852: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70853: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70854: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
70855: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
70856: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 70853: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

70849: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70850: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70851: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
70852: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70853: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70854: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
70855: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
70856: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70857: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 70854: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

70850: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
70851: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
70852: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70853: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70854: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
70855: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
70856: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70857: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70858: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 70855: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

70851: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
70852: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70853: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70854: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
70855: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
70856: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70857: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70858: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
70859: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 70856: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

70852: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70853: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70854: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
70855: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
70856: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70857: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70858: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
70859: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
70860: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 70857: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

70853: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
70854: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
70855: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
70856: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70857: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70858: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
70859: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
70860: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70861: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

Line 70858: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

70854: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
70855: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
70856: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70857: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70858: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
70859: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
70860: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70861: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
70862: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 70859: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

70855: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
70856: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70857: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70858: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
70859: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
70860: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70861: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
70862: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70863: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 70860: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

70856: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70857: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70858: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
70859: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
70860: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70861: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
70862: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70863: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70864:

Line 70861: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

70857: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70858: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
70859: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
70860: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70861: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
70862: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70863: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70864:
70865: l_array_source_32 t_array_source_32;

Line 70862: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

70858: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
70859: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
70860: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70861: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
70862: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70863: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70864:
70865: l_array_source_32 t_array_source_32;
70866: l_array_source_87 t_array_source_87;

Line 70863: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

70859: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
70860: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
70861: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
70862: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70863: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
70864:
70865: l_array_source_32 t_array_source_32;
70866: l_array_source_87 t_array_source_87;
70867:

Line 70979: , PA_XLA_CCDL_LINES_V l1

70975: , l1.LINE_NUM_REVERSED source_35
70976: , l1.ENTERED_AMOUNT source_41
70977: , l1.ACCT_AMOUNT source_43
70978: FROM xla_events_gt xet
70979: , PA_XLA_CCDL_LINES_V l1
70980: , fnd_lookup_values fvl34
70981: WHERE xet.event_id between x_first_event_id and x_last_event_id
70982: and xet.event_date between p_pad_start_date and p_pad_end_date
70983: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 71878: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'

71874: FROM (
71875: SELECT xet.event_id event_id
71876: , l1.line_number line_number
71877: , CASE r
71878: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
71879: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
71880: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
71881: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
71882: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'

Line 71879: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'

71875: SELECT xet.event_id event_id
71876: , l1.line_number line_number
71877: , CASE r
71878: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
71879: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
71880: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
71881: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
71882: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
71883: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'

Line 71880: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'

71876: , l1.line_number line_number
71877: , CASE r
71878: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
71879: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
71880: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
71881: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
71882: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
71883: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
71884: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'

Line 71881: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'

71877: , CASE r
71878: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
71879: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
71880: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
71881: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
71882: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
71883: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
71884: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
71885: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'

Line 71882: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'

71878: WHEN 1 THEN 'PA_XLA_CCDL_LINES_V'
71879: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
71880: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
71881: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
71882: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
71883: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
71884: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
71885: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
71886: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'

Line 71883: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'

71879: WHEN 2 THEN 'PA_XLA_CCDL_LINES_V'
71880: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
71881: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
71882: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
71883: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
71884: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
71885: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
71886: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
71887: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'

Line 71884: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'

71880: WHEN 3 THEN 'PA_XLA_CCDL_LINES_V'
71881: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
71882: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
71883: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
71884: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
71885: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
71886: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
71887: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
71888: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'

Line 71885: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'

71881: WHEN 4 THEN 'PA_XLA_CCDL_LINES_V'
71882: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
71883: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
71884: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
71885: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
71886: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
71887: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
71888: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
71889: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'

Line 71886: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'

71882: WHEN 5 THEN 'PA_XLA_CCDL_LINES_V'
71883: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
71884: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
71885: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
71886: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
71887: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
71888: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
71889: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
71890: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'

Line 71887: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'

71883: WHEN 6 THEN 'PA_XLA_CCDL_LINES_V'
71884: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
71885: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
71886: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
71887: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
71888: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
71889: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
71890: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
71891: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'

Line 71888: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'

71884: WHEN 7 THEN 'PA_XLA_CCDL_LINES_V'
71885: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
71886: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
71887: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
71888: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
71889: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
71890: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
71891: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
71892: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'

Line 71889: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'

71885: WHEN 8 THEN 'PA_XLA_CCDL_LINES_V'
71886: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
71887: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
71888: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
71889: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
71890: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
71891: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
71892: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
71893: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'

Line 71890: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'

71886: WHEN 9 THEN 'PA_XLA_CCDL_LINES_V'
71887: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
71888: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
71889: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
71890: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
71891: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
71892: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
71893: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
71894: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'

Line 71891: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'

71887: WHEN 10 THEN 'PA_XLA_CCDL_LINES_V'
71888: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
71889: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
71890: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
71891: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
71892: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
71893: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
71894: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
71895: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'

Line 71892: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'

71888: WHEN 11 THEN 'PA_XLA_CCDL_LINES_V'
71889: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
71890: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
71891: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
71892: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
71893: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
71894: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
71895: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
71896:

Line 71893: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'

71889: WHEN 12 THEN 'PA_XLA_CCDL_LINES_V'
71890: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
71891: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
71892: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
71893: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
71894: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
71895: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
71896:
71897: ELSE null

Line 71894: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'

71890: WHEN 13 THEN 'PA_XLA_CCDL_LINES_V'
71891: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
71892: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
71893: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
71894: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
71895: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
71896:
71897: ELSE null
71898: END object_name

Line 71895: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'

71891: WHEN 14 THEN 'PA_XLA_CCDL_LINES_V'
71892: WHEN 15 THEN 'PA_XLA_CCDL_LINES_V'
71893: WHEN 16 THEN 'PA_XLA_CCDL_LINES_V'
71894: WHEN 17 THEN 'PA_XLA_CCDL_LINES_V'
71895: WHEN 18 THEN 'PA_XLA_CCDL_LINES_V'
71896:
71897: ELSE null
71898: END object_name
71899: , CASE r

Line 72000: , PA_XLA_CCDL_LINES_V l1

71996:
71997: ELSE null
71998: END source_meaning
71999: FROM xla_events_gt xet
72000: , PA_XLA_CCDL_LINES_V l1
72001: , fnd_lookup_values fvl34
72002: , (select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
72003: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72004: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 72144: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;

72140:
72141: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
72142: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
72143:
72144: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
72145: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72146: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72147: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72148: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;

Line 72145: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

72141: TYPE t_array_source_32 IS TABLE OF PA_XLA_EXP_HEADER_V.EXPENDITURE_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
72142: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
72143:
72144: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
72145: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72146: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72147: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72148: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 72146: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;

72142: TYPE t_array_source_87 IS TABLE OF PA_XLA_EXP_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
72143:
72144: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
72145: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72146: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72147: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72148: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
72150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 72147: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;

72143:
72144: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
72145: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72146: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72147: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72148: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
72150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 72148: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;

72144: TYPE t_array_source_4 IS TABLE OF PA_XLA_CCDL_LINES_V.ALLOW_OVERRIDE_CCID_FLAG%TYPE INDEX BY BINARY_INTEGER;
72145: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72146: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72147: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72148: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
72150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 72149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

72145: TYPE t_array_source_11 IS TABLE OF PA_XLA_CCDL_LINES_V.DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72146: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72147: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72148: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
72150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
72153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 72150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

72146: TYPE t_array_source_12 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_DESTINATION_CCID%TYPE INDEX BY BINARY_INTEGER;
72147: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72148: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
72150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
72153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
72154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 72151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

72147: TYPE t_array_source_13 IS TABLE OF PA_XLA_CCDL_LINES_V.SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72148: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
72150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
72153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
72154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 72152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;

72148: TYPE t_array_source_14 IS TABLE OF PA_XLA_CCDL_LINES_V.ADJ_SOURCE_CCID%TYPE INDEX BY BINARY_INTEGER;
72149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
72150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
72153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
72154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 72153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;

72149: TYPE t_array_source_22 IS TABLE OF PA_XLA_CCDL_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
72150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
72153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
72154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
72157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 72154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

72150: TYPE t_array_source_23 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_CR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
72153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
72154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
72157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72158: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 72155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

72151: TYPE t_array_source_25 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
72153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
72154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
72157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72158: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72159: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

Line 72156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

72152: TYPE t_array_source_27 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
72153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
72154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
72157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72158: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72159: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
72160: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 72157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;

72153: TYPE t_array_source_28 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
72154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
72157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72158: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72159: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
72160: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72161: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 72158: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

72154: TYPE t_array_source_29 IS TABLE OF PA_XLA_CCDL_LINES_V.EXCHANGE_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
72157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72158: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72159: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
72160: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72161: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72162:

Line 72159: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;

72155: TYPE t_array_source_30 IS TABLE OF PA_XLA_CCDL_LINES_V.ACTUAL_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
72157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72158: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72159: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
72160: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72161: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72162:
72163: l_array_source_32 t_array_source_32;

Line 72160: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

72156: TYPE t_array_source_31 IS TABLE OF PA_XLA_CCDL_LINES_V.USE_ACT_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
72157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72158: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72159: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
72160: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72161: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72162:
72163: l_array_source_32 t_array_source_32;
72164: l_array_source_87 t_array_source_87;

Line 72161: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

72157: TYPE t_array_source_33 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUMBER%TYPE INDEX BY BINARY_INTEGER;
72158: TYPE t_array_source_34 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72159: TYPE t_array_source_35 IS TABLE OF PA_XLA_CCDL_LINES_V.LINE_NUM_REVERSED%TYPE INDEX BY BINARY_INTEGER;
72160: TYPE t_array_source_41 IS TABLE OF PA_XLA_CCDL_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72161: TYPE t_array_source_43 IS TABLE OF PA_XLA_CCDL_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
72162:
72163: l_array_source_32 t_array_source_32;
72164: l_array_source_87 t_array_source_87;
72165:

Line 72277: , PA_XLA_CCDL_LINES_V l1

72273: , l1.LINE_NUM_REVERSED source_35
72274: , l1.ENTERED_AMOUNT source_41
72275: , l1.ACCT_AMOUNT source_43
72276: FROM xla_events_gt xet
72277: , PA_XLA_CCDL_LINES_V l1
72278: , fnd_lookup_values fvl34
72279: WHERE xet.event_id between x_first_event_id and x_last_event_id
72280: and xet.event_date between p_pad_start_date and p_pad_end_date
72281: and xet.event_class_code = C_EVENT_CLASS_CODE