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 283: from ben_oipl_f

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

Line 707: l_oipl_id ben_oipl_f.oipl_id%type;

703: l_pl_id ben_pl_f.pl_id%type;
704: l_opt_id ben_opt_f.opt_id%type;
705: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
706: l_plip_id ben_plip_f.plip_id%type;
707: l_oipl_id ben_oipl_f.oipl_id%type;
708: l_ler_id ben_ler_f.ler_id%type;
709: l_ptip_id ben_ptip_f.ptip_id%type;
710: l_assignment_id per_all_assignments_f.assignment_id%type;
711: l_exists boolean;

Line 792: from ben_oipl_f

788:
789: -- Cursor to get the option in plan Id
790: Cursor c_get_oipl_id is
791: select oipl_id
792: from ben_oipl_f
793: where pl_id = l_pl_id
794: and opt_id = l_opt_id
795: and business_group_id = p_business_group_id;
796:

Line 1064: l_oipl_id ben_oipl_f.oipl_id%type;

1060: l_pl_id ben_pl_f.pl_id%type;
1061: l_opt_id ben_opt_f.opt_id%type;
1062: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
1063: l_plip_id ben_plip_f.plip_id%type;
1064: l_oipl_id ben_oipl_f.oipl_id%type;
1065: l_ler_id ben_ler_f.ler_id%type;
1066: l_ptip_id ben_ptip_f.ptip_id%type;
1067: l_exists boolean;
1068: l_ovn number;

Line 1148: from ben_oipl_f

1144:
1145: -- Cursor to get the option in plan Id
1146: Cursor c_get_oipl_id is
1147: select oipl_id
1148: from ben_oipl_f
1149: where pl_id = l_pl_id
1150: and opt_id = l_opt_id
1151: and business_group_id = p_business_group_id;
1152: