DBA Data[Home] [Help]

APPS.BEN_DETERMINE_DPNT_ELIGIBILITY dependencies on BEN_DSGN_RQMT_F

Line 577: from ben_dsgn_rqmt_f ddr

573: 1) lvl, -- oipl level,
574: mn_dpnts_rqd_num,
575: mx_dpnts_alwd_num,
576: no_mn_num_dfnd_flag
577: from ben_dsgn_rqmt_f ddr
578: where (ddr.oipl_id = p_oipl_id
579: or ddr.pl_id = p_pl_id
580: or ddr.opt_id = (select oipl.opt_id
581: from ben_oipl_f oipl

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

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