DBA Data[Home] [Help]

APPS.PAY_ES_RULES dependencies on PER_ALL_ASSIGNMENTS_F

Line 13: FROM per_all_assignments_f paaf

9: ,p_tax_unit_id IN OUT NOCOPY NUMBER) IS
10: --
11: CURSOR csr_get_wc_details IS
12: SELECT scl.segment2 work_center
13: FROM per_all_assignments_f paaf
14: ,hr_soft_coding_keyflex scl
15: WHERE paaf.assignment_id = p_assignment_id
16: AND paaf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
17: AND p_effective_date BETWEEN effective_start_date