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.GHR_BENEFITS_EIT dependencies on BEN_PLIP_F

Line 70: CURSOR get_plip_id(c_plan_id ben_plip_f.pl_id%type, c_pgm_id ben_plip_f.pgm_id%type, c_business_group_id ben_pgm_f.business_group_id%type,

66: AND opt.business_group_id = c_business_group_id
67: AND c_effective_date between effective_start_date and effective_end_date;
68:
69: --Cursor to get the plan in Program Id for the given Pl_id
70: CURSOR get_plip_id(c_plan_id ben_plip_f.pl_id%type, c_pgm_id ben_plip_f.pgm_id%type, c_business_group_id ben_pgm_f.business_group_id%type,
71: c_effective_date ben_pgm_f.effective_start_date%type) is
72: SELECT plip.plip_id
73: FROM ben_plip_f plip
74: WHERE plip.pl_id = c_plan_id

Line 73: FROM ben_plip_f plip

69: --Cursor to get the plan in Program Id for the given Pl_id
70: CURSOR get_plip_id(c_plan_id ben_plip_f.pl_id%type, c_pgm_id ben_plip_f.pgm_id%type, c_business_group_id ben_pgm_f.business_group_id%type,
71: c_effective_date ben_pgm_f.effective_start_date%type) is
72: SELECT plip.plip_id
73: FROM ben_plip_f plip
74: WHERE plip.pl_id = c_plan_id
75: AND plip.pgm_id = c_pgm_id
76: AND plip.business_group_id = c_business_group_id
77: AND c_effective_date between effective_start_date and effective_end_date;

Line 99: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,

95: and ler.name = c_life_event
96: and c_effective_date between effective_start_date and effective_end_date;
97:
98: CURSOR get_elig_chc_id_opt(c_pgm_id ben_pgm_f.pgm_id%type, c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,
99: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,
100: c_ptip_id ben_ptip_f.ptip_id%type, c_oipl_id ben_oipl_f.oipl_id%type,
101: c_ler_id ben_ler_f.ler_id%type, c_person_id per_all_people_f.person_id%type) IS
102: SELECT elig_per_elctbl_chc_id,
103: pil.per_in_ler_id,

Line 119: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,

115: AND pil.person_id = c_person_id
116: AND PER_IN_LER_STAT_CD NOT IN ('BCKDT','PROCD');
117:
118: Cursor get_elig_chc_id(c_pgm_id ben_pgm_f.pgm_id%type, c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,
119: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,
120: c_ptip_id ben_ptip_f.ptip_id%type,
121: c_ler_id ben_ler_f.ler_id%type, c_person_id per_all_people_f.person_id%type) is
122: select elig_per_elctbl_chc_id,
123: pil.per_in_ler_id,

Line 153: l_plip_id ben_plip_f.plip_id%type;

149: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
150: l_ptip_id ben_ptip_f.ptip_id%type;
151: l_pl_id ben_pl_f.pl_id%type;
152: l_opt_id ben_opt_f.opt_id%type;
153: l_plip_id ben_plip_f.plip_id%type;
154: l_oipl_id ben_oipl_f.oipl_id%type;
155: l_ler_id ben_ler_f.ler_id%type;
156: l_ptnl_ler_for_per_id NUMBER;
157: l_elig_per_elctbl_chc_id NUMBER;

Line 667: CURSOR get_plip_id(c_plan_id ben_plip_f.pl_id%type, c_pgm_id ben_plip_f.pgm_id%type, c_business_group_id ben_pgm_f.business_group_id%type,

663: AND opt.business_group_id = c_business_group_id
664: AND c_effective_date between effective_start_date and effective_end_date;
665:
666: --Cursor to get the plan in Program Id for the given Pl_id
667: CURSOR get_plip_id(c_plan_id ben_plip_f.pl_id%type, c_pgm_id ben_plip_f.pgm_id%type, c_business_group_id ben_pgm_f.business_group_id%type,
668: c_effective_date ben_pgm_f.effective_start_date%type) is
669: SELECT plip.plip_id
670: FROM ben_plip_f plip
671: WHERE plip.pl_id = c_plan_id

Line 670: FROM ben_plip_f plip

666: --Cursor to get the plan in Program Id for the given Pl_id
667: CURSOR get_plip_id(c_plan_id ben_plip_f.pl_id%type, c_pgm_id ben_plip_f.pgm_id%type, c_business_group_id ben_pgm_f.business_group_id%type,
668: c_effective_date ben_pgm_f.effective_start_date%type) is
669: SELECT plip.plip_id
670: FROM ben_plip_f plip
671: WHERE plip.pl_id = c_plan_id
672: AND plip.pgm_id = c_pgm_id
673: AND plip.business_group_id = c_business_group_id
674: AND c_effective_date between effective_start_date and effective_end_date;

Line 688: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,

684: AND business_group_id = c_business_group_id
685: AND c_effective_date between effective_start_date and effective_end_date;
686:
687: CURSOR get_elig_chc_id_opt(c_pgm_id ben_pgm_f.pgm_id%type, c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,
688: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,
689: c_ptip_id ben_ptip_f.ptip_id%type, c_oipl_id ben_oipl_f.oipl_id%type,
690: c_person_id per_all_people_f.person_id%type) IS
691: SELECT elig_per_elctbl_chc_id,
692: pil.per_in_ler_id

Line 725: l_plip_id ben_plip_f.plip_id%type;

721: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
722: l_ptip_id ben_ptip_f.ptip_id%type;
723: l_pl_id ben_pl_f.pl_id%type;
724: l_opt_id ben_opt_f.opt_id%type;
725: l_plip_id ben_plip_f.plip_id%type;
726: l_oipl_id ben_oipl_f.oipl_id%type;
727: l_ler_id ben_ler_f.ler_id%type;
728: l_ptnl_ler_for_per_id NUMBER;
729: l_elig_per_elctbl_chc_id NUMBER;

Line 889: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,

885:
886: hr_utility.set_location('Option in plan ID ' || l_oipl_id,1234);
887:
888: /*(c_pgm_id ben_pgm_f.pgm_id%type, c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,
889: c_pl_id ben_pl_f.pl_id%type, c_plip_id ben_plip_f.plip_id%type,
890: c_ptip_id ben_ptip_f.ptip_id%type, c_oipl_id ben_oipl_f.oipl_id%type,
891: c_person_id per_all_people_f.person_id%type) */
892: hr_utility.set_location('p_manage_life_events done' ,1234);
893: for get_elig_chc_id in get_elig_chc_id_opt(l_pgm_id , l_pl_typ_id , l_pl_id , l_plip_id ,