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_00801_AAD_S_000003_PKG dependencies on PAY_XLA_PAYMENT_COSTS_V

Line 1882: WHEN 1 THEN 'PAY_XLA_PAYMENT_COSTS_V'

1878: FROM (
1879: SELECT xet.event_id event_id
1880: , l2.line_number line_number
1881: , CASE r
1882: WHEN 1 THEN 'PAY_XLA_PAYMENT_COSTS_V'
1883: WHEN 2 THEN 'PAY_XLA_PAYMENT_COSTS_V'
1884: WHEN 3 THEN 'PAY_XLA_PAYMENT_COSTS_V'
1885: WHEN 4 THEN 'PAY_XLA_PAYMENT_COSTS_V'
1886:

Line 1883: WHEN 2 THEN 'PAY_XLA_PAYMENT_COSTS_V'

1879: SELECT xet.event_id event_id
1880: , l2.line_number line_number
1881: , CASE r
1882: WHEN 1 THEN 'PAY_XLA_PAYMENT_COSTS_V'
1883: WHEN 2 THEN 'PAY_XLA_PAYMENT_COSTS_V'
1884: WHEN 3 THEN 'PAY_XLA_PAYMENT_COSTS_V'
1885: WHEN 4 THEN 'PAY_XLA_PAYMENT_COSTS_V'
1886:
1887: ELSE null

Line 1884: WHEN 3 THEN 'PAY_XLA_PAYMENT_COSTS_V'

1880: , l2.line_number line_number
1881: , CASE r
1882: WHEN 1 THEN 'PAY_XLA_PAYMENT_COSTS_V'
1883: WHEN 2 THEN 'PAY_XLA_PAYMENT_COSTS_V'
1884: WHEN 3 THEN 'PAY_XLA_PAYMENT_COSTS_V'
1885: WHEN 4 THEN 'PAY_XLA_PAYMENT_COSTS_V'
1886:
1887: ELSE null
1888: END object_name

Line 1885: WHEN 4 THEN 'PAY_XLA_PAYMENT_COSTS_V'

1881: , CASE r
1882: WHEN 1 THEN 'PAY_XLA_PAYMENT_COSTS_V'
1883: WHEN 2 THEN 'PAY_XLA_PAYMENT_COSTS_V'
1884: WHEN 3 THEN 'PAY_XLA_PAYMENT_COSTS_V'
1885: WHEN 4 THEN 'PAY_XLA_PAYMENT_COSTS_V'
1886:
1887: ELSE null
1888: END object_name
1889: , CASE r

Line 1924: , PAY_XLA_PAYMENT_COSTS_V l2

1920: ELSE null
1921: END source_value
1922: , null source_meaning
1923: FROM xla_events_gt xet
1924: , PAY_XLA_PAYMENT_COSTS_V l2
1925: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
1926: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
1927: AND xet.event_type_code = C_EVENT_TYPE_CODE
1928: AND l2.event_id = xet.event_id

Line 2065: TYPE t_array_source_1 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.DEBIT_OR_CREDIT%TYPE INDEX BY BINARY_INTEGER;

2061: TYPE t_array_source_6 IS TABLE OF PAY_XLA_EST_OR_PAYM_ACTIONS_V.ASSIGNMENT_ACTION_ID%TYPE INDEX BY BINARY_INTEGER;
2062: TYPE t_array_source_7 IS TABLE OF PAY_XLA_EST_OR_PAYM_ACTIONS_V.COST_ACTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
2063: TYPE t_array_source_10 IS TABLE OF PAY_XLA_EST_OR_PAYM_ACTIONS_V.CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
2064:
2065: TYPE t_array_source_1 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.DEBIT_OR_CREDIT%TYPE INDEX BY BINARY_INTEGER;
2066: TYPE t_array_source_5 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
2067: TYPE t_array_source_8 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.COSTED_VALUE%TYPE INDEX BY BINARY_INTEGER;
2068: TYPE t_array_source_9 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
2069:

Line 2066: TYPE t_array_source_5 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

2062: TYPE t_array_source_7 IS TABLE OF PAY_XLA_EST_OR_PAYM_ACTIONS_V.COST_ACTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
2063: TYPE t_array_source_10 IS TABLE OF PAY_XLA_EST_OR_PAYM_ACTIONS_V.CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
2064:
2065: TYPE t_array_source_1 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.DEBIT_OR_CREDIT%TYPE INDEX BY BINARY_INTEGER;
2066: TYPE t_array_source_5 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
2067: TYPE t_array_source_8 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.COSTED_VALUE%TYPE INDEX BY BINARY_INTEGER;
2068: TYPE t_array_source_9 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
2069:
2070: l_array_source_3 t_array_source_3;

Line 2067: TYPE t_array_source_8 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.COSTED_VALUE%TYPE INDEX BY BINARY_INTEGER;

2063: TYPE t_array_source_10 IS TABLE OF PAY_XLA_EST_OR_PAYM_ACTIONS_V.CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
2064:
2065: TYPE t_array_source_1 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.DEBIT_OR_CREDIT%TYPE INDEX BY BINARY_INTEGER;
2066: TYPE t_array_source_5 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
2067: TYPE t_array_source_8 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.COSTED_VALUE%TYPE INDEX BY BINARY_INTEGER;
2068: TYPE t_array_source_9 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
2069:
2070: l_array_source_3 t_array_source_3;
2071: l_array_source_6 t_array_source_6;

Line 2068: TYPE t_array_source_9 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

2064:
2065: TYPE t_array_source_1 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.DEBIT_OR_CREDIT%TYPE INDEX BY BINARY_INTEGER;
2066: TYPE t_array_source_5 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
2067: TYPE t_array_source_8 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.COSTED_VALUE%TYPE INDEX BY BINARY_INTEGER;
2068: TYPE t_array_source_9 IS TABLE OF PAY_XLA_PAYMENT_COSTS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
2069:
2070: l_array_source_3 t_array_source_3;
2071: l_array_source_6 t_array_source_6;
2072: l_array_source_7 t_array_source_7;

Line 2159: , PAY_XLA_PAYMENT_COSTS_V l2

2155: , l2.ACCOUNT_ID source_5
2156: , l2.COSTED_VALUE source_8
2157: , l2.CURRENCY_CODE source_9
2158: FROM xla_events_gt xet
2159: , PAY_XLA_PAYMENT_COSTS_V l2
2160: WHERE xet.event_id between x_first_event_id and x_last_event_id
2161: and xet.event_date between p_pad_start_date and p_pad_end_date
2162: and xet.event_type_code = C_EVENT_TYPE_CODE
2163: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id