DBA Data[Home] [Help]

APPS.HR_GBNIDIR dependencies on PER_PEOPLE_F

Line 1140: from per_people_f p,

1136:
1137: select nvl(min(p.effective_start_date)
1138: ,to_date('31-12-4712','dd-mm-yyyy'))
1139: into l_start_of_director_date
1140: from per_people_f p,
1141: per_assignments_f ASS
1142: where p.per_information2 = 'Y'
1143: and ASS.assignment_id = p_assignment_id
1144: and l_effective_date between