APPS.HRHIRAPL dependencies on PER_ASS_STATUS_TYPE_AMENDS
Line 4969: , per_ass_status_type_amends pasa
4965: and pa.effective_end_date -- fix for bug 6036285
4966: and pa.assignment_status_type_id IN (
4967: select past.assignment_status_type_id
4968: from per_assignment_status_types past 4969: , per_ass_status_type_amends pasa 4970: where pasa.assignment_status_type_id(+)=
4971: past.assignment_status_type_id
4972: and pasa.business_group_id(+) + 0 = p_business_group_id
4973: and nvl(past.business_group_id,p_business_group_id) =