APPS.PER_NL_LTSRR_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 492: FROM hr_organization_units hou

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

Line 525: FROM hr_organization_units hou

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

Line 531: FROM hr_organization_units hou1

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

Line 561: FROM hr_organization_units hou2

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

Line 1175: , hr_organization_units hou

1171: SELECT hou.organization_id org_id
1172: , hou.name org_name
1173: , hoi.org_information4 tax_reg
1174: FROM per_all_assignments_f pas
1175: , hr_organization_units hou
1176: , hr_organization_information hoi
1177: , per_org_structure_versions posv
1178: WHERE posv.organization_structure_id = p_org_struct_id
1179: AND p_abs_start_date BETWEEN posv.date_from

Line 1193: , hr_organization_units hou

1189: SELECT hou.organization_id org_id
1190: , hou.name org_name
1191: , hoi.org_information1 tax_reg
1192: FROM per_all_assignments_f pas
1193: , hr_organization_units hou
1194: , hr_organization_information hoi
1195: WHERE pas.assignment_id = p_assignment_id
1196: AND hou.organization_id = pas.establishment_id
1197: AND hoi.organization_id = hou.organization_id

Line 1250: ,hr_organization_units hou

1246: ,hoi.org_information7 est_name
1247: ,hoi.org_information8 gender_contact
1248: ,hoi.org_information9 ph_no_contact
1249: FROM per_all_assignments_f pas
1250: ,hr_organization_units hou
1251: ,hr_organization_information hoi
1252: WHERE pas.assignment_id = p_assignment_id
1253: AND p_start_date BETWEEN pas.effective_start_date
1254: AND pas.effective_end_date

Line 1680: FROM hr_organization_units

1676: WHERE organization_structure_id = p_org_struct_id;
1677:
1678: CURSOR c_get_employer(p_org_id IN NUMBER) IS
1679: SELECT name
1680: FROM hr_organization_units
1681: WHERE organization_id = p_org_id;
1682:
1683: CURSOR c_get_employee(p_person_id IN NUMBER) IS
1684: SELECT full_name