DBA Data[Home] [Help]

APPS.HRHIRAPL dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 4364: , per_ass_status_type_amends pasa

4360: and pa.effective_end_date -- fix for bug 6036285
4361: and pa.assignment_status_type_id IN (
4362: select past.assignment_status_type_id
4363: from per_assignment_status_types past
4364: , per_ass_status_type_amends pasa
4365: where pasa.assignment_status_type_id(+)=
4366: past.assignment_status_type_id
4367: and pasa.business_group_id(+) + 0 = p_business_group_id
4368: and nvl(past.business_group_id,p_business_group_id) =