DBA Data[Home] [Help]

APPS.BEN_COBJ_CACHE dependencies on BEN_PRTN_ELIG_F

Line 376: (prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type

372: ,p_inst_row in out NOCOPY g_etpr_inst_row
373: );
374: --
375: type g_prel_inst_row is record
376: (prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type
377: ,effective_start_date ben_prtn_elig_f.effective_start_date%type
378: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
379: ,pgm_id ben_prtn_elig_f.pgm_id%type
380: ,ptip_id ben_prtn_elig_f.ptip_id%type

Line 377: ,effective_start_date ben_prtn_elig_f.effective_start_date%type

373: );
374: --
375: type g_prel_inst_row is record
376: (prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type
377: ,effective_start_date ben_prtn_elig_f.effective_start_date%type
378: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
379: ,pgm_id ben_prtn_elig_f.pgm_id%type
380: ,ptip_id ben_prtn_elig_f.ptip_id%type
381: ,plip_id ben_prtn_elig_f.plip_id%type

Line 378: ,effective_end_date ben_prtn_elig_f.effective_end_date%type

374: --
375: type g_prel_inst_row is record
376: (prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type
377: ,effective_start_date ben_prtn_elig_f.effective_start_date%type
378: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
379: ,pgm_id ben_prtn_elig_f.pgm_id%type
380: ,ptip_id ben_prtn_elig_f.ptip_id%type
381: ,plip_id ben_prtn_elig_f.plip_id%type
382: ,pl_id ben_prtn_elig_f.pl_id%type

Line 379: ,pgm_id ben_prtn_elig_f.pgm_id%type

375: type g_prel_inst_row is record
376: (prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type
377: ,effective_start_date ben_prtn_elig_f.effective_start_date%type
378: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
379: ,pgm_id ben_prtn_elig_f.pgm_id%type
380: ,ptip_id ben_prtn_elig_f.ptip_id%type
381: ,plip_id ben_prtn_elig_f.plip_id%type
382: ,pl_id ben_prtn_elig_f.pl_id%type
383: ,oipl_id ben_prtn_elig_f.oipl_id%type

Line 380: ,ptip_id ben_prtn_elig_f.ptip_id%type

376: (prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type
377: ,effective_start_date ben_prtn_elig_f.effective_start_date%type
378: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
379: ,pgm_id ben_prtn_elig_f.pgm_id%type
380: ,ptip_id ben_prtn_elig_f.ptip_id%type
381: ,plip_id ben_prtn_elig_f.plip_id%type
382: ,pl_id ben_prtn_elig_f.pl_id%type
383: ,oipl_id ben_prtn_elig_f.oipl_id%type
384: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type

Line 381: ,plip_id ben_prtn_elig_f.plip_id%type

377: ,effective_start_date ben_prtn_elig_f.effective_start_date%type
378: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
379: ,pgm_id ben_prtn_elig_f.pgm_id%type
380: ,ptip_id ben_prtn_elig_f.ptip_id%type
381: ,plip_id ben_prtn_elig_f.plip_id%type
382: ,pl_id ben_prtn_elig_f.pl_id%type
383: ,oipl_id ben_prtn_elig_f.oipl_id%type
384: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
385: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type

Line 382: ,pl_id ben_prtn_elig_f.pl_id%type

378: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
379: ,pgm_id ben_prtn_elig_f.pgm_id%type
380: ,ptip_id ben_prtn_elig_f.ptip_id%type
381: ,plip_id ben_prtn_elig_f.plip_id%type
382: ,pl_id ben_prtn_elig_f.pl_id%type
383: ,oipl_id ben_prtn_elig_f.oipl_id%type
384: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
385: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
386: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type

Line 383: ,oipl_id ben_prtn_elig_f.oipl_id%type

379: ,pgm_id ben_prtn_elig_f.pgm_id%type
380: ,ptip_id ben_prtn_elig_f.ptip_id%type
381: ,plip_id ben_prtn_elig_f.plip_id%type
382: ,pl_id ben_prtn_elig_f.pl_id%type
383: ,oipl_id ben_prtn_elig_f.oipl_id%type
384: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
385: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
386: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
387: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type

Line 384: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type

380: ,ptip_id ben_prtn_elig_f.ptip_id%type
381: ,plip_id ben_prtn_elig_f.plip_id%type
382: ,pl_id ben_prtn_elig_f.pl_id%type
383: ,oipl_id ben_prtn_elig_f.oipl_id%type
384: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
385: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
386: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
387: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
388: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type

Line 385: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type

381: ,plip_id ben_prtn_elig_f.plip_id%type
382: ,pl_id ben_prtn_elig_f.pl_id%type
383: ,oipl_id ben_prtn_elig_f.oipl_id%type
384: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
385: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
386: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
387: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
388: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
389: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type

Line 386: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type

382: ,pl_id ben_prtn_elig_f.pl_id%type
383: ,oipl_id ben_prtn_elig_f.oipl_id%type
384: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
385: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
386: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
387: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
388: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
389: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
390: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type

Line 387: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type

383: ,oipl_id ben_prtn_elig_f.oipl_id%type
384: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
385: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
386: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
387: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
388: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
389: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
390: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
391: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type

Line 388: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type

384: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
385: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
386: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
387: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
388: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
389: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
390: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
391: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type
392: ,prtn_eff_end_dt_cd ben_prtn_elig_f.prtn_eff_end_dt_cd%type

Line 389: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type

385: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
386: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
387: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
388: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
389: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
390: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
391: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type
392: ,prtn_eff_end_dt_cd ben_prtn_elig_f.prtn_eff_end_dt_cd%type
393: );

Line 390: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type

386: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
387: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
388: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
389: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
390: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
391: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type
392: ,prtn_eff_end_dt_cd ben_prtn_elig_f.prtn_eff_end_dt_cd%type
393: );
394: --

Line 391: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type

387: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
388: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
389: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
390: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
391: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type
392: ,prtn_eff_end_dt_cd ben_prtn_elig_f.prtn_eff_end_dt_cd%type
393: );
394: --
395: type g_prel_inst_tbl is table of g_prel_inst_row

Line 392: ,prtn_eff_end_dt_cd ben_prtn_elig_f.prtn_eff_end_dt_cd%type

388: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
389: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
390: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
391: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type
392: ,prtn_eff_end_dt_cd ben_prtn_elig_f.prtn_eff_end_dt_cd%type
393: );
394: --
395: type g_prel_inst_tbl is table of g_prel_inst_row
396: index by binary_integer;