DBA Data[Home] [Help]

APPS.PAY_KR_YEA_DON_EFILE_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 64: from PER_ORG_STRUCTURE_ELEMENTS posev

60: and hoi1.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
61: and bp2.business_group_id = bp1.business_group_id
62: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
63: or ( (hoi2.organization_id in ( select posev.ORGANIZATION_ID_child
64: from PER_ORG_STRUCTURE_ELEMENTS posev
65: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
66: and exists ( select null
67: from hr_organization_information
68: where organization_id = posev.ORGANIZATION_ID_child