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_EST_OR_PAYM_ACTIONS_V

Line 1770: WHEN 1 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'

1766: FROM (
1767: SELECT xet.event_id event_id
1768: , 0 line_number
1769: , CASE r
1770: WHEN 1 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'
1771: WHEN 2 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'
1772: WHEN 3 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'
1773: WHEN 4 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'
1774:

Line 1771: WHEN 2 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'

1767: SELECT xet.event_id event_id
1768: , 0 line_number
1769: , CASE r
1770: WHEN 1 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'
1771: WHEN 2 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'
1772: WHEN 3 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'
1773: WHEN 4 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'
1774:
1775: ELSE null

Line 1772: WHEN 3 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'

1768: , 0 line_number
1769: , CASE r
1770: WHEN 1 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'
1771: WHEN 2 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'
1772: WHEN 3 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'
1773: WHEN 4 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'
1774:
1775: ELSE null
1776: END object_name

Line 1773: WHEN 4 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'

1769: , CASE r
1770: WHEN 1 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'
1771: WHEN 2 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'
1772: WHEN 3 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'
1773: WHEN 4 THEN 'PAY_XLA_EST_OR_PAYM_ACTIONS_V'
1774:
1775: ELSE null
1776: END object_name
1777: , CASE r

Line 1812: , PAY_XLA_EST_OR_PAYM_ACTIONS_V h1

1808: ELSE null
1809: END source_value
1810: , null source_meaning
1811: FROM xla_events_gt xet
1812: , PAY_XLA_EST_OR_PAYM_ACTIONS_V h1
1813: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
1814: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
1815: AND xet.event_type_code = C_EVENT_TYPE_CODE
1816: AND h1.event_id = xet.event_id

Line 2060: TYPE t_array_source_3 IS TABLE OF PAY_XLA_EST_OR_PAYM_ACTIONS_V.PERSON_NAME%TYPE INDEX BY BINARY_INTEGER;

2056: --
2057: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
2058: --
2059:
2060: TYPE t_array_source_3 IS TABLE OF PAY_XLA_EST_OR_PAYM_ACTIONS_V.PERSON_NAME%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:

Line 2061: TYPE t_array_source_6 IS TABLE OF PAY_XLA_EST_OR_PAYM_ACTIONS_V.ASSIGNMENT_ACTION_ID%TYPE INDEX BY BINARY_INTEGER;

2057: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
2058: --
2059:
2060: TYPE t_array_source_3 IS TABLE OF PAY_XLA_EST_OR_PAYM_ACTIONS_V.PERSON_NAME%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;

Line 2062: TYPE t_array_source_7 IS TABLE OF PAY_XLA_EST_OR_PAYM_ACTIONS_V.COST_ACTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

2058: --
2059:
2060: TYPE t_array_source_3 IS TABLE OF PAY_XLA_EST_OR_PAYM_ACTIONS_V.PERSON_NAME%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;

Line 2063: TYPE t_array_source_10 IS TABLE OF PAY_XLA_EST_OR_PAYM_ACTIONS_V.CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;

2059:
2060: TYPE t_array_source_3 IS TABLE OF PAY_XLA_EST_OR_PAYM_ACTIONS_V.PERSON_NAME%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;

Line 2115: , PAY_XLA_EST_OR_PAYM_ACTIONS_V h1

2111: , h1.ASSIGNMENT_ACTION_ID source_6
2112: , h1.COST_ACTION_TYPE source_7
2113: , h1.CONVERSION_RATE_TYPE source_10
2114: FROM xla_events_gt xet
2115: , PAY_XLA_EST_OR_PAYM_ACTIONS_V h1
2116: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
2117: and xet.event_type_code = C_EVENT_TYPE_CODE
2118: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
2119: