APPS.HR_BEN_BENEFIT_CONTRIBUTIONS dependencies on BEN_BENEFIT_CONTRIBUTIONS_F

Line 27: FROM ben_benefit_contributions_f bc

23: -- declare cursor for check
24: --
25: CURSOR chk_duplicate_cont IS
26: SELECT 'Y'
27: FROM ben_benefit_contributions_f bc
28: WHERE ( bc.benefit_contribution_id <> p_benefit_contribution_id
29: OR p_benefit_contribution_id IS NULL )
30: AND bc.element_type_id = p_element_type_id
31: AND bc.business_group_id + 0 = p_business_group_id

Line 109: FROM ben_benefit_contributions_f bc

105: -- declare cursor for contribution check
106: --
107: CURSOR chk_future_contribution IS
108: SELECT 'Y'
109: FROM ben_benefit_contributions_f bc
110: WHERE bc.benefit_contribution_id = p_benefit_contribution_id
111: AND bc.business_group_id + 0 = p_business_group_id
112: AND bc.effective_end_date > p_effective_end_date;
113: --