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.PQP_NL_PENSION_EXTRACTS dependencies on BEN_EXT_CHG_EVT_LOG

Line 203: (old_start ben_ext_chg_evt_log.old_val1%TYPE

199: TYPE t_asg_seq IS TABLE OF assignment_seq_rec_type INDEX BY Binary_Integer;
200: g_assignment_seq_rec t_asg_seq;
201:
202: TYPE date_rows IS RECORD
203: (old_start ben_ext_chg_evt_log.old_val1%TYPE
204: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
205: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
206: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
207: );

Line 204: ,new_start ben_ext_chg_evt_log.new_val1%TYPE

200: g_assignment_seq_rec t_asg_seq;
201:
202: TYPE date_rows IS RECORD
203: (old_start ben_ext_chg_evt_log.old_val1%TYPE
204: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
205: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
206: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
207: );
208: TYPE t_date_rows IS TABLE OF date_rows INDEX BY Binary_Integer;

Line 205: ,old_end ben_ext_chg_evt_log.old_val2%TYPE

201:
202: TYPE date_rows IS RECORD
203: (old_start ben_ext_chg_evt_log.old_val1%TYPE
204: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
205: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
206: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
207: );
208: TYPE t_date_rows IS TABLE OF date_rows INDEX BY Binary_Integer;
209:

Line 206: ,new_end ben_ext_chg_evt_log.new_val2%TYPE

202: TYPE date_rows IS RECORD
203: (old_start ben_ext_chg_evt_log.old_val1%TYPE
204: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
205: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
206: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
207: );
208: TYPE t_date_rows IS TABLE OF date_rows INDEX BY Binary_Integer;
209:
210: g_fur_dates t_date_rows;

Line 214: (old_start ben_ext_chg_evt_log.old_val1%TYPE

210: g_fur_dates t_date_rows;
211: g_ipap_dates t_date_rows;
212:
213: TYPE rec_05_rows IS RECORD
214: (old_start ben_ext_chg_evt_log.old_val1%TYPE
215: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
216: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
217: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
218: ,partn_kind varchar2(30)

Line 215: ,new_start ben_ext_chg_evt_log.new_val1%TYPE

211: g_ipap_dates t_date_rows;
212:
213: TYPE rec_05_rows IS RECORD
214: (old_start ben_ext_chg_evt_log.old_val1%TYPE
215: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
216: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
217: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
218: ,partn_kind varchar2(30)
219: ,partn_value varchar2(30)

Line 216: ,old_end ben_ext_chg_evt_log.old_val2%TYPE

212:
213: TYPE rec_05_rows IS RECORD
214: (old_start ben_ext_chg_evt_log.old_val1%TYPE
215: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
216: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
217: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
218: ,partn_kind varchar2(30)
219: ,partn_value varchar2(30)
220: ,dt_chg ben_ext_chg_evt_log.prmtr_07%TYPE

Line 217: ,new_end ben_ext_chg_evt_log.new_val2%TYPE

213: TYPE rec_05_rows IS RECORD
214: (old_start ben_ext_chg_evt_log.old_val1%TYPE
215: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
216: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
217: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
218: ,partn_kind varchar2(30)
219: ,partn_value varchar2(30)
220: ,dt_chg ben_ext_chg_evt_log.prmtr_07%TYPE
221: ,eddt_chg ben_ext_chg_evt_log.prmtr_07%TYPE

Line 220: ,dt_chg ben_ext_chg_evt_log.prmtr_07%TYPE

216: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
217: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
218: ,partn_kind varchar2(30)
219: ,partn_value varchar2(30)
220: ,dt_chg ben_ext_chg_evt_log.prmtr_07%TYPE
221: ,eddt_chg ben_ext_chg_evt_log.prmtr_07%TYPE
222: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE
223: ,part_time_perc number(9,2)
224: ,ppp_kind varchar2(1)

Line 221: ,eddt_chg ben_ext_chg_evt_log.prmtr_07%TYPE

217: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
218: ,partn_kind varchar2(30)
219: ,partn_value varchar2(30)
220: ,dt_chg ben_ext_chg_evt_log.prmtr_07%TYPE
221: ,eddt_chg ben_ext_chg_evt_log.prmtr_07%TYPE
222: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE
223: ,part_time_perc number(9,2)
224: ,ppp_kind varchar2(1)
225: ,opnp_kind varchar2(1)

Line 222: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE

218: ,partn_kind varchar2(30)
219: ,partn_value varchar2(30)
220: ,dt_chg ben_ext_chg_evt_log.prmtr_07%TYPE
221: ,eddt_chg ben_ext_chg_evt_log.prmtr_07%TYPE
222: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE
223: ,part_time_perc number(9,2)
224: ,ppp_kind varchar2(1)
225: ,opnp_kind varchar2(1)
226: ,fpu_kind varchar2(1)

Line 234: (start_date ben_ext_chg_evt_log.new_val1%TYPE

230:
231: g_rec05_rows t_rec_05_rows;
232:
233: TYPE si_date_rows IS RECORD
234: (start_date ben_ext_chg_evt_log.new_val1%TYPE
235: ,end_date ben_ext_chg_evt_log.new_val2%TYPE
236: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
237: ,old_start ben_ext_chg_evt_log.old_val1%TYPE
238: ,new_end ben_ext_chg_evt_log.new_val2%TYPE

Line 235: ,end_date ben_ext_chg_evt_log.new_val2%TYPE

231: g_rec05_rows t_rec_05_rows;
232:
233: TYPE si_date_rows IS RECORD
234: (start_date ben_ext_chg_evt_log.new_val1%TYPE
235: ,end_date ben_ext_chg_evt_log.new_val2%TYPE
236: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
237: ,old_start ben_ext_chg_evt_log.old_val1%TYPE
238: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
239: ,old_end ben_ext_chg_evt_log.old_val2%TYPE

Line 236: ,new_start ben_ext_chg_evt_log.new_val1%TYPE

232:
233: TYPE si_date_rows IS RECORD
234: (start_date ben_ext_chg_evt_log.new_val1%TYPE
235: ,end_date ben_ext_chg_evt_log.new_val2%TYPE
236: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
237: ,old_start ben_ext_chg_evt_log.old_val1%TYPE
238: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
239: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
240: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE

Line 237: ,old_start ben_ext_chg_evt_log.old_val1%TYPE

233: TYPE si_date_rows IS RECORD
234: (start_date ben_ext_chg_evt_log.new_val1%TYPE
235: ,end_date ben_ext_chg_evt_log.new_val2%TYPE
236: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
237: ,old_start ben_ext_chg_evt_log.old_val1%TYPE
238: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
239: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
240: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE
241: ,part_time_perc NUMBER(9,2)

Line 238: ,new_end ben_ext_chg_evt_log.new_val2%TYPE

234: (start_date ben_ext_chg_evt_log.new_val1%TYPE
235: ,end_date ben_ext_chg_evt_log.new_val2%TYPE
236: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
237: ,old_start ben_ext_chg_evt_log.old_val1%TYPE
238: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
239: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
240: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE
241: ,part_time_perc NUMBER(9,2)
242: ,display_si_flag VARCHAR2(1)

Line 239: ,old_end ben_ext_chg_evt_log.old_val2%TYPE

235: ,end_date ben_ext_chg_evt_log.new_val2%TYPE
236: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
237: ,old_start ben_ext_chg_evt_log.old_val1%TYPE
238: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
239: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
240: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE
241: ,part_time_perc NUMBER(9,2)
242: ,display_si_flag VARCHAR2(1)
243: );

Line 240: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE

236: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
237: ,old_start ben_ext_chg_evt_log.old_val1%TYPE
238: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
239: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
240: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE
241: ,part_time_perc NUMBER(9,2)
242: ,display_si_flag VARCHAR2(1)
243: );
244: TYPE t_si_date_rows IS TABLE OF si_date_rows INDEX BY Binary_Integer;