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_LTSR_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 491: FROM hr_organization_units hou

487: CURSOR csr_org_struct_check (c_bg_id IN NUMBER
488: ,c_org_id IN NUMBER) IS
489:
490: SELECT 1
491: FROM hr_organization_units hou
492: WHERE hou.business_group_id = c_bg_id
493: AND hou.organization_id = c_org_id
494: AND EXISTS
495: (

Line 524: FROM hr_organization_units hou

520: ,c_start_date IN DATE
521: ,c_end_date IN DATE) IS
522:
523: SELECT 1
524: FROM hr_organization_units hou
525: WHERE hou.organization_id = c_org_id
526: AND hou.business_group_id = c_bg_id
527: AND EXISTS
528: (

Line 530: FROM hr_organization_units hou1

526: AND hou.business_group_id = c_bg_id
527: AND EXISTS
528: (
529: SELECT 1
530: FROM hr_organization_units hou1
531: ,hr_organization_information hoi1
532: WHERE hoi1.org_information_context = 'NL_ORG_INFORMATION'
533: AND hou1.business_group_id = c_bg_id
534: AND hou1.organization_id = hou.organization_id

Line 560: FROM hr_organization_units hou2

556: ,hr_general.end_of_time) >= c_end_date
557: )
558: UNION
559: SELECT 1
560: FROM hr_organization_units hou2
561: ,hr_organization_information hoi2
562: WHERE hoi2.org_information_context = 'NL_LE_TAX_DETAILS'
563: AND hou2.business_group_id = c_bg_id
564: AND hou2.organization_id = hou.organization_id

Line 1167: ,hr_organization_units hou

1163: SELECT hou.organization_id org_id
1164: ,hou.name org_name
1165: ,hoi.org_information4 tax_reg
1166: FROM per_all_assignments_f pas
1167: ,hr_organization_units hou
1168: ,hr_organization_information hoi
1169: ,per_org_structure_versions posv
1170: WHERE posv.organization_structure_id = p_org_struct_id
1171: AND p_abs_start_date BETWEEN posv.date_from

Line 1185: ,hr_organization_units hou

1181: SELECT hou.organization_id org_id
1182: ,hou.name org_name
1183: ,hoi.org_information1 tax_reg
1184: FROM per_all_assignments_f pas
1185: ,hr_organization_units hou
1186: ,hr_organization_information hoi
1187: WHERE pas.assignment_id = p_assignment_id
1188: AND hou.organization_id = pas.establishment_id
1189: AND hoi.organization_id = hou.organization_id

Line 1254: ,hr_organization_units hou

1250: ,hoi.org_information7 est_name
1251: ,hoi.org_information8 gender_contact
1252: ,hoi.org_information9 ph_no_contact
1253: FROM per_all_assignments_f pas
1254: ,hr_organization_units hou
1255: ,hr_organization_information hoi
1256: WHERE pas.assignment_id = p_assignment_id
1257: AND p_start_date BETWEEN pas.effective_start_date
1258: AND pas.effective_end_date

Line 1610: FROM hr_organization_units

1606: WHERE organization_structure_id = p_org_struct_id;
1607:
1608: CURSOR c_get_employer(p_org_id IN NUMBER) IS
1609: SELECT name
1610: FROM hr_organization_units
1611: WHERE organization_id = p_org_id;
1612:
1613: CURSOR c_get_employee(p_person_id IN NUMBER) IS
1614: SELECT full_name