DBA Data[Home] [Help]

APPS.PQP_NL_PENSION_EXTRACTS dependencies on BEN_EXT_CHG_EVT_LOG

Line 201: (old_start ben_ext_chg_evt_log.old_val1%TYPE

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

Line 202: ,new_start ben_ext_chg_evt_log.new_val1%TYPE

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

Line 203: ,old_end ben_ext_chg_evt_log.old_val2%TYPE

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

Line 204: ,new_end ben_ext_chg_evt_log.new_val2%TYPE

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

Line 212: (old_start ben_ext_chg_evt_log.old_val1%TYPE

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

Line 213: ,new_start ben_ext_chg_evt_log.new_val1%TYPE

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

Line 214: ,old_end ben_ext_chg_evt_log.old_val2%TYPE

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

Line 215: ,new_end ben_ext_chg_evt_log.new_val2%TYPE

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

Line 218: ,dt_chg ben_ext_chg_evt_log.prmtr_07%TYPE

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

Line 219: ,eddt_chg ben_ext_chg_evt_log.prmtr_07%TYPE

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

Line 220: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE

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

Line 232: (start_date ben_ext_chg_evt_log.new_val1%TYPE

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

Line 233: ,end_date ben_ext_chg_evt_log.new_val2%TYPE

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

Line 234: ,new_start ben_ext_chg_evt_log.new_val1%TYPE

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

Line 235: ,old_start ben_ext_chg_evt_log.old_val1%TYPE

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

Line 236: ,new_end ben_ext_chg_evt_log.new_val2%TYPE

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

Line 237: ,old_end ben_ext_chg_evt_log.old_val2%TYPE

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

Line 238: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE

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