APPS.PER_NL_LTSR_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 498: ,hr_organization_information hoi1

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

Line 508: ,hr_organization_information hoi2

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

Line 531: ,hr_organization_information hoi1

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

Line 561: ,hr_organization_information hoi2

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

Line 1168: ,hr_organization_information hoi

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

Line 1186: ,hr_organization_information hoi

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

Line 1255: ,hr_organization_information hoi

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