DBA Data[Home] [Help]

APPS.GHR_PAY_CALC dependencies on PER_ALL_ASSIGNMENTS_F

Line 1805: FROM per_all_assignments_f

1801:
1802: -- Bug#5120116 created the cursor to get assignment id.
1803: CURSOR c_asg_rec(c_person_id NUMBER, c_effective_date DATE) IS
1804: SELECT assignment_id
1805: FROM per_all_assignments_f
1806: WHERE person_id = c_person_id
1807: AND assignment_type = 'E'
1808: AND c_effective_date between effective_start_date and effective_end_date;
1809: