DBA Data[Home] [Help]

APPS.PAY_GB_RTI_NINO_REPLY_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 90: select 1 from hr_organization_information where organization_id = p_business_group

86: */
87: function validate_paye_ref(l_employer_paye_ref varchar2 , p_business_group number) return
88: boolean is
89: cursor csr_paye_ref_exists is
90: select 1 from hr_organization_information where organization_id = p_business_group
91: and org_information1 = l_employer_paye_ref
92: and org_information_context = 'Tax Details References';
93: l_paye_exists number := null;
94: begin