DBA Data[Home] [Help]

APPS.HR_NL_LAW_SAMEN_REPORT dependencies on PER_ORGANIZATION_UNITS

Line 253: FROM PER_ORGANIZATION_UNITS POU

249: ,P_REPORT_YEAR NUMBER
250: ,P_REGION VARCHAR2)
251: is
252: SELECT distinct POU.ORGANIZATION_ID organization_id
253: FROM PER_ORGANIZATION_UNITS POU
254: WHERE POU.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
255: AND POU.ORGANIZATION_ID = HR_NL_ORG_INFO.Check_Org_In_Region(POU.ORGANIZATION_ID,P_REGION)
256: AND TO_NUMBER(TO_CHAR(POU.DATE_FROM,'YYYY'))<= P_REPORT_YEAR
257: AND TO_NUMBER(TO_CHAR(NVL(POU.DATE_TO,SYSDATE),'YYYY')) >= P_REPORT_YEAR;