APPS.PER_NL_FDR_ARCHIVE dependencies on HR_NL_ORG_INFO

Line 439: and (hr_nl_org_info.get_tax_org_id(posv.org_structure_version_id,paa.organization_id) is not null

435: or not exists(select 1 from per_people_extra_info ppei
436: where ppei.person_id=p_person_id
437: and information_type='NL_FIRST_DAY_REPORT')
438: )
439: and (hr_nl_org_info.get_tax_org_id(posv.org_structure_version_id,paa.organization_id) is not null
440: OR
441: per_nl_fdr_archive.org_check(pap.business_group_id, null, nvl(paa.establishment_id,-1), to_date(p_report_date,'RRRR/MM/DD')) = 1)
442: and paa.organization_id in
443: (select pose.organization_id_parent

Line 810: and (hr_nl_org_info.get_tax_org_id(posv.org_structure_version_id,paa.organization_id) is not null

806: and paa.primary_flag = 'Y'
807: and past.assignment_status_type_id = paa.assignment_status_type_id
808: and past.per_system_status = 'ACTIVE_ASSIGN'
809: and get_ref_date(pap.person_id) between paa.effective_start_date and paa.effective_end_date
810: and (hr_nl_org_info.get_tax_org_id(posv.org_structure_version_id,paa.organization_id) is not null
811: OR
812: per_nl_fdr_archive.org_check(pap.business_group_id, null, nvl(paa.establishment_id,-1), to_date(p_report_date,'RRRR/MM/DD')) = 1)
813: and paa.organization_id in
814: (select pose.organization_id_parent

Line 944: and hou.organization_id = hr_nl_org_info.get_tax_org_id(posv.org_structure_version_id, pas.organization_id)

940: and pas.assignment_id = paa.assignment_id
941: and past.assignment_status_type_id = pas.assignment_status_type_id
942: and past.per_system_status = 'ACTIVE_ASSIGN'
943: and get_ref_date(pas.person_id) between pas.effective_start_date and pas.effective_end_date
944: and hou.organization_id = hr_nl_org_info.get_tax_org_id(posv.org_structure_version_id, pas.organization_id)
945: and hoi.organization_id = hou.organization_id
946: and hoi.org_information_context = 'NL_ORG_INFORMATION';
947:
948:

Line 1344: and hr_nl_org_info.get_tax_org_id(posv.org_structure_version_id,paa.organization_id) is null

1340: and paa.primary_flag = 'Y'
1341: and past.assignment_status_type_id = paa.assignment_status_type_id
1342: and past.per_system_status = 'ACTIVE_ASSIGN'
1343: and get_ref_date(pap.person_id) between paa.effective_start_date and paa.effective_end_date
1344: and hr_nl_org_info.get_tax_org_id(posv.org_structure_version_id,paa.organization_id) is null
1345: and per_nl_fdr_archive.org_check(pap.business_group_id, null, nvl(paa.establishment_id,-1), to_date(p_report_date,'RRRR/MM/DD')) = 0
1346: and paa.organization_id in
1347: (select pose.organization_id_parent
1348: from per_org_structure_elements pose