APPS.PAY_US_MMREF_LOCAL_XML dependencies on HR_ORGANIZATION_INFORMATION

Line 314: FROM hr_organization_information hoi

310: AND pustif.effective_end_date
311: AND pustif.sit_exists = ''Y'')
312: AND NOT EXISTS (
313: SELECT ''x''
314: FROM hr_organization_information hoi
315: WHERE hoi.organization_id = paa.tax_unit_id
316: AND hoi.org_information_context = ''1099R Magnetic Report Rules''
317: )
318: ORDER BY to_number(paa.serial_number)';

Line 404: FROM hr_organization_information hoi

400: AND paf.person_id BETWEEN p_stperson AND p_endperson
401: AND NOT EXISTS
402: (
403: SELECT 'x'
404: FROM hr_organization_information hoi
405: WHERE hoi.organization_id = paa.tax_unit_id
406: AND hoi.org_information_context = '1099R Magnetic Report Rules'
407: )
408: AND rtrim(ltrim(fai1.value)) <> '0'

Line 466: FROM hr_organization_information hoi

462: AND paf.person_id BETWEEN p_stperson AND p_endperson
463: AND NOT EXISTS
464: (
465: SELECT 'x'
466: FROM hr_organization_information hoi
467: WHERE hoi.organization_id = paa.tax_unit_id
468: AND hoi.org_information_context = '1099R Magnetic Report Rules'
469: )
470: AND rtrim(ltrim(fai1.value)) <> '0'