[Home] [Help]
280: l_benefit_classification_id number;
281: Begin
282: Select benefit_classification_id
283: INTO l_benefit_classification_id
284: From ben_benefit_classifications
285: Where nvl(legislation_code,
286: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=
287: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
288: and nvl(business_group_id,nvl(p_business_group_id,-1)) =