APPS.CREATE_GB_RTI_EPS_RECORD_13 dependencies on HR_ORGANIZATION_INFORMATION

Line 53: FROM hr_organization_information hoi

49: NVL(substr(TRIM(HOI.ORG_INFORMATION19),1,1),'N') L_SERVICE_PROVIDER,
50: NVL(TRIM(HOI.ORG_INFORMATION16),'Partial') L_SMP_RECOVERY,
51: NVL(TRIM(HOI.ORG_INFORMATION17),'None') L_SSP_RECOVERY,
52: TRIM(HOI.ORG_INFORMATION18) L_APPROVER_ID
53: FROM hr_organization_information hoi
54: WHERE hoi.organization_id = g_business_group_id
55: AND hoi.org_information_context = 'Tax Details References'
56: AND NVL(HOI.ORG_INFORMATION10,'UK') = 'UK'
57: AND hoi.org_information1 = g_paye_reference;