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.PAY_INTERPRETER_PKG dependencies on PAY_DATED_TABLES

Line 59: pay_dated_tables.

55: to the detailed output record.
56: T Battoo 05-MAR-2001 115.4 Unknown (comment added by exjones)
57: Ashu Gupta 06-FEB-2001 115.3 Changed the name of the table
58: from pay_tables to
59: pay_dated_tables.
60: nbristow 26-JAN-2001 115.2 Added the prorate_start_date
61: function.
62: Ashu GUPTA 15-JAN-2001 115.0 Initial version.
63: ========================================================================

Line 139: table_id pay_dated_tables.dated_table_id%TYPE ,

135: *** be used in caching.
136: ***/
137: TYPE t_distinct_table_rec IS RECORD
138: (
139: table_id pay_dated_tables.dated_table_id%TYPE ,
140: table_name pay_dated_tables.table_name%TYPE ,
141: owner pay_dated_tables.owner%TYPE ,
142: dyt_type pay_dated_tables.dyn_trigger_type%TYPE ,
143: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,

Line 140: table_name pay_dated_tables.table_name%TYPE ,

136: ***/
137: TYPE t_distinct_table_rec IS RECORD
138: (
139: table_id pay_dated_tables.dated_table_id%TYPE ,
140: table_name pay_dated_tables.table_name%TYPE ,
141: owner pay_dated_tables.owner%TYPE ,
142: dyt_type pay_dated_tables.dyn_trigger_type%TYPE ,
143: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,
144: start_date_name pay_dated_tables.start_date_name%TYPE ,

Line 141: owner pay_dated_tables.owner%TYPE ,

137: TYPE t_distinct_table_rec IS RECORD
138: (
139: table_id pay_dated_tables.dated_table_id%TYPE ,
140: table_name pay_dated_tables.table_name%TYPE ,
141: owner pay_dated_tables.owner%TYPE ,
142: dyt_type pay_dated_tables.dyn_trigger_type%TYPE ,
143: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,
144: start_date_name pay_dated_tables.start_date_name%TYPE ,
145: end_date_name pay_dated_tables.end_date_name%TYPE ,

Line 142: dyt_type pay_dated_tables.dyn_trigger_type%TYPE ,

138: (
139: table_id pay_dated_tables.dated_table_id%TYPE ,
140: table_name pay_dated_tables.table_name%TYPE ,
141: owner pay_dated_tables.owner%TYPE ,
142: dyt_type pay_dated_tables.dyn_trigger_type%TYPE ,
143: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,
144: start_date_name pay_dated_tables.start_date_name%TYPE ,
145: end_date_name pay_dated_tables.end_date_name%TYPE ,
146: datetracked_event_id pay_datetracked_events.datetracked_event_id%TYPE,

Line 143: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,

139: table_id pay_dated_tables.dated_table_id%TYPE ,
140: table_name pay_dated_tables.table_name%TYPE ,
141: owner pay_dated_tables.owner%TYPE ,
142: dyt_type pay_dated_tables.dyn_trigger_type%TYPE ,
143: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,
144: start_date_name pay_dated_tables.start_date_name%TYPE ,
145: end_date_name pay_dated_tables.end_date_name%TYPE ,
146: datetracked_event_id pay_datetracked_events.datetracked_event_id%TYPE,
147: column_name pay_datetracked_events.column_name%TYPE ,

Line 144: start_date_name pay_dated_tables.start_date_name%TYPE ,

140: table_name pay_dated_tables.table_name%TYPE ,
141: owner pay_dated_tables.owner%TYPE ,
142: dyt_type pay_dated_tables.dyn_trigger_type%TYPE ,
143: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,
144: start_date_name pay_dated_tables.start_date_name%TYPE ,
145: end_date_name pay_dated_tables.end_date_name%TYPE ,
146: datetracked_event_id pay_datetracked_events.datetracked_event_id%TYPE,
147: column_name pay_datetracked_events.column_name%TYPE ,
148: update_type pay_datetracked_events.update_type%TYPE ,

Line 145: end_date_name pay_dated_tables.end_date_name%TYPE ,

141: owner pay_dated_tables.owner%TYPE ,
142: dyt_type pay_dated_tables.dyn_trigger_type%TYPE ,
143: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,
144: start_date_name pay_dated_tables.start_date_name%TYPE ,
145: end_date_name pay_dated_tables.end_date_name%TYPE ,
146: datetracked_event_id pay_datetracked_events.datetracked_event_id%TYPE,
147: column_name pay_datetracked_events.column_name%TYPE ,
148: update_type pay_datetracked_events.update_type%TYPE ,
149: proration_type pay_datetracked_events.proration_style%TYPE

Line 158: dated_table_id pay_dated_tables.dated_table_id%TYPE ,

154: t_distinct_tab t_distinct_table ;
155:
156: TYPE t_detailed_output_tab_rec IS RECORD
157: (
158: dated_table_id pay_dated_tables.dated_table_id%TYPE ,
159: datetracked_event pay_datetracked_events.datetracked_event_id%TYPE ,
160: update_type pay_datetracked_events.update_type%TYPE ,
161: surrogate_key pay_process_events.surrogate_key%type ,
162: column_name pay_event_updates.column_name%TYPE ,

Line 438: table_name pay_dated_tables.table_name%TYPE

434: change_values pay_process_events.description%type,
435: calculation_date pay_process_events.calculation_date%type,
436: creation_date pay_process_events.creation_date%type,
437: change_mode pay_process_events.change_type%type,
438: table_name pay_dated_tables.table_name%TYPE
439: );
440:
441: --used in extra_tests_dbt_i and extra_tests_dbt_p
442: TYPE t_key_date_cache_rec is record