DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1161: FROM PER_ASSIGNMENT_EXTRA_INFO

1157: , AEI_INFORMATION27
1158: , AEI_INFORMATION28
1159: , AEI_INFORMATION29
1160: , AEI_INFORMATION30
1161: FROM PER_ASSIGNMENT_EXTRA_INFO
1162: WHERE assignment_id in (SELECT assignment_id from PER_ASSIGNMENTS_F
1163: WHERE person_id = p_person_id
1164: and business_group_id = p_business_group_id
1165: and p_eff_date between effective_start_date and nvl(effective_end_date,to_date('31/12/4712','Dd/MM/YYYY')));