DBA Data[Home] [Help]

APPS.PQH_GSP_BEN_VALIDATIONS dependencies on BEN_PL_TYP_OPT_TYP_F

Line 261: From BEN_PL_TYP_OPT_TYP_F

257:
258: Cursor csr_opt_type
259: IS
260: Select NULL
261: From BEN_PL_TYP_OPT_TYP_F
262: Where OPT_ID = p_opt_id
263: AND BUSINESS_GROUP_ID = p_business_group_id
264: AND p_effective_date BETWEEN EFFECTIVE_START_DATE
265: And nvl(Effective_End_Date, hr_general.end_of_time)