eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SE_EMPLOYMENT_STATISTICS dependencies on HR_ORGANIZATION_UNITS

Line 242: FROM hr_organization_units o1

238: IS
239: SELECT o1.NAME legal_employer_name
240: , hoi2.org_information2 org_number
241: , hoi1.organization_id legal_id
242: FROM hr_organization_units o1
243: , hr_organization_information hoi1
244: , hr_organization_information hoi2
245: WHERE o1.business_group_id = g_business_group_id
246: AND hoi1.organization_id = o1.organization_id

Line 292: from HR_ORGANIZATION_UNITS o1

288: csr_local_unit_ID NUMBER
289: )
290: is
291: select o1.NAME LU_NAME,hoi2.ORG_INFORMATION2 CFAR
292: from HR_ORGANIZATION_UNITS o1
293: , HR_ORGANIZATION_INFORMATION hoi1
294: , HR_ORGANIZATION_INFORMATION hoi2
295: WHERE o1.business_group_id = g_business_group_id
296: and hoi1.organization_id = o1.organization_id

Line 343: FROM hr_organization_units hou_le,

339: ) is
340: SELECT hoi_le.org_information1 local_unit_id,
341: hou_lu.NAME local_unit_name,
342: hoi_lu.org_information2 CFAR
343: FROM hr_organization_units hou_le,
344: hr_organization_information hoi_le,
345: hr_organization_units hou_lu,
346: hr_organization_information hoi_lu
347: WHERE hoi_le.organization_id = hou_le.organization_id

Line 345: hr_organization_units hou_lu,

341: hou_lu.NAME local_unit_name,
342: hoi_lu.org_information2 CFAR
343: FROM hr_organization_units hou_le,
344: hr_organization_information hoi_le,
345: hr_organization_units hou_lu,
346: hr_organization_information hoi_lu
347: WHERE hoi_le.organization_id = hou_le.organization_id
348: AND hou_le.organization_id = csr_legal_employer_ID
349: AND hoi_le.org_information_context = 'SE_LOCAL_UNITS'

Line 358: from hr_organization_units o1,

354: -- ********************* for ALL LU for GIVEN LE***********************
355: -- ********************* ALL LE for GIVEN Business group id***********************
356: CURSOR csr_ALL_LE_FOR_BG is
357: select o1.name legal_employer_name,hoi1.organization_id
358: from hr_organization_units o1,
359: hr_organization_information hoi1,
360: hr_organization_information hoi2
361: where o1.business_group_id = g_business_group_id
362: and hoi1.organization_id = o1.organization_id

Line 504: hr_organization_units WHERE

500: AND effective_end_date > p_effecive_end_date);
501:
502: CURSOR csr_local_unit_details(p_local_unit_id number) IS
503: SELECT NAME FROM
504: hr_organization_units WHERE
505: organization_id=p_local_unit_id;
506:
507: -- VARIABLE FOR THIS REPORET
508: L_DATE_OF_REPORT VARCHAR2(6);