APPS.PAY_CN_DEDUCTIONS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1922: per_assignment_status_types past

1918: CURSOR c_asg_status (l_effective_date IN DATE) IS
1919: SELECT past.per_system_status
1920: FROM pay_element_entries_f pee,
1921: per_assignments_f paf,
1922: per_assignment_status_types past
1923: WHERE pee.element_entry_id = p_element_entry_id
1924: AND pee.assignment_id = paf.assignment_id
1925: AND paf.assignment_status_type_id = past.assignment_status_type_id
1926: AND l_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date --Bug 3456162

Line 1932: l_asg_status per_assignment_status_types.per_system_status%TYPE;

1928: --
1929: --Bug 3456162: Changes end.
1930: --
1931: --
1932: l_asg_status per_assignment_status_types.per_system_status%TYPE;
1933: --
1934: -- Bug 3050951: Changes end.
1935: --
1936: