APPS.PER_NL_WAZO_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 493: FROM hr_organization_units hou

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

Line 526: FROM hr_organization_units hou

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

Line 532: FROM hr_organization_units hou1

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

Line 562: FROM hr_organization_units hou2

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

Line 1170: ,hr_organization_units hou

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

Line 1188: ,hr_organization_units hou

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

Line 1280: ,hr_organization_units hou

1276: ,hoi.org_information7 est_name
1277: ,hoi.org_information8 gender_contact
1278: ,hoi.org_information9 ph_no_contact
1279: FROM per_all_assignments_f pas
1280: ,hr_organization_units hou
1281: ,hr_organization_information hoi
1282: WHERE pas.assignment_id = p_assignment_id
1283: AND p_start_date BETWEEN pas.effective_start_date
1284: AND pas.effective_end_date

Line 1905: FROM hr_organization_units

1901:
1902:
1903: CURSOR c_get_employer(p_org_id IN NUMBER) IS
1904: SELECT name
1905: FROM hr_organization_units
1906: WHERE organization_id = p_org_id;
1907:
1908: CURSOR c_get_employee(p_person_id IN NUMBER) IS
1909: SELECT full_name