APPS.GHR_GENERAL dependencies on BEN_OIPL_F

Line 174: l_oipl_id ben_oipl_f.oipl_id%type;

170: l_pl_id ben_pl_f.pl_id%type;
171: l_opt_id ben_opt_f.opt_id%type;
172: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
173: l_plip_id ben_plip_f.plip_id%type;
174: l_oipl_id ben_oipl_f.oipl_id%type;
175: l_ler_id ben_ler_f.ler_id%type;
176: l_ptip_id ben_ptip_f.ptip_id%type;
177: l_exists boolean;
178: l_ptnl_ler_for_per_id number;

Line 285: from ben_oipl_f

281: -- Cursor to get the option in plan Id
282:
283: Cursor get_oipl_id is
284: select oipl_id
285: from ben_oipl_f
286: where pl_id = l_pl_id
287: and opt_id = l_opt_id
288: and business_group_id = p_business_group_id
289: and p_effective_date between effective_start_date and effective_end_date;

Line 719: l_oipl_id ben_oipl_f.oipl_id%type;

715: l_pl_id ben_pl_f.pl_id%type;
716: l_opt_id ben_opt_f.opt_id%type;
717: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
718: l_plip_id ben_plip_f.plip_id%type;
719: l_oipl_id ben_oipl_f.oipl_id%type;
720: l_ler_id ben_ler_f.ler_id%type;
721: l_ptip_id ben_ptip_f.ptip_id%type;
722: l_assignment_id per_all_assignments_f.assignment_id%type;
723: l_exists boolean;

Line 806: from ben_oipl_f

802:
803: -- Cursor to get the option in plan Id
804: Cursor c_get_oipl_id is
805: select oipl_id
806: from ben_oipl_f
807: where pl_id = l_pl_id
808: and opt_id = l_opt_id
809: and business_group_id = p_business_group_id;
810:

Line 1088: l_oipl_id ben_oipl_f.oipl_id%type;

1084: l_pl_id ben_pl_f.pl_id%type;
1085: l_opt_id ben_opt_f.opt_id%type;
1086: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
1087: l_plip_id ben_plip_f.plip_id%type;
1088: l_oipl_id ben_oipl_f.oipl_id%type;
1089: l_ler_id ben_ler_f.ler_id%type;
1090: l_ptip_id ben_ptip_f.ptip_id%type;
1091: l_exists boolean;
1092: l_ovn number;

Line 1174: from ben_oipl_f

1170:
1171: -- Cursor to get the option in plan Id
1172: Cursor c_get_oipl_id is
1173: select oipl_id
1174: from ben_oipl_f
1175: where pl_id = l_pl_id
1176: and opt_id = l_opt_id
1177: and business_group_id = p_business_group_id;
1178: