DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1140: FROM PER_ASSIGNMENT_EXTRA_INFO

1136: , AEI_INFORMATION27
1137: , AEI_INFORMATION28
1138: , AEI_INFORMATION29
1139: , AEI_INFORMATION30
1140: FROM PER_ASSIGNMENT_EXTRA_INFO
1141: WHERE assignment_id in (SELECT assignment_id from PER_ASSIGNMENTS_F
1142: WHERE person_id = p_person_id
1143: and business_group_id = p_business_group_id
1144: and p_eff_date between effective_start_date and nvl(effective_end_date,to_date('31/12/4712','Dd/MM/YYYY')));