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