DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MAGTAPE_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 81: from PER_ORG_STRUCTURE_ELEMENTS posev

77: and bp2.business_group_id = bp1.business_group_id
78: --Bug 5069923
79: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
80: or ( (hoi2.organization_id in ( select posev.ORGANIZATION_ID_child
81: from PER_ORG_STRUCTURE_ELEMENTS posev
82: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
83: and exists ( select null
84: from hr_organization_information
85: where organization_id = posev.ORGANIZATION_ID_child