DBA Data[Home] [Help]

APPS.PAY_US_MMREF_LOCAL_XML dependencies on HR_ORGANIZATION_INFORMATION

Line 313: FROM hr_organization_information hoi

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

Line 403: FROM hr_organization_information hoi

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