eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 is

Line 947: from ben_elig_per_f pep, ben_per_in_ler pil

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

Line 959: from ben_elig_per_f pep, ben_per_in_ler pil

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

Line 1067: from ben_per_in_ler pil

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

Line 6812: ben_per_in_ler pil

6808: epd.rt_end_dt_cd,
6809: epd.rt_end_dt_rl
6810: from ben_popl_enrt_typ_cycl_f popl,
6811: ben_enrt_perd epd,
6812: ben_per_in_ler pil
6813: where popl.pl_id = c_pl_id
6814: and epd.popl_enrt_typ_cycl_id = popl.popl_enrt_typ_cycl_id
6815: and pil.per_in_ler_id = c_per_in_ler_id
6816: and epd.asnd_lf_evt_dt = pil.lf_evt_ocrd_dt /* removed join btw PIL and LER instead made join btw epd $ pil.*/

Line 6838: ben_per_in_ler pil

6834: epd.rt_end_dt_cd,
6835: epd.rt_end_dt_rl
6836: from ben_popl_enrt_typ_cycl_f popl, -- start 4356591
6837: ben_enrt_perd epd,
6838: ben_per_in_ler pil
6839: where popl.pgm_id = c_pgm_id
6840: and epd.popl_enrt_typ_cycl_id = popl.popl_enrt_typ_cycl_id
6841: and pil.per_in_ler_id = c_per_in_ler_id
6842: and epd.asnd_lf_evt_dt = pil.lf_evt_ocrd_dt /* removed join btw PIL and LER instead made join btw epd $ pil.*/

Line 6986: ben_per_in_ler pil

6982: lee.rt_end_dt_rl
6983: from ben_popl_enrt_typ_cycl_f popl,
6984: ben_lee_rsn_f lee,
6985: ben_ler_f ler,
6986: ben_per_in_ler pil
6987: where popl.pl_id = c_pl_id
6988: and c_effective_date between popl.effective_start_date and popl.effective_end_date
6989: and lee.popl_enrt_typ_cycl_id = popl.popl_enrt_typ_cycl_id
6990: and pil.per_in_ler_id = c_per_in_ler_id

Line 7015: ben_per_in_ler pil

7011: lee.rt_end_dt_cd,
7012: lee.rt_end_dt_rl
7013: from ben_popl_enrt_typ_cycl_f popl, -- start 4356591
7014: ben_lee_rsn_f lee,
7015: ben_per_in_ler pil
7016: where popl.pgm_id = c_pgm_id
7017: and c_effective_date between popl.effective_start_date and popl.effective_end_date
7018: and lee.popl_enrt_typ_cycl_id = popl.popl_enrt_typ_cycl_id
7019: and pil.per_in_ler_id = c_per_in_ler_id

Line 7157: ben_per_in_ler pil

7153: epe.fonm_cvg_strt_dt
7154: from
7155: ben_elig_per_elctbl_chc epe,
7156: ben_pil_elctbl_chc_popl pel,
7157: ben_per_in_ler pil
7158: where
7159: epe.elig_per_elctbl_chc_id=p_elig_per_elctbl_chc_id and
7160: pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id and
7161: pil.per_in_ler_id=epe.per_in_ler_id;

Line 7311: l_pil_row ben_per_in_ler%rowtype;

7307: -- End 3965571
7308: --
7309:
7310: l_leersn_rec c_gleersn_dets%rowtype;
7311: l_pil_row ben_per_in_ler%rowtype;
7312:
7313:
7314: begin
7315: --