APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_OIPL_F

Line 739: l_oipl_rec ben_oipl_f%ROWTYPE;

735: l_outputs ff_exec.outputs_t;
736: l_loc_rec hr_locations_all%ROWTYPE;
737: l_ass_rec per_all_assignments_f%ROWTYPE;
738: l_pl_rec ben_pl_f%ROWTYPE;
739: l_oipl_rec ben_oipl_f%ROWTYPE;
740: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
741: l_effective_date date ;
742: l_jurisdiction_code VARCHAR2(30);
743: cursor c_ptip(p_effective_date date) is

Line 764: from ben_oipl_f oipl,

760: p_effective_date between
761: pl.effective_start_date and pl.effective_end_date;
762: cursor c_oipl(p_effective_date date) is
763: select pl.pl_typ_id , pl.pl_id
764: from ben_oipl_f oipl,
765: ben_pl_f pl
766: where oipl.oipl_id=p_oipl_id and
767: oipl.business_group_id=p_business_group_id and
768: p_effective_date between

Line 777: ben_oipl_f oipl,

773: pl.effective_start_date and pl.effective_end_date;
774: cursor c_oiplip(p_effective_date date) is
775: select pl.pl_typ_id , pl.pl_id
776: from ben_oiplip_f oiplip,
777: ben_oipl_f oipl,
778: ben_pl_f pl
779: where oiplip.oiplip_id=p_oiplip_id and
780: oiplip.business_group_id=p_business_group_id and
781: p_effective_date between

Line 974: l_oipl_rec ben_oipl_f%ROWTYPE;

970: l_oiplip_rec g_cache_structure;
971: --
972: l_pl_id NUMBER;
973: l_opt_id NUMBER;
974: l_oipl_rec ben_oipl_f%ROWTYPE;
975: l_epo_row ben_derive_part_and_rate_facts.g_cache_structure;
976: --
977: -- Cursor to get eligible option details
978: --

Line 2616: l_oipl_rec ben_oipl_f%ROWTYPE;

2612: l_dummy_num NUMBER;
2613: l_outputs ff_exec.outputs_t;
2614: l_pil_rec ben_per_in_ler%ROWTYPE;
2615: l_pl_rec ben_pl_f%ROWTYPE;
2616: l_oipl_rec ben_oipl_f%ROWTYPE;
2617: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
2618: l_ass_rec per_all_assignments_f%ROWTYPE;
2619: l_loc_rec hr_locations_all%ROWTYPE;
2620: l_per_rec per_all_people_f%ROWTYPE;

Line 3055: l_oipl_rec ben_oipl_f%ROWTYPE;

3051: l_result NUMBER;
3052: l_outputs ff_exec.outputs_t;
3053: l_pil_rec ben_per_in_ler%ROWTYPE;
3054: l_pl_rec ben_pl_f%ROWTYPE;
3055: l_oipl_rec ben_oipl_f%ROWTYPE;
3056: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
3057: l_loc_rec hr_locations_all%ROWTYPE;
3058: l_ass_rec per_all_assignments_f%ROWTYPE;
3059: l_bal_rec ben_per_bnfts_bal_f%ROWTYPE;

Line 3402: l_oipl_rec ben_oipl_f%ROWTYPE;

3398: l_result NUMBER;
3399: l_outputs ff_exec.outputs_t;
3400: l_pil_rec ben_per_in_ler%ROWTYPE;
3401: l_pl_rec ben_pl_f%ROWTYPE;
3402: l_oipl_rec ben_oipl_f%ROWTYPE;
3403: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
3404: l_loc_rec hr_locations_all%ROWTYPE;
3405: l_ass_rec per_all_assignments_f%ROWTYPE;
3406: l_bal_rec ben_per_bnfts_bal_f%ROWTYPE;