APPS.PER_NL_LTSRR_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 499: ,hr_organization_information hoi1

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

Line 509: ,hr_organization_information hoi2

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

Line 532: ,hr_organization_information hoi1

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

Line 562: ,hr_organization_information hoi2

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

Line 1176: , hr_organization_information hoi

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

Line 1194: , hr_organization_information hoi

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

Line 1251: ,hr_organization_information hoi

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