APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_OIPL_F

Line 738: l_oipl_rec ben_oipl_f%ROWTYPE;

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

Line 763: from ben_oipl_f oipl,

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

Line 776: ben_oipl_f oipl,

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

Line 973: l_oipl_rec ben_oipl_f%ROWTYPE;

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

Line 2615: l_oipl_rec ben_oipl_f%ROWTYPE;

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

Line 3054: l_oipl_rec ben_oipl_f%ROWTYPE;

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

Line 3401: l_oipl_rec ben_oipl_f%ROWTYPE;

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