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.

[Home] [Help]

APPS.PAY_INTERPRETER_PKG dependencies on PAY_DATED_TABLES

Line 67: pay_dated_tables.

63: to the detailed output record.
64: T Battoo 05-MAR-2001 115.4 Unknown (comment added by exjones)
65: Ashu Gupta 06-FEB-2001 115.3 Changed the name of the table
66: from pay_tables to
67: pay_dated_tables.
68: nbristow 26-JAN-2001 115.2 Added the prorate_start_date
69: function.
70: Ashu GUPTA 15-JAN-2001 115.0 Initial version.
71: ========================================================================

Line 155: table_id pay_dated_tables.dated_table_id%TYPE ,

151: *** be used in caching.
152: ***/
153: TYPE t_distinct_table_rec IS RECORD
154: (
155: table_id pay_dated_tables.dated_table_id%TYPE ,
156: table_name pay_dated_tables.table_name%TYPE ,
157: owner pay_dated_tables.owner%TYPE ,
158: dyt_type pay_dated_tables.dyn_trigger_type%TYPE ,
159: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,

Line 156: table_name pay_dated_tables.table_name%TYPE ,

152: ***/
153: TYPE t_distinct_table_rec IS RECORD
154: (
155: table_id pay_dated_tables.dated_table_id%TYPE ,
156: table_name pay_dated_tables.table_name%TYPE ,
157: owner pay_dated_tables.owner%TYPE ,
158: dyt_type pay_dated_tables.dyn_trigger_type%TYPE ,
159: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,
160: start_date_name pay_dated_tables.start_date_name%TYPE ,

Line 157: owner pay_dated_tables.owner%TYPE ,

153: TYPE t_distinct_table_rec IS RECORD
154: (
155: table_id pay_dated_tables.dated_table_id%TYPE ,
156: table_name pay_dated_tables.table_name%TYPE ,
157: owner pay_dated_tables.owner%TYPE ,
158: dyt_type pay_dated_tables.dyn_trigger_type%TYPE ,
159: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,
160: start_date_name pay_dated_tables.start_date_name%TYPE ,
161: end_date_name pay_dated_tables.end_date_name%TYPE ,

Line 158: dyt_type pay_dated_tables.dyn_trigger_type%TYPE ,

154: (
155: table_id pay_dated_tables.dated_table_id%TYPE ,
156: table_name pay_dated_tables.table_name%TYPE ,
157: owner pay_dated_tables.owner%TYPE ,
158: dyt_type pay_dated_tables.dyn_trigger_type%TYPE ,
159: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,
160: start_date_name pay_dated_tables.start_date_name%TYPE ,
161: end_date_name pay_dated_tables.end_date_name%TYPE ,
162: datetracked_event_id pay_datetracked_events.datetracked_event_id%TYPE,

Line 159: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,

155: table_id pay_dated_tables.dated_table_id%TYPE ,
156: table_name pay_dated_tables.table_name%TYPE ,
157: owner pay_dated_tables.owner%TYPE ,
158: dyt_type pay_dated_tables.dyn_trigger_type%TYPE ,
159: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,
160: start_date_name pay_dated_tables.start_date_name%TYPE ,
161: end_date_name pay_dated_tables.end_date_name%TYPE ,
162: datetracked_event_id pay_datetracked_events.datetracked_event_id%TYPE,
163: column_name pay_datetracked_events.column_name%TYPE ,

Line 160: start_date_name pay_dated_tables.start_date_name%TYPE ,

156: table_name pay_dated_tables.table_name%TYPE ,
157: owner pay_dated_tables.owner%TYPE ,
158: dyt_type pay_dated_tables.dyn_trigger_type%TYPE ,
159: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,
160: start_date_name pay_dated_tables.start_date_name%TYPE ,
161: end_date_name pay_dated_tables.end_date_name%TYPE ,
162: datetracked_event_id pay_datetracked_events.datetracked_event_id%TYPE,
163: column_name pay_datetracked_events.column_name%TYPE ,
164: update_type pay_datetracked_events.update_type%TYPE ,

Line 161: end_date_name pay_dated_tables.end_date_name%TYPE ,

157: owner pay_dated_tables.owner%TYPE ,
158: dyt_type pay_dated_tables.dyn_trigger_type%TYPE ,
159: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,
160: start_date_name pay_dated_tables.start_date_name%TYPE ,
161: end_date_name pay_dated_tables.end_date_name%TYPE ,
162: datetracked_event_id pay_datetracked_events.datetracked_event_id%TYPE,
163: column_name pay_datetracked_events.column_name%TYPE ,
164: update_type pay_datetracked_events.update_type%TYPE ,
165: proration_type pay_datetracked_events.proration_style%TYPE

Line 174: dated_table_id pay_dated_tables.dated_table_id%TYPE ,

170: t_distinct_tab t_distinct_table ;
171:
172: TYPE t_detailed_output_tab_rec IS RECORD
173: (
174: dated_table_id pay_dated_tables.dated_table_id%TYPE ,
175: datetracked_event pay_datetracked_events.datetracked_event_id%TYPE ,
176: update_type pay_datetracked_events.update_type%TYPE ,
177: surrogate_key pay_process_events.surrogate_key%type ,
178: column_name pay_event_updates.column_name%TYPE ,

Line 454: table_name pay_dated_tables.table_name%TYPE

450: change_values pay_process_events.description%type,
451: calculation_date pay_process_events.calculation_date%type,
452: creation_date pay_process_events.creation_date%type,
453: change_mode pay_process_events.change_type%type,
454: table_name pay_dated_tables.table_name%TYPE
455: );
456:
457: --used in extra_tests_dbt_i and extra_tests_dbt_p
458: TYPE t_key_date_cache_rec is record