DBA Data[Home] [Help]

APPS.BEN_DETERMINE_DPNT_ELIGIBILITY dependencies on BEN_DSGN_RQMT_F

Line 573: from ben_dsgn_rqmt_f ddr

569: 1) lvl, -- oipl level,
570: mn_dpnts_rqd_num,
571: mx_dpnts_alwd_num,
572: no_mn_num_dfnd_flag
573: from ben_dsgn_rqmt_f ddr
574: where (ddr.oipl_id = p_oipl_id
575: or ddr.pl_id = p_pl_id
576: or ddr.opt_id = (select oipl.opt_id
577: from ben_oipl_f oipl

Line 1006: -- See if we can find designation requirements ben_dsgn_rqmt_f

1002: --
1003: if l_process_flag = 'Y' then
1004: hr_utility.set_location ('in this if',50);
1005: --
1006: -- See if we can find designation requirements ben_dsgn_rqmt_f
1007: -- If designation requirments does not exist, than any number
1008: -- or type of dependents are allowed. If designation requirements
1009: -- are found, then the min and max cannot be 0(Employee Only option).
1010: --