DBA Data[Home] [Help]

APPS.HXT_UTIL dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1041: from per_assignment_status_types ast,

1037:
1038: l_object_version_number pay_batch_headers.object_version_number%TYPE;
1039: cursor assign_param(c_person_id NUMBER) IS
1040: select asm.business_group_id
1041: from per_assignment_status_types ast,
1042: per_assignments_f asm
1043: where asm.person_id = c_person_id
1044: and ast.assignment_status_type_id = asm.assignment_status_type_id
1045: and ast.pay_system_status = 'P'; -- Check payroll status