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.PER_NL_DSR_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 625: FROM hr_organization_units hou

621: CURSOR csr_org_struct_check (c_bg_id IN NUMBER
622: ,c_org_id IN NUMBER) IS
623:
624: SELECT 1
625: FROM hr_organization_units hou
626: WHERE hou.business_group_id = c_bg_id
627: AND hou.organization_id = c_org_id
628: AND EXISTS
629: (

Line 658: FROM hr_organization_units hou

654: ,c_start_date IN DATE
655: ,c_end_date IN DATE) IS
656:
657: SELECT 1
658: FROM hr_organization_units hou
659: WHERE hou.organization_id = c_org_id
660: AND hou.business_group_id = c_bg_id
661: AND EXISTS
662: (

Line 664: FROM hr_organization_units hou1

660: AND hou.business_group_id = c_bg_id
661: AND EXISTS
662: (
663: SELECT 1
664: FROM hr_organization_units hou1
665: ,hr_organization_information hoi1
666: WHERE hoi1.org_information_context = 'NL_ORG_INFORMATION'
667: AND hou1.business_group_id = c_bg_id
668: AND hou1.organization_id = hou.organization_id

Line 694: FROM hr_organization_units hou2

690: ,hr_general.end_of_time) >= c_end_date
691: )
692: UNION
693: SELECT 1
694: FROM hr_organization_units hou2
695: ,hr_organization_information hoi2
696: WHERE hoi2.org_information_context = 'NL_LE_TAX_DETAILS'
697: AND hou2.business_group_id = c_bg_id
698: AND hou2.organization_id = hou.organization_id

Line 1304: ,hr_organization_units hou

1300: SELECT hou.organization_id org_id
1301: ,hou.name org_name
1302: ,hoi.org_information4 tax_reg
1303: FROM per_all_assignments_f pas
1304: ,hr_organization_units hou
1305: ,hr_organization_information hoi
1306: ,per_org_structure_versions posv
1307: WHERE posv.organization_structure_id = p_org_struct_id
1308: AND p_abs_start_date BETWEEN posv.date_from

Line 1322: ,hr_organization_units hou

1318: SELECT hou.organization_id org_id
1319: ,hou.name org_name
1320: ,hoi.org_information1 tax_reg
1321: FROM per_all_assignments_f pas
1322: ,hr_organization_units hou
1323: ,hr_organization_information hoi
1324: WHERE pas.assignment_id = p_assignment_id
1325: AND hou.organization_id = pas.establishment_id
1326: AND hoi.organization_id = hou.organization_id

Line 1435: ,hr_organization_units hou

1431: ,hoi.org_information7 est_name
1432: ,hoi.org_information8 gender_contact
1433: ,hoi.org_information9 ph_no_contact
1434: FROM per_all_assignments_f pas
1435: ,hr_organization_units hou
1436: ,hr_organization_information hoi
1437: WHERE pas.assignment_id = p_assignment_id
1438: AND p_start_date BETWEEN pas.effective_start_date
1439: AND pas.effective_end_date

Line 2271: FROM hr_organization_units

2267: WHERE organization_structure_id = p_org_struct_id;
2268:
2269: CURSOR c_get_employer(p_org_id IN NUMBER) IS
2270: SELECT name
2271: FROM hr_organization_units
2272: WHERE organization_id = p_org_id;
2273:
2274: CURSOR c_get_employee(p_person_id IN NUMBER) IS
2275: SELECT full_name