APPS.PAY_NL_WAGE_REPORT_PKG dependencies on HR_NL_ORG_INFO

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

2814: AND hoi1.org_information_context= 'NL_UWV'
2815: AND hoi3.organization_id = c_business_group_id
2816: AND hoi3.org_information_context= 'NL_BG_INFO'
2817: --AND hoi2.org_information7 = 'Y'
2818: AND hr_nl_org_info.Get_Tax_Org_Id(posv.ORG_STRUCTURE_VERSION_ID ,hoi2.organization_id) = c_employer_id
2819: AND posv.ORGANIZATION_STRUCTURE_ID = TO_NUMBER(hoi3.org_information1)
2820: AND c_effective_date BETWEEN posv.date_from
2821: AND nvl(posv.date_to,to_date('31-12-4712','dd-mm-yyyy'))
2822: AND c_effective_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information1)

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

4985: ,fnd_date.canonical_to_date(aei.AEI_INFORMATION1) start_date
4986: ,fnd_date.canonical_to_date(aei.AEI_INFORMATION2) end_date
4987: FROM hr_organization_information hoi
4988: ,per_assignment_extra_info aei
4989: WHERE hoi.organization_id = nvl( aei.aei_information8,HR_NL_ORG_INFO.Get_SI_Provider_Info(aei.assignment_id,aei.AEI_INFORMATION3))
4990: AND aei.assignment_id = c_assignment_id
4991: AND aei.information_type = 'NL_SII'
4992: AND aei.aei_information3 IN ('WW','AMI','ZW','WAO')
4993: AND hoi.org_information5 IS NOT NULL

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

4997: /*SELECT DISTINCT organization_id
4998: ,org_information5 sector
4999: ,org_information6 risk_group
5000: FROM hr_organization_information
5001: WHERE organization_id IN (SELECT HR_NL_ORG_INFO.Get_SI_Provider_Info(assignment_id,AEI_INFORMATION3)
5002: FROM per_assignment_extra_info
5003: WHERE assignment_id = c_assignment_id
5004: AND information_type = 'NL_SII'
5005: AND aei_information3 IN ('WW','AMI'))