APPS.BEN_PLAN_TYPE_OPTION_TYPE_API dependencies on BEN_OPT_F

Line 72: from ben_opt_f opt

68:
69: cursor c_opt is
70: select opt.Group_opt_id ,
71: opt.object_version_number
72: from ben_opt_f opt
73: where opt.opt_id = p_opt_id
74: and p_effective_date between
75: opt.effective_start_date and opt.effective_end_date ;
76:

Line 84: l_group_opt_id ben_opt_f.Group_opt_id%type ;

80: where ptp.pl_typ_id = p_pl_typ_id
81: and p_effective_date between
82: ptp.effective_start_date and ptp.effective_end_date ;
83:
84: l_group_opt_id ben_opt_f.Group_opt_id%type ;
85: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%type ;
86: l_opt_ovn number ;
87: l_eff_st_dt date ;
88: l_eff_end_dt date ;

Line 405: from ben_opt_f opt

401:
402: cursor c_opt is
403: select opt.Group_opt_id ,
404: opt.object_version_number
405: from ben_opt_f opt
406: where opt.opt_id = p_opt_id
407: and p_effective_date between
408: opt.effective_start_date and opt.effective_end_date ;
409:

Line 417: l_group_opt_id ben_opt_f.Group_opt_id%type ;

413: where ptp.pl_typ_id = p_pl_typ_id
414: and p_effective_date between
415: ptp.effective_start_date and ptp.effective_end_date ;
416:
417: l_group_opt_id ben_opt_f.Group_opt_id%type ;
418: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%type ;
419: l_opt_ovn number ;
420: l_eff_st_dt date ;
421: l_eff_end_dt date ;

Line 695: from ben_pl_typ_opt_typ_f pon, ben_opt_f opt

691: -- Declare cursors and local variables
692: --
693: cursor c1 is
694: select opt.opt_id, opt.object_version_number
695: from ben_pl_typ_opt_typ_f pon, ben_opt_f opt
696: where pon.opt_id = opt.opt_id
697: and pon.pl_typ_opt_typ_id = p_pl_typ_opt_typ_id
698: and p_effective_date between pon.effective_start_date and pon.effective_end_date
699: and p_effective_date between opt.effective_start_date and opt.effective_end_date;

Line 810: -- then make group_option_id in ben_opt_f as null

806: close c2;
807: --
808: if l_count_cwb_pl_typ = 0 then
809: -- If the plan type being deleted is the last CWB plan type associated with the option
810: -- then make group_option_id in ben_opt_f as null
811: --
812: update ben_opt_f
813: set group_opt_id = null
814: where opt_id = l_opt_id

Line 812: update ben_opt_f

808: if l_count_cwb_pl_typ = 0 then
809: -- If the plan type being deleted is the last CWB plan type associated with the option
810: -- then make group_option_id in ben_opt_f as null
811: --
812: update ben_opt_f
813: set group_opt_id = null
814: where opt_id = l_opt_id
815: and p_effective_date between effective_start_date and effective_end_date;
816: end if;