APPS.PER_NL_DSRR_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 1172: ,hr_organization_units hou

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

Line 1190: ,hr_organization_units hou

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

Line 1266: ,hr_organization_units hou

1262: ,hoi.org_information7 est_name
1263: ,hoi.org_information8 gender_contact
1264: ,hoi.org_information9 ph_no_contact
1265: FROM per_all_assignments_f pas
1266: ,hr_organization_units hou
1267: ,hr_organization_information hoi
1268: WHERE pas.assignment_id = p_assignment_id
1269: AND p_start_date BETWEEN pas.effective_start_date
1270: AND pas.effective_end_date

Line 1657: FROM hr_organization_units

1653: WHERE organization_structure_id = p_org_struct_id;
1654:
1655: CURSOR c_get_employer(p_org_id IN NUMBER) IS
1656: SELECT name
1657: FROM hr_organization_units
1658: WHERE organization_id = p_org_id;
1659:
1660: CURSOR c_get_employee(p_person_id IN NUMBER) IS
1661: SELECT full_name