APPS.HXT_UTIL dependencies on PER_ASSIGNMENTS_F

Line 1023: per_assignments_f asm

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
1027:

Line 1046: -- Get business_group_id from PER_ASSIGNMENTS_F table

1042: IF l_error_text <> NULL THEN
1043: RETURN 1;
1044: END IF;
1045:
1046: -- Get business_group_id from PER_ASSIGNMENTS_F table
1047: open assign_param(i_person_id);
1048: fetch assign_param into l_bus_group_id;
1049: if assign_param%NOTFOUND then
1050: close assign_param;

Line 1942: per_assignments_f asm

1938:
1939: CURSOR cur_costable_type IS
1940: SELECT pel.costable_type
1941: FROM pay_element_links_f pel,
1942: per_assignments_f asm
1943: WHERE asm.assignment_id = p_assignment_id
1944: AND p_date_worked BETWEEN asm.effective_start_date
1945: AND asm.effective_end_date
1946: AND nvl(pel.organization_id,nvl(asm.organization_id,-1)) = nvl(asm.organization_id,-1)