DBA Data[Home] [Help]

APPS.HRBEEBC dependencies on PER_COBRA_COVERAGE_BENEFITS

Line 37: FROM per_cobra_coverage_benefits ccb

33: -- declare cursor for cobra check
34: --
35: CURSOR chk_cobra_ref_exists IS
36: SELECT 'Y'
37: FROM per_cobra_coverage_benefits ccb
38: WHERE ccb.business_group_id + 0 = p_business_group_id
39: AND ccb.element_type_id = p_element_type_id
40: AND ccb.coverage_type = p_coverage_type
41: AND ccb.accept_reject_flag = 'ACC';