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_BC_BUDGET_LINES_V

Line 58191: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58187: FROM (
58188: SELECT xet.event_id event_id
58189: , l2.line_number line_number
58190: , CASE r
58191: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58192: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58193: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58194: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58195: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 58192: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58188: SELECT xet.event_id event_id
58189: , l2.line_number line_number
58190: , CASE r
58191: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58192: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58193: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58194: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58195: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58196: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 58193: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58189: , l2.line_number line_number
58190: , CASE r
58191: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58192: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58193: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58194: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58195: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58196: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58197: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 58194: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58190: , CASE r
58191: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58192: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58193: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58194: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58195: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58196: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58197: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58198: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 58195: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58191: WHEN 1 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58192: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58193: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58194: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58195: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58196: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58197: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58198: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58199: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 58196: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58192: WHEN 2 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58193: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58194: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58195: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58196: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58197: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58198: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58199: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58200: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'

Line 58197: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58193: WHEN 3 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58194: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58195: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58196: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58197: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58198: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58199: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58200: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58201:

Line 58198: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58194: WHEN 4 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58195: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58196: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58197: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58198: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58199: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58200: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58201:
58202: ELSE null

Line 58199: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58195: WHEN 5 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58196: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58197: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58198: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58199: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58200: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58201:
58202: ELSE null
58203: END object_name

Line 58200: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'

58196: WHEN 6 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58197: WHEN 7 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58198: WHEN 8 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58199: WHEN 9 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58200: WHEN 10 THEN 'PA_XLA_BC_BUDGET_LINES_V'
58201:
58202: ELSE null
58203: END object_name
58204: , CASE r

Line 58267: , PA_XLA_BC_BUDGET_LINES_V l2

58263:
58264: ELSE null
58265: END source_meaning
58266: FROM xla_events_gt xet
58267: , PA_XLA_BC_BUDGET_LINES_V l2
58268: , fnd_lookup_values fvl34
58269: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
58270: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58271: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 58411: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;

58407:
58408: TYPE t_array_source_87 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
58409: TYPE t_array_source_88 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
58410:
58411: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
58412: TYPE t_array_source_22 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
58413: TYPE t_array_source_25 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58414: TYPE t_array_source_34 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
58415: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 58412: TYPE t_array_source_22 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;

58408: TYPE t_array_source_87 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_DATE%TYPE INDEX BY BINARY_INTEGER;
58409: TYPE t_array_source_88 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
58410:
58411: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
58412: TYPE t_array_source_22 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
58413: TYPE t_array_source_25 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58414: TYPE t_array_source_34 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
58415: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58416: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 58413: TYPE t_array_source_25 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

58409: TYPE t_array_source_88 IS TABLE OF PA_XLA_BC_BUDGET_HEADER_V.GL_BUDGET_VERSION_ID%TYPE INDEX BY BINARY_INTEGER;
58410:
58411: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
58412: TYPE t_array_source_22 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
58413: TYPE t_array_source_25 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58414: TYPE t_array_source_34 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
58415: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58416: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58417: TYPE t_array_source_53 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

Line 58414: TYPE t_array_source_34 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

58410:
58411: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
58412: TYPE t_array_source_22 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
58413: TYPE t_array_source_25 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58414: TYPE t_array_source_34 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
58415: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58416: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58417: TYPE t_array_source_53 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58418: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 58415: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

58411: TYPE t_array_source_2 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_CCID%TYPE INDEX BY BINARY_INTEGER;
58412: TYPE t_array_source_22 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
58413: TYPE t_array_source_25 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58414: TYPE t_array_source_34 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
58415: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58416: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58417: TYPE t_array_source_53 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58418: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
58419: TYPE t_array_source_89 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 58416: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

58412: TYPE t_array_source_22 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.REVERSING_LINE_FLAG%TYPE INDEX BY BINARY_INTEGER;
58413: TYPE t_array_source_25 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58414: TYPE t_array_source_34 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
58415: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58416: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58417: TYPE t_array_source_53 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58418: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
58419: TYPE t_array_source_89 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
58420: TYPE t_array_source_90 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 58417: TYPE t_array_source_53 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;

58413: TYPE t_array_source_25 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
58414: TYPE t_array_source_34 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
58415: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58416: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58417: TYPE t_array_source_53 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58418: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
58419: TYPE t_array_source_89 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
58420: TYPE t_array_source_90 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
58421:

Line 58418: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;

58414: TYPE t_array_source_34 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;
58415: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58416: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58417: TYPE t_array_source_53 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58418: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
58419: TYPE t_array_source_89 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
58420: TYPE t_array_source_90 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
58421:
58422: l_array_source_87 t_array_source_87;

Line 58419: TYPE t_array_source_89 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

58415: TYPE t_array_source_41 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58416: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58417: TYPE t_array_source_53 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58418: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
58419: TYPE t_array_source_89 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
58420: TYPE t_array_source_90 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
58421:
58422: l_array_source_87 t_array_source_87;
58423: l_array_source_88 t_array_source_88;

Line 58420: TYPE t_array_source_90 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

58416: TYPE t_array_source_43 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ACCT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
58417: TYPE t_array_source_53 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_DR_ACCT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58418: TYPE t_array_source_55 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.USE_ENC_UPG_ATTRIB_FLAG%TYPE INDEX BY BINARY_INTEGER;
58419: TYPE t_array_source_89 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.BUDGET_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
58420: TYPE t_array_source_90 IS TABLE OF PA_XLA_BC_BUDGET_LINES_V.ENC_UPG_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
58421:
58422: l_array_source_87 t_array_source_87;
58423: l_array_source_88 t_array_source_88;
58424:

Line 58520: , PA_XLA_BC_BUDGET_LINES_V l2

58516: , l2.USE_ENC_UPG_ATTRIB_FLAG source_55
58517: , l2.BUDGET_LINE_ID source_89
58518: , l2.ENC_UPG_ENC_TYPE_ID source_90
58519: FROM xla_events_gt xet
58520: , PA_XLA_BC_BUDGET_LINES_V l2
58521: , fnd_lookup_values fvl34
58522: WHERE xet.event_id between x_first_event_id and x_last_event_id
58523: and xet.event_date between p_pad_start_date and p_pad_end_date
58524: and xet.event_class_code = C_EVENT_CLASS_CODE