DBA Data[Home] [Help]

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) =