DBA Data[Home] [Help]

APPS.BEN_ELIG_CVRD_DPNT_API dependencies on BEN_DSGN_RQMT_F

Line 2768: from ben_dsgn_rqmt_f

2764: cv_opt_id number) is
2765: select mx_dpnts_alwd_num
2766: ,no_mx_num_dfnd_flag
2767: ,decode(oipl_id, null, decode(opt_id, null, 3, 2), 1) heir
2768: from ben_dsgn_rqmt_f
2769: where
2770: ((nvl(pl_id, hr_api.g_number) = cv_pl_id)
2771: or (nvl(oipl_id, hr_api.g_number) = cv_oipl_id)
2772: or (nvl(opt_id, hr_api.g_number) = cv_opt_id))

Line 2788: from ben_dsgn_rqmt_f r

2784: cursor any_rqmt_c(cv_pl_id number,
2785: cv_oipl_id number,
2786: cv_opt_id number)is
2787: select 's'
2788: from ben_dsgn_rqmt_f r
2789: where ((nvl(pl_id, hr_api.g_number) = cv_pl_id)
2790: or (nvl(oipl_id, hr_api.g_number) = cv_oipl_id)
2791: or (nvl(opt_id, hr_api.g_number) = cv_opt_id))
2792: and r.dsgn_typ_cd = 'DPNT'

Line 2811: from ben_dsgn_rqmt_f r,

2807: ,r.no_mx_num_dfnd_flag
2808: ,r.dsgn_rqmt_id
2809: ,decode(oipl_id, null, decode(opt_id, null, 3, 2), 1) heir
2810: ,r.grp_rlshp_cd
2811: from ben_dsgn_rqmt_f r,
2812: ben_dsgn_rqmt_rlshp_typ dr
2813: where ((nvl(pl_id, hr_api.g_number) = cv_pl_id)
2814: or (nvl(oipl_id, hr_api.g_number) = cv_oipl_id)
2815: or (nvl(opt_id, hr_api.g_number) = cv_opt_id))