APPS.HR_GBNIDIR dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1596: from per_assignments_f a, per_assignment_status_types st

1592: --
1593: l_count := 0;
1594:
1595: select count(1) into l_count
1596: from per_assignments_f a, per_assignment_status_types st
1597: where st.assignment_status_type_id = a.assignment_status_type_id
1598: and p_date between a.effective_start_date and a.effective_end_date
1599: and a.payroll_id = p_payroll_id
1600: and st.pay_system_status = 'P';