[Home] [Help]
APPS.HR_NL_DAILY_SICK_AND_RECOVERY dependencies on PER_ORG_STRUCTURE_ELEMENTS
Line 292: FROM per_org_structure_elements pose
288: and paaf.organization_id in
289: (SELECT pose1.organization_id_child
290: FROM (SELECT pose.organization_id_child ,
291: pose.organization_id_parent
292: FROM per_org_structure_elements pose
293: WHERE pose.org_structure_version_id = p_structure_version_id
294: ) pose1
295: CONNECT BY PRIOR pose1.organization_id_child =
296: pose1.organization_id_parent