APPS.CREATE_GB_RTI_EPS_RECORD dependencies on HR_ORGANIZATION_INFORMATION

Line 44: FROM hr_organization_information hoi

40: NVL(substr(TRIM(HOI.ORG_INFORMATION19),1,1),'N') L_SERVICE_PROVIDER,
41: NVL(TRIM(HOI.ORG_INFORMATION16),'Partial') L_SMP_RECOVERY,
42: NVL(TRIM(HOI.ORG_INFORMATION17),'None') L_SSP_RECOVERY,
43: TRIM(HOI.ORG_INFORMATION18) L_APPROVER_ID
44: FROM hr_organization_information hoi
45: WHERE hoi.organization_id = g_business_group_id
46: AND hoi.org_information_context = 'Tax Details References'
47: AND NVL(HOI.ORG_INFORMATION10,'UK') = 'UK'
48: AND hoi.org_information1 = g_paye_reference;

Line 454: FROM hr_organization_information hoi

450:
451: CURSOR get_smp_org_value
452: IS
453: SELECT NVL(TRIM(HOI.ORG_INFORMATION16),'None') L_SMP_RECOVERY
454: FROM hr_organization_information hoi
455: WHERE hoi.organization_id = g_business_group_id
456: AND hoi.org_information_context = 'Tax Details References'
457: AND NVL(HOI.ORG_INFORMATION10,'UK') = 'UK'
458: AND hoi.org_information1 = g_paye_reference;