APPS.PAY_ES_BAL_UPLOAD dependencies on HR_SOFT_CODING_KEYFLEX
Line 298: ,hr_soft_coding_keyflex scl
294: --
295: CURSOR csr_get_wc_details IS
296: SELECT scl.segment2 work_center
297: FROM per_all_assignments_f paaf 298: ,hr_soft_coding_keyflex scl 299: WHERE paaf.assignment_id = p_assignment_id
300: AND paaf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
301: AND p_effective_date BETWEEN effective_start_date
302: AND effective_end_date;