DBA Data[Home] [Help]

APPS.PER_ASSIGNMENTS_V7_PKG dependencies on PER_BUSINESS_GROUPS

Line 97: , per_business_groups pbg

93: cursor c3 is
94: select past.assignment_status_type_id
95: from per_assignment_status_types past
96: , per_ass_status_type_amends pasa
97: , per_business_groups pbg
98: where pasa.assignment_status_type_id(+) = past.assignment_status_type_id
99: and pasa.business_group_id(+) = X_Business_Group_id
100: and pbg.business_group_id = X_Business_Group_id
101: and nvl(past.business_group_id,X_Business_Group_id) = X_Business_Group_id