DBA Data[Home] [Help]

APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 96: from PER_ORG_STRUCTURE_ELEMENTS posev

92: and phou.organization_id = phoi.organization_id
93: --Bug 5069923
94: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
95: or ( (hoi.organization_id in (select posev.ORGANIZATION_ID_child
96: from PER_ORG_STRUCTURE_ELEMENTS posev
97: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
98: and exists ( select null
99: from hr_organization_information
100: where organization_id = posev.ORGANIZATION_ID_child