DBA Data[Home] [Help]

APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 93: from PER_ORG_STRUCTURE_ELEMENTS posev

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