DBA Data[Home] [Help]

APPS.PER_PEOPLE3_PKG dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 76: , per_ass_status_type_amends pasa

72: --
73: cursor per_type is
74: select past.assignment_status_type_id
75: from per_assignment_status_types past
76: , per_ass_status_type_amends pasa
77: where pasa.assignment_status_type_id(+) = past.assignment_status_type_id
78: and pasa.business_group_id(+) + 0 = p_business_group_id
79: and nvl(past.business_group_id,p_business_group_id) = p_business_group_id
80: and nvl(past.legislation_code, p_legislation_code) =p_legislation_code