DBA Data[Home] [Help]

APPS.BEN_PTNL_LER_FOR_PER_API dependencies on HR_API

Line 202: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number

198: --
199: procedure update_ptnl_ler_for_per
200: (p_validate in boolean default false
201: ,p_ptnl_ler_for_per_id in number
202: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
203: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
204: ,p_trgr_table_pk_id in number default hr_api.g_number
205: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
206: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2

Line 203: ,p_lf_evt_ocrd_dt in date default hr_api.g_date

199: procedure update_ptnl_ler_for_per
200: (p_validate in boolean default false
201: ,p_ptnl_ler_for_per_id in number
202: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
203: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
204: ,p_trgr_table_pk_id in number default hr_api.g_number
205: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
206: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
207: ,p_mnl_dt in date default hr_api.g_date

Line 204: ,p_trgr_table_pk_id in number default hr_api.g_number

200: (p_validate in boolean default false
201: ,p_ptnl_ler_for_per_id in number
202: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
203: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
204: ,p_trgr_table_pk_id in number default hr_api.g_number
205: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
206: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
207: ,p_mnl_dt in date default hr_api.g_date
208: ,p_enrt_perd_id in number default hr_api.g_number

Line 205: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2

201: ,p_ptnl_ler_for_per_id in number
202: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
203: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
204: ,p_trgr_table_pk_id in number default hr_api.g_number
205: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
206: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
207: ,p_mnl_dt in date default hr_api.g_date
208: ,p_enrt_perd_id in number default hr_api.g_number
209: ,p_ler_id in number default hr_api.g_number

Line 206: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2

202: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
203: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
204: ,p_trgr_table_pk_id in number default hr_api.g_number
205: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
206: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
207: ,p_mnl_dt in date default hr_api.g_date
208: ,p_enrt_perd_id in number default hr_api.g_number
209: ,p_ler_id in number default hr_api.g_number
210: ,p_person_id in number default hr_api.g_number

Line 207: ,p_mnl_dt in date default hr_api.g_date

203: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
204: ,p_trgr_table_pk_id in number default hr_api.g_number
205: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
206: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
207: ,p_mnl_dt in date default hr_api.g_date
208: ,p_enrt_perd_id in number default hr_api.g_number
209: ,p_ler_id in number default hr_api.g_number
210: ,p_person_id in number default hr_api.g_number
211: ,p_business_group_id in number default hr_api.g_number

Line 208: ,p_enrt_perd_id in number default hr_api.g_number

204: ,p_trgr_table_pk_id in number default hr_api.g_number
205: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
206: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
207: ,p_mnl_dt in date default hr_api.g_date
208: ,p_enrt_perd_id in number default hr_api.g_number
209: ,p_ler_id in number default hr_api.g_number
210: ,p_person_id in number default hr_api.g_number
211: ,p_business_group_id in number default hr_api.g_number
212: ,p_dtctd_dt in date default hr_api.g_date

Line 209: ,p_ler_id in number default hr_api.g_number

205: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
206: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
207: ,p_mnl_dt in date default hr_api.g_date
208: ,p_enrt_perd_id in number default hr_api.g_number
209: ,p_ler_id in number default hr_api.g_number
210: ,p_person_id in number default hr_api.g_number
211: ,p_business_group_id in number default hr_api.g_number
212: ,p_dtctd_dt in date default hr_api.g_date
213: ,p_procd_dt in date default hr_api.g_date

Line 210: ,p_person_id in number default hr_api.g_number

206: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
207: ,p_mnl_dt in date default hr_api.g_date
208: ,p_enrt_perd_id in number default hr_api.g_number
209: ,p_ler_id in number default hr_api.g_number
210: ,p_person_id in number default hr_api.g_number
211: ,p_business_group_id in number default hr_api.g_number
212: ,p_dtctd_dt in date default hr_api.g_date
213: ,p_procd_dt in date default hr_api.g_date
214: ,p_unprocd_dt in date default hr_api.g_date

Line 211: ,p_business_group_id in number default hr_api.g_number

207: ,p_mnl_dt in date default hr_api.g_date
208: ,p_enrt_perd_id in number default hr_api.g_number
209: ,p_ler_id in number default hr_api.g_number
210: ,p_person_id in number default hr_api.g_number
211: ,p_business_group_id in number default hr_api.g_number
212: ,p_dtctd_dt in date default hr_api.g_date
213: ,p_procd_dt in date default hr_api.g_date
214: ,p_unprocd_dt in date default hr_api.g_date
215: ,p_voidd_dt in date default hr_api.g_date

Line 212: ,p_dtctd_dt in date default hr_api.g_date

208: ,p_enrt_perd_id in number default hr_api.g_number
209: ,p_ler_id in number default hr_api.g_number
210: ,p_person_id in number default hr_api.g_number
211: ,p_business_group_id in number default hr_api.g_number
212: ,p_dtctd_dt in date default hr_api.g_date
213: ,p_procd_dt in date default hr_api.g_date
214: ,p_unprocd_dt in date default hr_api.g_date
215: ,p_voidd_dt in date default hr_api.g_date
216: ,p_mnlo_dt in date default hr_api.g_date

Line 213: ,p_procd_dt in date default hr_api.g_date

209: ,p_ler_id in number default hr_api.g_number
210: ,p_person_id in number default hr_api.g_number
211: ,p_business_group_id in number default hr_api.g_number
212: ,p_dtctd_dt in date default hr_api.g_date
213: ,p_procd_dt in date default hr_api.g_date
214: ,p_unprocd_dt in date default hr_api.g_date
215: ,p_voidd_dt in date default hr_api.g_date
216: ,p_mnlo_dt in date default hr_api.g_date
217: ,p_ntfn_dt in date default hr_api.g_date

Line 214: ,p_unprocd_dt in date default hr_api.g_date

210: ,p_person_id in number default hr_api.g_number
211: ,p_business_group_id in number default hr_api.g_number
212: ,p_dtctd_dt in date default hr_api.g_date
213: ,p_procd_dt in date default hr_api.g_date
214: ,p_unprocd_dt in date default hr_api.g_date
215: ,p_voidd_dt in date default hr_api.g_date
216: ,p_mnlo_dt in date default hr_api.g_date
217: ,p_ntfn_dt in date default hr_api.g_date
218: ,p_request_id in number default hr_api.g_number

Line 215: ,p_voidd_dt in date default hr_api.g_date

211: ,p_business_group_id in number default hr_api.g_number
212: ,p_dtctd_dt in date default hr_api.g_date
213: ,p_procd_dt in date default hr_api.g_date
214: ,p_unprocd_dt in date default hr_api.g_date
215: ,p_voidd_dt in date default hr_api.g_date
216: ,p_mnlo_dt in date default hr_api.g_date
217: ,p_ntfn_dt in date default hr_api.g_date
218: ,p_request_id in number default hr_api.g_number
219: ,p_program_application_id in number default hr_api.g_number

Line 216: ,p_mnlo_dt in date default hr_api.g_date

212: ,p_dtctd_dt in date default hr_api.g_date
213: ,p_procd_dt in date default hr_api.g_date
214: ,p_unprocd_dt in date default hr_api.g_date
215: ,p_voidd_dt in date default hr_api.g_date
216: ,p_mnlo_dt in date default hr_api.g_date
217: ,p_ntfn_dt in date default hr_api.g_date
218: ,p_request_id in number default hr_api.g_number
219: ,p_program_application_id in number default hr_api.g_number
220: ,p_program_id in number default hr_api.g_number

Line 217: ,p_ntfn_dt in date default hr_api.g_date

213: ,p_procd_dt in date default hr_api.g_date
214: ,p_unprocd_dt in date default hr_api.g_date
215: ,p_voidd_dt in date default hr_api.g_date
216: ,p_mnlo_dt in date default hr_api.g_date
217: ,p_ntfn_dt in date default hr_api.g_date
218: ,p_request_id in number default hr_api.g_number
219: ,p_program_application_id in number default hr_api.g_number
220: ,p_program_id in number default hr_api.g_number
221: ,p_program_update_date in date default hr_api.g_date

Line 218: ,p_request_id in number default hr_api.g_number

214: ,p_unprocd_dt in date default hr_api.g_date
215: ,p_voidd_dt in date default hr_api.g_date
216: ,p_mnlo_dt in date default hr_api.g_date
217: ,p_ntfn_dt in date default hr_api.g_date
218: ,p_request_id in number default hr_api.g_number
219: ,p_program_application_id in number default hr_api.g_number
220: ,p_program_id in number default hr_api.g_number
221: ,p_program_update_date in date default hr_api.g_date
222: ,p_object_version_number in out nocopy number

Line 219: ,p_program_application_id in number default hr_api.g_number

215: ,p_voidd_dt in date default hr_api.g_date
216: ,p_mnlo_dt in date default hr_api.g_date
217: ,p_ntfn_dt in date default hr_api.g_date
218: ,p_request_id in number default hr_api.g_number
219: ,p_program_application_id in number default hr_api.g_number
220: ,p_program_id in number default hr_api.g_number
221: ,p_program_update_date in date default hr_api.g_date
222: ,p_object_version_number in out nocopy number
223: ,p_effective_date in date);

Line 220: ,p_program_id in number default hr_api.g_number

216: ,p_mnlo_dt in date default hr_api.g_date
217: ,p_ntfn_dt in date default hr_api.g_date
218: ,p_request_id in number default hr_api.g_number
219: ,p_program_application_id in number default hr_api.g_number
220: ,p_program_id in number default hr_api.g_number
221: ,p_program_update_date in date default hr_api.g_date
222: ,p_object_version_number in out nocopy number
223: ,p_effective_date in date);
224: --

Line 221: ,p_program_update_date in date default hr_api.g_date

217: ,p_ntfn_dt in date default hr_api.g_date
218: ,p_request_id in number default hr_api.g_number
219: ,p_program_application_id in number default hr_api.g_number
220: ,p_program_id in number default hr_api.g_number
221: ,p_program_update_date in date default hr_api.g_date
222: ,p_object_version_number in out nocopy number
223: ,p_effective_date in date);
224: --
225: -- ----------------------------------------------------------------------------

