DBA Data[Home] [Help]

APPS.BEN_PTNL_LER_FOR_PER_API dependencies on HR_API

Line 200: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number

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

Line 201: ,p_lf_evt_ocrd_dt in date default hr_api.g_date

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

Line 202: ,p_trgr_table_pk_id in number default hr_api.g_number

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

Line 203: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2

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

Line 204: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2

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

Line 205: ,p_mnl_dt in date default hr_api.g_date

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

Line 206: ,p_enrt_perd_id in number default hr_api.g_number

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

Line 207: ,p_ler_id in number default hr_api.g_number

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

Line 208: ,p_person_id in number default hr_api.g_number

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

Line 209: ,p_business_group_id in number default hr_api.g_number

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

Line 210: ,p_dtctd_dt in date default hr_api.g_date

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

Line 211: ,p_procd_dt in date default hr_api.g_date

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

Line 212: ,p_unprocd_dt in date default hr_api.g_date

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

Line 213: ,p_voidd_dt in date default hr_api.g_date

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

Line 214: ,p_mnlo_dt in date default hr_api.g_date

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

Line 215: ,p_ntfn_dt in date default hr_api.g_date

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

Line 216: ,p_request_id in number default hr_api.g_number

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

Line 217: ,p_program_application_id in number default hr_api.g_number

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

Line 218: ,p_program_id in number default hr_api.g_number

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

Line 219: ,p_program_update_date in date default hr_api.g_date

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

Line 273: ,p_csd_by_ptnl_ler_for_per_id in number default hr_api.g_number

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

Line 274: ,p_lf_evt_ocrd_dt in date default hr_api.g_date

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

Line 275: ,p_trgr_table_pk_id in number default hr_api.g_number

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

Line 276: ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2

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

Line 277: ,p_ptnl_ler_for_per_src_cd in varchar2 default hr_api.g_varchar2

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

Line 278: ,p_mnl_dt in date default hr_api.g_date

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

Line 279: ,p_enrt_perd_id in number default hr_api.g_number

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

Line 280: ,p_ler_id in number default hr_api.g_number

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

Line 281: ,p_person_id in number default hr_api.g_number

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

Line 282: ,p_business_group_id in number default hr_api.g_number

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

Line 283: ,p_dtctd_dt in date default hr_api.g_date

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

Line 284: ,p_procd_dt in date default hr_api.g_date

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

Line 285: ,p_unprocd_dt in date default hr_api.g_date

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

Line 286: ,p_voidd_dt in date default hr_api.g_date

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

Line 287: ,p_mnlo_dt in date default hr_api.g_date

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

Line 288: ,p_ntfn_dt in date default hr_api.g_date

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

Line 289: ,p_request_id in number default hr_api.g_number

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

Line 290: ,p_program_application_id in number default hr_api.g_number

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

Line 291: ,p_program_id in number default hr_api.g_number

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

Line 292: ,p_program_update_date in date default hr_api.g_date

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