APPS.BEN_DETERMINE_DATE dependencies on BEN_PER_IN_LER

Line 184: from ben_per_in_ler pil,

180:
181: cursor c_mode
182: is
183: select 1
184: from ben_per_in_ler pil,
185: ben_ler_f ler
186: where pil.ler_id = ler.ler_id
187: and pil.per_in_ler_id=p_per_in_ler_id
188: and ler.typ_cd not like 'SCHED%'

Line 460: ,p_pil_row in ben_per_in_ler%rowtype

456: -- --------------------------------------------------------------------
457: function get_event_date
458: (p_cache_mode in boolean default false
459: /*
460: ,p_pil_row in ben_per_in_ler%rowtype
461: */
462: ,p_per_in_ler_id in number
463: ,p_effective_date in date
464: ) return date

Line 472: from ben_per_in_ler pil

468: --
469: cursor c_per_in_ler
470: is
471: select pil.lf_evt_ocrd_dt
472: from ben_per_in_ler pil
473: where pil.per_in_ler_id = p_per_in_ler_id;
474: --
475: begin
476: if p_per_in_ler_id is null then

Line 505: ,p_pil_row in ben_per_in_ler%rowtype

501: --
502: function get_recorded_date
503: (p_cache_mode in boolean default false
504: /*
505: ,p_pil_row in ben_per_in_ler%rowtype
506: */
507: ,p_per_in_ler_id in number
508: ,p_effective_date in date
509: ) return date

Line 520: from ben_per_in_ler pil

516: /*
517: cursor c_per_in_ler
518: is
519: select pil.ntfn_dt
520: from ben_per_in_ler pil
521: where pil.per_in_ler_id = p_per_in_ler_id;
522: --
523: */
524: begin

Line 639: l_pil_row ben_per_in_ler%rowtype;

635: l_jurisdiction_code varchar2(30);
636: l_enrt_eff_strt_date date;
637: l_date_temp date;
638: --
639: l_pil_row ben_per_in_ler%rowtype;
640: --
641: cursor c_asg is
642: select asg.assignment_id,asg.organization_id
643: from per_all_assignments_f asg

Line 664: from ben_per_in_ler pil,

660: epe.oipl_id,
661: pil.ler_id,
662: epe.business_group_id,
663: epe.enrt_cvg_strt_dt
664: from ben_per_in_ler pil,
665: ben_elig_per_elctbl_chc epe
666: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
667: and epe.per_in_ler_id = pil.per_in_ler_id;
668: --

Line 691: from ben_per_in_ler pil

687: and pl.effective_end_date;
688: --
689: cursor c_ler is
690: select pil.ler_id
691: from ben_per_in_ler pil
692: where pil.per_in_ler_id = p_per_in_ler_id
693: and pil.business_group_id = p_business_group_id;
694: --
695: cursor c_pay_period(p_assignment_id number default null) is -----------Bug 8394662

Line 949: from ben_elig_per_f pep, ben_per_in_ler pil

945: and business_group_id = l_business_group_id;
946: --
947: cursor c_cm_elig_prtn_strt_dt is
948: select min(prtn_strt_dt)
949: from ben_elig_per_f pep, ben_per_in_ler pil
950: where pep.person_id = p_person_id
951: and pep.business_group_id = p_business_group_id
952: and p_effective_date = pep.effective_start_date
953: and pil.per_in_ler_id(+) = pep.per_in_ler_id

Line 961: from ben_elig_per_f pep, ben_per_in_ler pil

957: pil.per_in_ler_stat_cd is null);
958: --
959: cursor c_cm_elig_prtn_end_dt is
960: select min(prtn_end_dt)
961: from ben_elig_per_f pep, ben_per_in_ler pil
962: where pep.person_id = p_person_id
963: -- and pep.business_group_id = p_business_group_id
964: and nvl(p_fonm_cvg_strt_dt,p_effective_date ) = pep.effective_start_date
965: and pil.per_in_ler_id(+) = pep.per_in_ler_id

