APPS.PAY_CN_DEDUCTIONS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1932: per_assignment_status_types past

1928: CURSOR c_asg_status (l_effective_date IN DATE) IS
1929: SELECT past.per_system_status
1930: FROM pay_element_entries_f pee,
1931: per_assignments_f paf,
1932: per_assignment_status_types past
1933: WHERE pee.element_entry_id = p_element_entry_id
1934: AND pee.assignment_id = paf.assignment_id
1935: AND paf.assignment_status_type_id = past.assignment_status_type_id
1936: AND l_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date --Bug 3456162

Line 1942: l_asg_status per_assignment_status_types.per_system_status%TYPE;

1938: --
1939: --Bug 3456162: Changes end.
1940: --
1941: --
1942: l_asg_status per_assignment_status_types.per_system_status%TYPE;
1943: --
1944: -- Bug 3050951: Changes end.
1945: --
1946: