DBA Data[Home] [Help]

APPS.PAY_CN_DEDUCTIONS dependencies on PER_ASSIGNMENTS_F

Line 1931: per_assignments_f paf,

1927:
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