DBA Data[Home] [Help]

APPS.PER_PEOPLE_V15_PKG dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 690: , per_ass_status_type_amends pasa

686: --
687: cursor ass_type is
688: select past.assignment_status_type_id
689: from per_assignment_status_types past
690: , per_ass_status_type_amends pasa
691: , per_business_groups pbg
692: where pasa.assignment_status_type_id(+) = past.assignment_status_type_id
693: and pasa.business_group_id(+) = X_Business_Group_id
694: and pbg.business_group_id = X_Business_Group_id