APPS.PAY_NL_WAGE_REPORT_PKG dependencies on HR_NL_ORG_INFO

Line 4336: AND hr_nl_org_info.Get_Tax_Org_Id(posv.ORG_STRUCTURE_VERSION_ID ,hoi2.organization_id) = c_employer_id

4332: AND hoi1.org_information_context= 'NL_UWV'
4333: AND hoi3.organization_id = c_business_group_id
4334: AND hoi3.org_information_context= 'NL_BG_INFO'
4335: --AND hoi2.org_information7 = 'Y'
4336: AND hr_nl_org_info.Get_Tax_Org_Id(posv.ORG_STRUCTURE_VERSION_ID ,hoi2.organization_id) = c_employer_id
4337: AND posv.ORGANIZATION_STRUCTURE_ID = TO_NUMBER(hoi3.org_information1)
4338: AND c_effective_date BETWEEN posv.date_from
4339: AND nvl(posv.date_to,to_date('31-12-4712','dd-mm-yyyy'))
4340: AND c_effective_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information1)

Line 8142: WHERE hoi.organization_id = nvl( aei.aei_information8,HR_NL_ORG_INFO.Get_SI_Provider_Info(aei.assignment_id,aei.AEI_INFORMATION3))

8138: ,fnd_date.canonical_to_date(aei.AEI_INFORMATION1) start_date
8139: ,fnd_date.canonical_to_date(aei.AEI_INFORMATION2) end_date
8140: FROM hr_organization_information hoi
8141: ,per_assignment_extra_info aei
8142: WHERE hoi.organization_id = nvl( aei.aei_information8,HR_NL_ORG_INFO.Get_SI_Provider_Info(aei.assignment_id,aei.AEI_INFORMATION3))
8143: AND aei.assignment_id = c_assignment_id
8144: AND aei.information_type = 'NL_SII'
8145: AND aei.aei_information3 IN ('WW','AMI','ZW','WAO')
8146: AND hoi.org_information5 IS NOT NULL

Line 8154: WHERE organization_id IN (SELECT HR_NL_ORG_INFO.Get_SI_Provider_Info(assignment_id,AEI_INFORMATION3)

8150: /*SELECT DISTINCT organization_id
8151: ,org_information5 sector
8152: ,org_information6 risk_group
8153: FROM hr_organization_information
8154: WHERE organization_id IN (SELECT HR_NL_ORG_INFO.Get_SI_Provider_Info(assignment_id,AEI_INFORMATION3)
8155: FROM per_assignment_extra_info
8156: WHERE assignment_id = c_assignment_id
8157: AND information_type = 'NL_SII'
8158: AND aei_information3 IN ('WW','AMI'))