DBA Data[Home] [Help]

APPS.HR_BIS_ORG_PERF dependencies on HR_ORGANIZATION_UNITS

Line 126: from hr_organization_units org

122: cursor get_organizations
123: ( cp_org_param_id NUMBER )
124: is
125: select org.organization_id
126: from hr_organization_units org
127: , hri_org_param_list opl
128: where opl.org_param_id = cp_org_param_id
129: and opl.organization_id_child = org.organization_id
130: group by org.organization_id; -- S.Bhattal, 19/07/99

Line 381: from hr_organization_units org

377: cursor get_organizations
378: ( cp_org_param_id NUMBER )
379: is
380: select org.organization_id
381: from hr_organization_units org
382: , hri_org_param_list opl
383: where opl.org_param_id = cp_org_param_id
384: and opl.organization_id_child = org.organization_id
385: group by org.organization_id; -- S.Bhattal, 19/07/99