DBA Data[Home] [Help]

APPS.PER_APP_ASG_PKG dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 1533: , per_ass_status_type_amends b

1529: l_dummy number ;
1530: cursor c1 is
1531: select 1
1532: from per_assignment_status_types a
1533: , per_ass_status_type_amends b
1534: where b.assignment_status_type_id(+) = a.assignment_status_type_id
1535: and b.business_group_id(+) + 0 = p_business_group_id
1536: and nvl(a.business_group_id,p_business_group_id) = p_business_group_id
1537: and nvl(a.legislation_code,p_legislation_code) = p_legislation_code