APPS.PER_ASG_BUS3 dependencies on PER_ASSIGNMENTS_F

Line 2187: ,p_business_group_id IN per_assignments_f.business_group_id%TYPE

2183: PROCEDURE chk_vendor_assignment_number
2184: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
2185: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
2186: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
2187: ,p_business_group_id IN per_assignments_f.business_group_id%TYPE
2188: ,p_object_version_number IN per_all_assignments_f.object_version_number%TYPE
2189: ,p_effective_date IN DATE) IS
2190: --
2191: l_proc VARCHAR2(72):= g_package||'chk_vendor_assignment_number';

Line 2267: ,p_business_group_id IN per_assignments_f.business_group_id%TYPE

2263: PROCEDURE chk_vendor_employee_number
2264: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
2265: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
2266: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
2267: ,p_business_group_id IN per_assignments_f.business_group_id%TYPE
2268: ,p_object_version_number IN per_all_assignments_f.object_version_number%TYPE
2269: ,p_effective_date IN DATE) IS
2270: --
2271: l_proc VARCHAR2(72) := g_package||'chk_vendor_employee_number';

Line 2555: FROM per_assignments_f2 paf

2551: -- view.
2552: --
2553: SELECT paf.assignment_id
2554: INTO l_assignment_id
2555: FROM per_assignments_f2 paf
2556: WHERE paf.person_id = p_person_id
2557: AND p_effective_date BETWEEN
2558: paf.effective_start_date AND paf.effective_end_date
2559: AND paf.assignment_type = p_assignment_type