Line 1069: from ben_per_in_ler pil

1065: where paf.person_id = p_person_id;
1066: --
1067: cursor c_ler_id is
1068: select pil.ler_id
1069: from ben_per_in_ler pil
1070: where pil.per_in_ler_id = p_per_in_ler_id;
1071: --
1072: cursor c_pay_id is
1073: select asg.payroll_id

Line 6991: ben_per_in_ler pil

6987: epd.rt_end_dt_cd,
6988: epd.rt_end_dt_rl
6989: from ben_popl_enrt_typ_cycl_f popl,
6990: ben_enrt_perd epd,
6991: ben_per_in_ler pil
6992: where popl.pl_id = c_pl_id
6993: and epd.popl_enrt_typ_cycl_id = popl.popl_enrt_typ_cycl_id
6994: and pil.per_in_ler_id = c_per_in_ler_id
6995: and epd.asnd_lf_evt_dt = pil.lf_evt_ocrd_dt /* removed join btw PIL and LER instead made join btw epd $ pil.*/

Line 7017: ben_per_in_ler pil

7013: epd.rt_end_dt_cd,
7014: epd.rt_end_dt_rl
7015: from ben_popl_enrt_typ_cycl_f popl, -- start 4356591
7016: ben_enrt_perd epd,
7017: ben_per_in_ler pil
7018: where popl.pgm_id = c_pgm_id
7019: and epd.popl_enrt_typ_cycl_id = popl.popl_enrt_typ_cycl_id
7020: and pil.per_in_ler_id = c_per_in_ler_id
7021: and epd.asnd_lf_evt_dt = pil.lf_evt_ocrd_dt /* removed join btw PIL and LER instead made join btw epd $ pil.*/

Line 7165: ben_per_in_ler pil

7161: lee.rt_end_dt_rl
7162: from ben_popl_enrt_typ_cycl_f popl,
7163: ben_lee_rsn_f lee,
7164: ben_ler_f ler,
7165: ben_per_in_ler pil
7166: where popl.pl_id = c_pl_id
7167: and c_effective_date between popl.effective_start_date and popl.effective_end_date
7168: and lee.popl_enrt_typ_cycl_id = popl.popl_enrt_typ_cycl_id
7169: and pil.per_in_ler_id = c_per_in_ler_id

Line 7194: ben_per_in_ler pil

7190: lee.rt_end_dt_cd,
7191: lee.rt_end_dt_rl
7192: from ben_popl_enrt_typ_cycl_f popl, -- start 4356591
7193: ben_lee_rsn_f lee,
7194: ben_per_in_ler pil
7195: where popl.pgm_id = c_pgm_id
7196: and c_effective_date between popl.effective_start_date and popl.effective_end_date
7197: and lee.popl_enrt_typ_cycl_id = popl.popl_enrt_typ_cycl_id
7198: and pil.per_in_ler_id = c_per_in_ler_id

Line 7336: ben_per_in_ler pil

7332: epe.fonm_cvg_strt_dt
7333: from
7334: ben_elig_per_elctbl_chc epe,
7335: ben_pil_elctbl_chc_popl pel,
7336: ben_per_in_ler pil
7337: where
7338: epe.elig_per_elctbl_chc_id=p_elig_per_elctbl_chc_id and
7339: pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id and
7340: pil.per_in_ler_id=epe.per_in_ler_id;

Line 7490: l_pil_row ben_per_in_ler%rowtype;

7486: -- End 3965571
7487: --
7488:
7489: l_leersn_rec c_gleersn_dets%rowtype;
7490: l_pil_row ben_per_in_ler%rowtype;
7491:
7492: cursor c_rt_dts_bckdt(c_per_in_ler_id number) is
7493: select prv.rt_strt_dt,
7494: prv.rt_end_dt