APPS.HXT_UTIL dependencies on PER_ASSIGNMENTS_F

Line 1042: per_assignments_f asm

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

Line 1065: -- Get business_group_id from PER_ASSIGNMENTS_F table

1061: IF l_error_text <> NULL THEN
1062: RETURN 1;
1063: END IF;
1064:
1065: -- Get business_group_id from PER_ASSIGNMENTS_F table
1066: open assign_param(i_person_id);
1067: fetch assign_param into l_bus_group_id;
1068: if assign_param%NOTFOUND then
1069: close assign_param;

Line 2012: per_assignments_f asm

2008:
2009: CURSOR cur_costable_type IS
2010: SELECT pel.costable_type
2011: FROM pay_element_links_f pel,
2012: per_assignments_f asm
2013: WHERE asm.assignment_id = p_assignment_id
2014: AND p_date_worked BETWEEN asm.effective_start_date
2015: AND asm.effective_end_date
2016: AND nvl(pel.organization_id,nvl(asm.organization_id,-1)) = nvl(asm.organization_id,-1)