DBA Data[Home] [Help]

APPS.PER_APP_ASG_PKG dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 1726: , per_ass_status_type_amends b

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