Line 275: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number

271: --
272: procedure update_ptnl_ler_for_per_perf
273: (p_validate in boolean default false
274: ,p_ptnl_ler_for_per_id in number
275: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
276: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
277: ,p_trgr_table_pk_id in number default hr_api.g_number
278: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
279: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2

Line 276: ,p_lf_evt_ocrd_dt in date default hr_api.g_date

272: procedure update_ptnl_ler_for_per_perf
273: (p_validate in boolean default false
274: ,p_ptnl_ler_for_per_id in number
275: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
276: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
277: ,p_trgr_table_pk_id in number default hr_api.g_number
278: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
279: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
280: ,p_mnl_dt in date default hr_api.g_date

Line 277: ,p_trgr_table_pk_id in number default hr_api.g_number

273: (p_validate in boolean default false
274: ,p_ptnl_ler_for_per_id in number
275: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
276: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
277: ,p_trgr_table_pk_id in number default hr_api.g_number
278: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
279: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
280: ,p_mnl_dt in date default hr_api.g_date
281: ,p_enrt_perd_id in number default hr_api.g_number

Line 278: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2

274: ,p_ptnl_ler_for_per_id in number
275: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
276: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
277: ,p_trgr_table_pk_id in number default hr_api.g_number
278: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
279: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
280: ,p_mnl_dt in date default hr_api.g_date
281: ,p_enrt_perd_id in number default hr_api.g_number
282: ,p_ler_id in number default hr_api.g_number

Line 279: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2

275: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number
276: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
277: ,p_trgr_table_pk_id in number default hr_api.g_number
278: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
279: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
280: ,p_mnl_dt in date default hr_api.g_date
281: ,p_enrt_perd_id in number default hr_api.g_number
282: ,p_ler_id in number default hr_api.g_number
283: ,p_person_id in number default hr_api.g_number

Line 280: ,p_mnl_dt in date default hr_api.g_date

276: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
277: ,p_trgr_table_pk_id in number default hr_api.g_number
278: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
279: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
280: ,p_mnl_dt in date default hr_api.g_date
281: ,p_enrt_perd_id in number default hr_api.g_number
282: ,p_ler_id in number default hr_api.g_number
283: ,p_person_id in number default hr_api.g_number
284: ,p_business_group_id in number default hr_api.g_number

Line 281: ,p_enrt_perd_id in number default hr_api.g_number

277: ,p_trgr_table_pk_id in number default hr_api.g_number
278: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
279: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
280: ,p_mnl_dt in date default hr_api.g_date
281: ,p_enrt_perd_id in number default hr_api.g_number
282: ,p_ler_id in number default hr_api.g_number
283: ,p_person_id in number default hr_api.g_number
284: ,p_business_group_id in number default hr_api.g_number
285: ,p_dtctd_dt in date default hr_api.g_date

Line 282: ,p_ler_id in number default hr_api.g_number

278: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
279: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
280: ,p_mnl_dt in date default hr_api.g_date
281: ,p_enrt_perd_id in number default hr_api.g_number
282: ,p_ler_id in number default hr_api.g_number
283: ,p_person_id in number default hr_api.g_number
284: ,p_business_group_id in number default hr_api.g_number
285: ,p_dtctd_dt in date default hr_api.g_date
286: ,p_procd_dt in date default hr_api.g_date

Line 283: ,p_person_id in number default hr_api.g_number

279: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2
280: ,p_mnl_dt in date default hr_api.g_date
281: ,p_enrt_perd_id in number default hr_api.g_number
282: ,p_ler_id in number default hr_api.g_number
283: ,p_person_id in number default hr_api.g_number
284: ,p_business_group_id in number default hr_api.g_number
285: ,p_dtctd_dt in date default hr_api.g_date
286: ,p_procd_dt in date default hr_api.g_date
287: ,p_unprocd_dt in date default hr_api.g_date

Line 284: ,p_business_group_id in number default hr_api.g_number

280: ,p_mnl_dt in date default hr_api.g_date
281: ,p_enrt_perd_id in number default hr_api.g_number
282: ,p_ler_id in number default hr_api.g_number
283: ,p_person_id in number default hr_api.g_number
284: ,p_business_group_id in number default hr_api.g_number
285: ,p_dtctd_dt in date default hr_api.g_date
286: ,p_procd_dt in date default hr_api.g_date
287: ,p_unprocd_dt in date default hr_api.g_date
288: ,p_voidd_dt in date default hr_api.g_date

Line 285: ,p_dtctd_dt in date default hr_api.g_date

281: ,p_enrt_perd_id in number default hr_api.g_number
282: ,p_ler_id in number default hr_api.g_number
283: ,p_person_id in number default hr_api.g_number
284: ,p_business_group_id in number default hr_api.g_number
285: ,p_dtctd_dt in date default hr_api.g_date
286: ,p_procd_dt in date default hr_api.g_date
287: ,p_unprocd_dt in date default hr_api.g_date
288: ,p_voidd_dt in date default hr_api.g_date
289: ,p_mnlo_dt in date default hr_api.g_date

Line 286: ,p_procd_dt in date default hr_api.g_date

282: ,p_ler_id in number default hr_api.g_number
283: ,p_person_id in number default hr_api.g_number
284: ,p_business_group_id in number default hr_api.g_number
285: ,p_dtctd_dt in date default hr_api.g_date
286: ,p_procd_dt in date default hr_api.g_date
287: ,p_unprocd_dt in date default hr_api.g_date
288: ,p_voidd_dt in date default hr_api.g_date
289: ,p_mnlo_dt in date default hr_api.g_date
290: ,p_ntfn_dt in date default hr_api.g_date

Line 287: ,p_unprocd_dt in date default hr_api.g_date

283: ,p_person_id in number default hr_api.g_number
284: ,p_business_group_id in number default hr_api.g_number
285: ,p_dtctd_dt in date default hr_api.g_date
286: ,p_procd_dt in date default hr_api.g_date
287: ,p_unprocd_dt in date default hr_api.g_date
288: ,p_voidd_dt in date default hr_api.g_date
289: ,p_mnlo_dt in date default hr_api.g_date
290: ,p_ntfn_dt in date default hr_api.g_date
291: ,p_request_id in number default hr_api.g_number

Line 288: ,p_voidd_dt in date default hr_api.g_date

284: ,p_business_group_id in number default hr_api.g_number
285: ,p_dtctd_dt in date default hr_api.g_date
286: ,p_procd_dt in date default hr_api.g_date
287: ,p_unprocd_dt in date default hr_api.g_date
288: ,p_voidd_dt in date default hr_api.g_date
289: ,p_mnlo_dt in date default hr_api.g_date
290: ,p_ntfn_dt in date default hr_api.g_date
291: ,p_request_id in number default hr_api.g_number
292: ,p_program_application_id in number default hr_api.g_number

Line 289: ,p_mnlo_dt in date default hr_api.g_date

285: ,p_dtctd_dt in date default hr_api.g_date
286: ,p_procd_dt in date default hr_api.g_date
287: ,p_unprocd_dt in date default hr_api.g_date
288: ,p_voidd_dt in date default hr_api.g_date
289: ,p_mnlo_dt in date default hr_api.g_date
290: ,p_ntfn_dt in date default hr_api.g_date
291: ,p_request_id in number default hr_api.g_number
292: ,p_program_application_id in number default hr_api.g_number
293: ,p_program_id in number default hr_api.g_number

Line 290: ,p_ntfn_dt in date default hr_api.g_date

286: ,p_procd_dt in date default hr_api.g_date
287: ,p_unprocd_dt in date default hr_api.g_date
288: ,p_voidd_dt in date default hr_api.g_date
289: ,p_mnlo_dt in date default hr_api.g_date
290: ,p_ntfn_dt in date default hr_api.g_date
291: ,p_request_id in number default hr_api.g_number
292: ,p_program_application_id in number default hr_api.g_number
293: ,p_program_id in number default hr_api.g_number
294: ,p_program_update_date in date default hr_api.g_date

Line 291: ,p_request_id in number default hr_api.g_number

287: ,p_unprocd_dt in date default hr_api.g_date
288: ,p_voidd_dt in date default hr_api.g_date
289: ,p_mnlo_dt in date default hr_api.g_date
290: ,p_ntfn_dt in date default hr_api.g_date
291: ,p_request_id in number default hr_api.g_number
292: ,p_program_application_id in number default hr_api.g_number
293: ,p_program_id in number default hr_api.g_number
294: ,p_program_update_date in date default hr_api.g_date
295: ,p_object_version_number in out nocopy number

Line 292: ,p_program_application_id in number default hr_api.g_number

288: ,p_voidd_dt in date default hr_api.g_date
289: ,p_mnlo_dt in date default hr_api.g_date
290: ,p_ntfn_dt in date default hr_api.g_date
291: ,p_request_id in number default hr_api.g_number
292: ,p_program_application_id in number default hr_api.g_number
293: ,p_program_id in number default hr_api.g_number
294: ,p_program_update_date in date default hr_api.g_date
295: ,p_object_version_number in out nocopy number
296: ,p_effective_date in date);

Line 293: ,p_program_id in number default hr_api.g_number

289: ,p_mnlo_dt in date default hr_api.g_date
290: ,p_ntfn_dt in date default hr_api.g_date
291: ,p_request_id in number default hr_api.g_number
292: ,p_program_application_id in number default hr_api.g_number
293: ,p_program_id in number default hr_api.g_number
294: ,p_program_update_date in date default hr_api.g_date
295: ,p_object_version_number in out nocopy number
296: ,p_effective_date in date);
297: --

Line 294: ,p_program_update_date in date default hr_api.g_date

290: ,p_ntfn_dt in date default hr_api.g_date
291: ,p_request_id in number default hr_api.g_number
292: ,p_program_application_id in number default hr_api.g_number
293: ,p_program_id in number default hr_api.g_number
294: ,p_program_update_date in date default hr_api.g_date
295: ,p_object_version_number in out nocopy number
296: ,p_effective_date in date);
297: --
298: -- ----------------------------------------------------------------------------