DBA Data[Home] [Help]

APPS.BEN_COBJ_CACHE dependencies on BEN_PRTN_ELIG_F

Line 369: (prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type

365: ,p_inst_row in out NOCOPY g_etpr_inst_row
366: );
367: --
368: type g_prel_inst_row is record
369: (prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type
370: ,effective_start_date ben_prtn_elig_f.effective_start_date%type
371: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
372: ,pgm_id ben_prtn_elig_f.pgm_id%type
373: ,ptip_id ben_prtn_elig_f.ptip_id%type

Line 370: ,effective_start_date ben_prtn_elig_f.effective_start_date%type

366: );
367: --
368: type g_prel_inst_row is record
369: (prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type
370: ,effective_start_date ben_prtn_elig_f.effective_start_date%type
371: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
372: ,pgm_id ben_prtn_elig_f.pgm_id%type
373: ,ptip_id ben_prtn_elig_f.ptip_id%type
374: ,plip_id ben_prtn_elig_f.plip_id%type

Line 371: ,effective_end_date ben_prtn_elig_f.effective_end_date%type

367: --
368: type g_prel_inst_row is record
369: (prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type
370: ,effective_start_date ben_prtn_elig_f.effective_start_date%type
371: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
372: ,pgm_id ben_prtn_elig_f.pgm_id%type
373: ,ptip_id ben_prtn_elig_f.ptip_id%type
374: ,plip_id ben_prtn_elig_f.plip_id%type
375: ,pl_id ben_prtn_elig_f.pl_id%type

Line 372: ,pgm_id ben_prtn_elig_f.pgm_id%type

368: type g_prel_inst_row is record
369: (prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type
370: ,effective_start_date ben_prtn_elig_f.effective_start_date%type
371: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
372: ,pgm_id ben_prtn_elig_f.pgm_id%type
373: ,ptip_id ben_prtn_elig_f.ptip_id%type
374: ,plip_id ben_prtn_elig_f.plip_id%type
375: ,pl_id ben_prtn_elig_f.pl_id%type
376: ,oipl_id ben_prtn_elig_f.oipl_id%type

Line 373: ,ptip_id ben_prtn_elig_f.ptip_id%type

369: (prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type
370: ,effective_start_date ben_prtn_elig_f.effective_start_date%type
371: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
372: ,pgm_id ben_prtn_elig_f.pgm_id%type
373: ,ptip_id ben_prtn_elig_f.ptip_id%type
374: ,plip_id ben_prtn_elig_f.plip_id%type
375: ,pl_id ben_prtn_elig_f.pl_id%type
376: ,oipl_id ben_prtn_elig_f.oipl_id%type
377: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type

Line 374: ,plip_id ben_prtn_elig_f.plip_id%type

370: ,effective_start_date ben_prtn_elig_f.effective_start_date%type
371: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
372: ,pgm_id ben_prtn_elig_f.pgm_id%type
373: ,ptip_id ben_prtn_elig_f.ptip_id%type
374: ,plip_id ben_prtn_elig_f.plip_id%type
375: ,pl_id ben_prtn_elig_f.pl_id%type
376: ,oipl_id ben_prtn_elig_f.oipl_id%type
377: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
378: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type

Line 375: ,pl_id ben_prtn_elig_f.pl_id%type

371: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
372: ,pgm_id ben_prtn_elig_f.pgm_id%type
373: ,ptip_id ben_prtn_elig_f.ptip_id%type
374: ,plip_id ben_prtn_elig_f.plip_id%type
375: ,pl_id ben_prtn_elig_f.pl_id%type
376: ,oipl_id ben_prtn_elig_f.oipl_id%type
377: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
378: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
379: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type

Line 376: ,oipl_id ben_prtn_elig_f.oipl_id%type

372: ,pgm_id ben_prtn_elig_f.pgm_id%type
373: ,ptip_id ben_prtn_elig_f.ptip_id%type
374: ,plip_id ben_prtn_elig_f.plip_id%type
375: ,pl_id ben_prtn_elig_f.pl_id%type
376: ,oipl_id ben_prtn_elig_f.oipl_id%type
377: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
378: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
379: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
380: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type

Line 377: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type

373: ,ptip_id ben_prtn_elig_f.ptip_id%type
374: ,plip_id ben_prtn_elig_f.plip_id%type
375: ,pl_id ben_prtn_elig_f.pl_id%type
376: ,oipl_id ben_prtn_elig_f.oipl_id%type
377: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
378: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
379: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
380: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
381: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type

Line 378: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type

374: ,plip_id ben_prtn_elig_f.plip_id%type
375: ,pl_id ben_prtn_elig_f.pl_id%type
376: ,oipl_id ben_prtn_elig_f.oipl_id%type
377: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
378: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
379: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
380: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
381: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
382: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type

Line 379: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type

375: ,pl_id ben_prtn_elig_f.pl_id%type
376: ,oipl_id ben_prtn_elig_f.oipl_id%type
377: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
378: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
379: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
380: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
381: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
382: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
383: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type

Line 380: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type

376: ,oipl_id ben_prtn_elig_f.oipl_id%type
377: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
378: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
379: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
380: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
381: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
382: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
383: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
384: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type

Line 381: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type

377: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
378: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
379: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
380: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
381: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
382: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
383: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
384: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type
385: ,prtn_eff_end_dt_cd ben_prtn_elig_f.prtn_eff_end_dt_cd%type

Line 382: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type

378: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
379: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
380: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
381: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
382: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
383: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
384: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type
385: ,prtn_eff_end_dt_cd ben_prtn_elig_f.prtn_eff_end_dt_cd%type
386: );

Line 383: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type

379: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
380: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
381: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
382: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
383: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
384: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type
385: ,prtn_eff_end_dt_cd ben_prtn_elig_f.prtn_eff_end_dt_cd%type
386: );
387: --

Line 384: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type

380: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
381: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
382: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
383: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
384: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type
385: ,prtn_eff_end_dt_cd ben_prtn_elig_f.prtn_eff_end_dt_cd%type
386: );
387: --
388: type g_prel_inst_tbl is table of g_prel_inst_row

Line 385: ,prtn_eff_end_dt_cd ben_prtn_elig_f.prtn_eff_end_dt_cd%type

381: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
382: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
383: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
384: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type
385: ,prtn_eff_end_dt_cd ben_prtn_elig_f.prtn_eff_end_dt_cd%type
386: );
387: --
388: type g_prel_inst_tbl is table of g_prel_inst_row
389: index by binary_integer;