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_09000_AAD_S_000015_PKG dependencies on DPP_XLA_CLAIM_LINES_V

Line 7891: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'

7887: FROM (
7888: SELECT xet.event_id event_id
7889: , l2.line_number line_number
7890: , CASE r
7891: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'
7892: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
7893: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
7894: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
7895: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'

Line 7892: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'

7888: SELECT xet.event_id event_id
7889: , l2.line_number line_number
7890: , CASE r
7891: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'
7892: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
7893: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
7894: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
7895: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'
7896: WHEN 6 THEN 'DPP_XLA_CLAIM_LINES_V'

Line 7893: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'

7889: , l2.line_number line_number
7890: , CASE r
7891: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'
7892: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
7893: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
7894: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
7895: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'
7896: WHEN 6 THEN 'DPP_XLA_CLAIM_LINES_V'
7897:

Line 7894: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'

7890: , CASE r
7891: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'
7892: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
7893: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
7894: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
7895: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'
7896: WHEN 6 THEN 'DPP_XLA_CLAIM_LINES_V'
7897:
7898: ELSE null

Line 7895: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'

7891: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'
7892: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
7893: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
7894: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
7895: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'
7896: WHEN 6 THEN 'DPP_XLA_CLAIM_LINES_V'
7897:
7898: ELSE null
7899: END object_name

Line 7896: WHEN 6 THEN 'DPP_XLA_CLAIM_LINES_V'

7892: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
7893: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
7894: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
7895: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'
7896: WHEN 6 THEN 'DPP_XLA_CLAIM_LINES_V'
7897:
7898: ELSE null
7899: END object_name
7900: , CASE r

Line 7943: , DPP_XLA_CLAIM_LINES_V l2

7939: ELSE null
7940: END source_value
7941: , null source_meaning
7942: FROM xla_events_gt xet
7943: , DPP_XLA_CLAIM_LINES_V l2
7944: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
7945: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7946: AND xet.event_type_code = C_EVENT_TYPE_CODE
7947: AND l2.event_id = xet.event_id

Line 8089: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;

8085: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
8086: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
8087: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
8088:
8089: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8090: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8091: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
8092: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
8093: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 8090: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;

8086: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
8087: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
8088:
8089: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8090: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8091: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
8092: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
8093: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
8094: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 8091: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

8087: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
8088:
8089: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8090: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8091: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
8092: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
8093: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
8094: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
8095:

Line 8092: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

8088:
8089: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8090: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8091: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
8092: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
8093: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
8094: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
8095:
8096: l_array_source_1 t_array_source_1;

Line 8093: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

8089: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8090: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8091: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
8092: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
8093: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
8094: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
8095:
8096: l_array_source_1 t_array_source_1;
8097: l_array_source_6 t_array_source_6;

Line 8094: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

8090: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
8091: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
8092: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
8093: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
8094: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
8095:
8096: l_array_source_1 t_array_source_1;
8097: l_array_source_6 t_array_source_6;
8098: l_array_source_7 t_array_source_7;

Line 8195: , DPP_XLA_CLAIM_LINES_V l2

8191: , l2.ENTERED_AMOUNT source_11
8192: , l2.CURRENCY_CODE source_12
8193: , l2.ACCOUNTED_AMOUNT source_13
8194: FROM xla_events_gt xet
8195: , DPP_XLA_CLAIM_LINES_V l2
8196: WHERE xet.event_id between x_first_event_id and x_last_event_id
8197: and xet.event_date between p_pad_start_date and p_pad_end_date
8198: and xet.event_type_code = C_EVENT_TYPE_CODE
8199: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 9080: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'

9076: FROM (
9077: SELECT xet.event_id event_id
9078: , l2.line_number line_number
9079: , CASE r
9080: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'
9081: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
9082: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
9083: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
9084:

Line 9081: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'

9077: SELECT xet.event_id event_id
9078: , l2.line_number line_number
9079: , CASE r
9080: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'
9081: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
9082: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
9083: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
9084:
9085: ELSE null

Line 9082: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'

9078: , l2.line_number line_number
9079: , CASE r
9080: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'
9081: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
9082: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
9083: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
9084:
9085: ELSE null
9086: END object_name

Line 9083: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'

9079: , CASE r
9080: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'
9081: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
9082: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
9083: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
9084:
9085: ELSE null
9086: END object_name
9087: , CASE r

Line 9122: , DPP_XLA_CLAIM_LINES_V l2

9118: ELSE null
9119: END source_value
9120: , null source_meaning
9121: FROM xla_events_gt xet
9122: , DPP_XLA_CLAIM_LINES_V l2
9123: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
9124: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
9125: AND xet.event_type_code = C_EVENT_TYPE_CODE
9126: AND l2.event_id = xet.event_id

Line 9267: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

9263: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
9264: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
9265: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
9266:
9267: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
9268: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
9269: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
9270: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
9271:

Line 9268: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

9264: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
9265: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
9266:
9267: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
9268: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
9269: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
9270: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
9271:
9272: l_array_source_5 t_array_source_5;

Line 9269: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

9265: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
9266:
9267: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
9268: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
9269: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
9270: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
9271:
9272: l_array_source_5 t_array_source_5;
9273: l_array_source_7 t_array_source_7;

Line 9270: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

9266:
9267: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
9268: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
9269: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
9270: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
9271:
9272: l_array_source_5 t_array_source_5;
9273: l_array_source_7 t_array_source_7;
9274: l_array_source_10 t_array_source_10;

Line 9365: , DPP_XLA_CLAIM_LINES_V l2

9361: , l2.ENTERED_AMOUNT source_11
9362: , l2.CURRENCY_CODE source_12
9363: , l2.ACCOUNTED_AMOUNT source_13
9364: FROM xla_events_gt xet
9365: , DPP_XLA_CLAIM_LINES_V l2
9366: WHERE xet.event_id between x_first_event_id and x_last_event_id
9367: and xet.event_date between p_pad_start_date and p_pad_end_date
9368: and xet.event_type_code = C_EVENT_TYPE_CODE
9369: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 10248: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'

10244: FROM (
10245: SELECT xet.event_id event_id
10246: , l2.line_number line_number
10247: , CASE r
10248: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'
10249: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
10250: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
10251: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
10252: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'

Line 10249: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'

10245: SELECT xet.event_id event_id
10246: , l2.line_number line_number
10247: , CASE r
10248: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'
10249: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
10250: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
10251: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
10252: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'
10253: WHEN 6 THEN 'DPP_XLA_CLAIM_LINES_V'

Line 10250: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'

10246: , l2.line_number line_number
10247: , CASE r
10248: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'
10249: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
10250: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
10251: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
10252: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'
10253: WHEN 6 THEN 'DPP_XLA_CLAIM_LINES_V'
10254:

Line 10251: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'

10247: , CASE r
10248: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'
10249: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
10250: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
10251: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
10252: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'
10253: WHEN 6 THEN 'DPP_XLA_CLAIM_LINES_V'
10254:
10255: ELSE null

Line 10252: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'

10248: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'
10249: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
10250: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
10251: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
10252: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'
10253: WHEN 6 THEN 'DPP_XLA_CLAIM_LINES_V'
10254:
10255: ELSE null
10256: END object_name

Line 10253: WHEN 6 THEN 'DPP_XLA_CLAIM_LINES_V'

10249: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
10250: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
10251: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
10252: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'
10253: WHEN 6 THEN 'DPP_XLA_CLAIM_LINES_V'
10254:
10255: ELSE null
10256: END object_name
10257: , CASE r

Line 10300: , DPP_XLA_CLAIM_LINES_V l2

10296: ELSE null
10297: END source_value
10298: , null source_meaning
10299: FROM xla_events_gt xet
10300: , DPP_XLA_CLAIM_LINES_V l2
10301: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
10302: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
10303: AND xet.event_type_code = C_EVENT_TYPE_CODE
10304: AND l2.event_id = xet.event_id

Line 10446: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;

10442: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
10443: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
10444: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
10445:
10446: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10447: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10448: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10449: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10450: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 10447: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;

10443: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
10444: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
10445:
10446: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10447: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10448: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10449: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10450: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
10451: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 10448: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

10444: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
10445:
10446: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10447: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10448: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10449: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10450: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
10451: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10452:

Line 10449: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

10445:
10446: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10447: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10448: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10449: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10450: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
10451: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10452:
10453: l_array_source_1 t_array_source_1;

Line 10450: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

10446: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10447: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10448: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10449: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10450: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
10451: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10452:
10453: l_array_source_1 t_array_source_1;
10454: l_array_source_4 t_array_source_4;

Line 10451: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

10447: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10448: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
10449: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10450: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
10451: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
10452:
10453: l_array_source_1 t_array_source_1;
10454: l_array_source_4 t_array_source_4;
10455: l_array_source_5 t_array_source_5;

Line 10552: , DPP_XLA_CLAIM_LINES_V l2

10548: , l2.ENTERED_AMOUNT source_11
10549: , l2.CURRENCY_CODE source_12
10550: , l2.ACCOUNTED_AMOUNT source_13
10551: FROM xla_events_gt xet
10552: , DPP_XLA_CLAIM_LINES_V l2
10553: WHERE xet.event_id between x_first_event_id and x_last_event_id
10554: and xet.event_date between p_pad_start_date and p_pad_end_date
10555: and xet.event_type_code = C_EVENT_TYPE_CODE
10556: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 11442: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'

11438: FROM (
11439: SELECT xet.event_id event_id
11440: , l2.line_number line_number
11441: , CASE r
11442: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'
11443: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
11444: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
11445: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
11446: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'

Line 11443: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'

11439: SELECT xet.event_id event_id
11440: , l2.line_number line_number
11441: , CASE r
11442: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'
11443: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
11444: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
11445: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
11446: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'
11447: WHEN 6 THEN 'DPP_XLA_CLAIM_LINES_V'

Line 11444: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'

11440: , l2.line_number line_number
11441: , CASE r
11442: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'
11443: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
11444: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
11445: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
11446: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'
11447: WHEN 6 THEN 'DPP_XLA_CLAIM_LINES_V'
11448:

Line 11445: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'

11441: , CASE r
11442: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'
11443: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
11444: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
11445: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
11446: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'
11447: WHEN 6 THEN 'DPP_XLA_CLAIM_LINES_V'
11448:
11449: ELSE null

Line 11446: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'

11442: WHEN 1 THEN 'DPP_XLA_CLAIM_LINES_V'
11443: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
11444: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
11445: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
11446: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'
11447: WHEN 6 THEN 'DPP_XLA_CLAIM_LINES_V'
11448:
11449: ELSE null
11450: END object_name

Line 11447: WHEN 6 THEN 'DPP_XLA_CLAIM_LINES_V'

11443: WHEN 2 THEN 'DPP_XLA_CLAIM_LINES_V'
11444: WHEN 3 THEN 'DPP_XLA_CLAIM_LINES_V'
11445: WHEN 4 THEN 'DPP_XLA_CLAIM_LINES_V'
11446: WHEN 5 THEN 'DPP_XLA_CLAIM_LINES_V'
11447: WHEN 6 THEN 'DPP_XLA_CLAIM_LINES_V'
11448:
11449: ELSE null
11450: END object_name
11451: , CASE r

Line 11494: , DPP_XLA_CLAIM_LINES_V l2

11490: ELSE null
11491: END source_value
11492: , null source_meaning
11493: FROM xla_events_gt xet
11494: , DPP_XLA_CLAIM_LINES_V l2
11495: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
11496: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
11497: AND xet.event_type_code = C_EVENT_TYPE_CODE
11498: AND l2.event_id = xet.event_id

Line 11640: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;

11636: TYPE t_array_source_14 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_ID%TYPE INDEX BY BINARY_INTEGER;
11637: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
11638: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
11639:
11640: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11641: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11642: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
11643: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11644: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 11641: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;

11637: TYPE t_array_source_15 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_SITE_ID%TYPE INDEX BY BINARY_INTEGER;
11638: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
11639:
11640: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11641: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11642: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
11643: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11644: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
11645: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 11642: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

11638: TYPE t_array_source_16 IS TABLE OF DPP_XLA_CLAIM_HEADERS_V.PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
11639:
11640: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11641: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11642: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
11643: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11644: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
11645: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11646:

Line 11643: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

11639:
11640: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11641: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11642: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
11643: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11644: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
11645: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11646:
11647: l_array_source_1 t_array_source_1;

Line 11644: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

11640: TYPE t_array_source_2 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CLAIM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11641: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11642: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
11643: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11644: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
11645: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11646:
11647: l_array_source_1 t_array_source_1;
11648: l_array_source_4 t_array_source_4;

Line 11645: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

11641: TYPE t_array_source_3 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11642: TYPE t_array_source_9 IS TABLE OF DPP_XLA_CLAIM_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
11643: TYPE t_array_source_11 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ENTERED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11644: TYPE t_array_source_12 IS TABLE OF DPP_XLA_CLAIM_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
11645: TYPE t_array_source_13 IS TABLE OF DPP_XLA_CLAIM_LINES_V.ACCOUNTED_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
11646:
11647: l_array_source_1 t_array_source_1;
11648: l_array_source_4 t_array_source_4;
11649: l_array_source_5 t_array_source_5;

Line 11746: , DPP_XLA_CLAIM_LINES_V l2

11742: , l2.ENTERED_AMOUNT source_11
11743: , l2.CURRENCY_CODE source_12
11744: , l2.ACCOUNTED_AMOUNT source_13
11745: FROM xla_events_gt xet
11746: , DPP_XLA_CLAIM_LINES_V l2
11747: WHERE xet.event_id between x_first_event_id and x_last_event_id
11748: and xet.event_date between p_pad_start_date and p_pad_end_date
11749: and xet.event_type_code = C_EVENT_TYPE_CODE
11750: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id