DBA Data[Home] [Help]

APPS.PAY_MWS_MAGTAPE_REPORTING dependencies on HR_ORGANIZATION_INFORMATION

Line 348: from hr_organization_information hoi2

344: or paf.effective_end_date >= l_end_date2
345: or paf.effective_end_date >= l_end_date3)
346: and scl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
347: and exists ( select null
348: from hr_organization_information hoi2
349: where hoi2.organization_id = paf.organization_id
350: and hoi2.org_information_context = 'CLASS'
351: and hoi2.org_information1 = 'HR_ESTAB'
352: and hoi2.org_information2 = 'Y')

Line 355: from hr_organization_information hoi

351: and hoi2.org_information1 = 'HR_ESTAB'
352: and hoi2.org_information2 = 'Y')
353: and exists(
354: select null
355: from hr_organization_information hoi
356: where hoi.organization_id = paf.organization_id
357: and hoi.org_information_context =
358: 'Worksite Filing')
359: group by paf.person_id,