[Home] [Help]
1722: l_dummy number ;
1723: cursor c1 is
1724: select 1
1725: from per_assignment_status_types a
1726: , per_ass_status_type_amends b
1727: where b.assignment_status_type_id(+) = a.assignment_status_type_id
1728: and b.business_group_id(+) + 0 = p_business_group_id
1729: and nvl(a.business_group_id,p_business_group_id) = p_business_group_id
1730: and nvl(a.legislation_code,p_legislation_code) = p_legislation_code