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;