DBA Data[Home] [Help]

APPS.PAY_KR_YEA_DON_EFILE_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 28: from PER_ORG_STRUCTURE_ELEMENTS posev

24: and hoi1.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
25: and bp2.business_group_id = bp1.business_group_id
26: and ( (report_for_var = 'A')
27: or ( (hoi2.organization_id in ( select posev.ORGANIZATION_ID_child
28: from PER_ORG_STRUCTURE_ELEMENTS posev
29: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
30: and exists ( select null
31: from hr_organization_information
32: where organization_id = posev.ORGANIZATION_ID_child