APPS.GHR_BENEFITS_EIT dependencies on BEN_OIPL_F

Line 84: FROM ben_oipl_f

80:
81: CURSOR get_oipl_id(c_pl_id ben_pl_f.pl_id%type, c_opt_id ben_opt_f.opt_id%type, c_business_group_id ben_pgm_f.business_group_id%type,
82: c_effective_date ben_pgm_f.effective_start_date%type) is
83: SELECT oipl_id
84: FROM ben_oipl_f
85: WHERE pl_id = c_pl_id
86: AND opt_id = c_opt_id
87: AND business_group_id = c_business_group_id
88: AND c_effective_date between effective_start_date and effective_end_date;

Line 100: c_ptip_id ben_ptip_f.ptip_id%type, c_oipl_id ben_oipl_f.oipl_id%type,

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,
104: prtt_enrt_rslt_id

Line 154: l_oipl_id ben_oipl_f.oipl_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;
158: l_prtt_enrt_rslt_id number;

Line 681: FROM ben_oipl_f

677:
678: CURSOR get_oipl_id(c_pl_id ben_pl_f.pl_id%type, c_opt_id ben_opt_f.opt_id%type, c_business_group_id ben_pgm_f.business_group_id%type,
679: c_effective_date ben_pgm_f.effective_start_date%type) is
680: SELECT oipl_id
681: FROM ben_oipl_f
682: WHERE pl_id = c_pl_id
683: AND opt_id = c_opt_id
684: AND business_group_id = c_business_group_id
685: AND c_effective_date between effective_start_date and effective_end_date;

Line 689: c_ptip_id ben_ptip_f.ptip_id%type, c_oipl_id ben_oipl_f.oipl_id%type,

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
693: FROM ben_elig_per_ELCTBL_chc chc ,

Line 726: l_oipl_id ben_oipl_f.oipl_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;
730: l_prtt_enrt_rslt_id number;

Line 890: c_ptip_id ben_ptip_f.ptip_id%type, c_oipl_id ben_oipl_f.oipl_id%type,

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 ,
894: l_ptip_id , l_oipl_id , l_person_id) loop

Line 1042: FROM ben_oipl_f

1038: c_opt_id ben_opt_f.opt_id%type,
1039: c_business_group_id ben_pgm_f.business_group_id%type,
1040: c_effective_date ben_pgm_f.effective_start_date%type) is
1041: SELECT oipl_id
1042: FROM ben_oipl_f
1043: WHERE pl_id = c_pl_id
1044: AND opt_id = c_opt_id
1045: AND business_group_id = c_business_group_id
1046: AND c_effective_date between effective_start_date and effective_end_date;

Line 1062: c_oipl_id ben_oipl_f.oipl_id%type,

1058: c_pl_typ_id ben_pl_typ_f.pl_typ_id%type,
1059: c_pl_id ben_pl_f.pl_id%type,
1060: c_plip_id ben_plip_f.plip_id%type,
1061: c_ptip_id ben_ptip_f.ptip_id%type,
1062: c_oipl_id ben_oipl_f.oipl_id%type,
1063: c_ler_id ben_ler_f.ler_id%type,
1064: c_person_id per_all_people_f.person_id%type) is
1065: SELECT elig_per_elctbl_chc_id,
1066: pil.per_in_ler_id

Line 1144: l_oipl_id ben_oipl_f.oipl_id%type;

1140: l_ptip_id ben_ptip_f.ptip_id%type;
1141: l_pl_id ben_pl_f.pl_id%type;
1142: l_opt_id ben_opt_f.opt_id%type;
1143: l_plip_id ben_plip_f.plip_id%type;
1144: l_oipl_id ben_oipl_f.oipl_id%type;
1145: l_ler_id ben_ler_f.ler_id%type;
1146: l_ptnl_ler_for_per_id NUMBER;
1147: l_elig_per_elctbl_chc_id NUMBER;
1148: l_prtt_enrt_rslt_id number;