APPS.PER_NL_WAZO_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 500: ,hr_organization_information hoi1

496: AND EXISTS
497: (
498: SELECT 1
499: FROM hr_all_organization_units hou1
500: ,hr_organization_information hoi1
501: WHERE hou1.business_group_id = c_bg_id
502: AND hoi1.org_information_context = 'NL_LE_TAX_DETAILS'
503: AND hoi1.org_information1 IS NOT NULL
504: AND hoi1.org_information2 IS NOT NULL

Line 510: ,hr_organization_information hoi2

506: AND hou1.organization_id = hou.organization_id
507: UNION
508: SELECT 1
509: FROM hr_all_organization_units hou2
510: ,hr_organization_information hoi2
511: WHERE hou2.business_group_id = c_bg_id
512: AND hoi2.org_information_context = 'NL_ORG_INFORMATION'
513: AND hoi2.org_information4 IS NOT NULL
514: AND hoi2.org_information3 IS NOT NULL

Line 533: ,hr_organization_information hoi1

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
537: AND hou1.organization_id = hoi1.organization_id

Line 563: ,hr_organization_information hoi2

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
567: AND hou2.organization_id = hoi2.organization_id

Line 1171: ,hr_organization_information hoi

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
1175: AND nvl (posv.date_to

Line 1189: ,hr_organization_information hoi

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
1193: AND hoi.org_information_context = 'NL_LE_TAX_DETAILS';

Line 1281: ,hr_organization_information hoi

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
1285: AND hou.organization_id = nvl (pas.establishment_id