DBA Data[Home] [Help]

APPS.HXT_UTIL dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1022: from per_assignment_status_types ast,

1018:
1019: l_object_version_number pay_batch_headers.object_version_number%TYPE;
1020: cursor assign_param(c_person_id NUMBER) IS
1021: select asm.business_group_id
1022: from per_assignment_status_types ast,
1023: per_assignments_f asm
1024: where asm.person_id = c_person_id
1025: and ast.assignment_status_type_id = asm.assignment_status_type_id
1026: and ast.pay_system_status = 'P'; -- Check payroll status