DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MED_EFILE_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 56: from PER_ORG_STRUCTURE_ELEMENTS posev

52: and bhoi.organization_id = hou1.organization_id
53: --Bug 5069923
54: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
55: or ( (bhoi.organization_id in ( select posev.ORGANIZATION_ID_child
56: from PER_ORG_STRUCTURE_ELEMENTS posev
57: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
58: and exists ( select null
59: from hr_organization_information
60: where organization_id = posev.ORGANIZATION_ID_child