DBA Data[Home] [Help]

APPS.HR_NL_LAW_SAMEN_REPORT dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 196: from per_org_structure_versions posv

192: (P_ORGANIZATION_STRUCTURE_ID NUMBER
193: ,P_REPORT_YEAR NUMBER)
194: is
195: select max(posv.org_structure_version_id) org_structure_version_id
196: from per_org_structure_versions posv
197: where posv.organization_structure_id = P_ORGANIZATION_STRUCTURE_ID
198: and to_number(to_char(nvl(posv.date_from,sysdate),'YYYY')) <= P_REPORT_YEAR
199: and to_number(to_char(nvl(posv.date_to,sysdate),'YYYY')) >= P_REPORT_YEAR
200: order by posv.org_structure_version_id;

Line 209: from per_org_structure_elements ose, per_org_structure_versions_v posv

205: ,P_TOP_ORGANIZATION_ID NUMBER
206: ,P_ORG_STRUCTURE_ID NUMBER)
207: is
208: select distinct ose.organization_id_child organization_id
209: from per_org_structure_elements ose, per_org_structure_versions_v posv
210: where ose.org_structure_version_id = posv.ORG_STRUCTURE_VERSION_ID
211: and ose.BUSINESS_GROUP_ID = posv.BUSINESS_GROUP_ID
212: and posv.ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID
213: and posv.ORGANIZATION_STRUCTURE_ID = P_ORG_STRUCTURE_ID