DBA Data[Home] [Help]

APPS.HR_NL_DAILY_SICK_AND_RECOVERY dependencies on PER_ALL_ASSIGNMENTS_F

Line 286: from per_all_assignments_f paaf

282: select
283: paaf.person_id person_id
284: ,paaf.effective_start_date effective_start_date
285: ,paaf.effective_end_date effective_end_date
286: from per_all_assignments_f paaf
287: where paaf.primary_flag = 'Y'
288: and paaf.organization_id in
289: (SELECT pose1.organization_id_child
290: FROM (SELECT pose.organization_id_child ,