APPS.PER_NL_DSRR_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 1173: ,hr_organization_information hoi

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

Line 1191: ,hr_organization_information hoi

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

Line 1267: ,hr_organization_information hoi

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