DBA Data[Home] [Help]

APPS.PA_HR_UPDATE_PA_ENTITIES dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 2432: per_assignment_status_types status

2428: --Bug 9762784 Start
2429: CURSOR chk_asgn (l_person_id NUMBER, l_start_date_new DATE) IS
2430: select 'Y'
2431: from per_all_assignments_f asgn,
2432: per_assignment_status_types status
2433: where asgn.person_id = l_person_id
2434: and trunc(l_start_date_new) between trunc(asgn.effective_start_date) and trunc(asgn.effective_end_date)
2435: and asgn.assignment_type in ('E', 'C')
2436: and asgn.primary_flag ='Y'