DBA Data[Home] [Help]

APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 117: from PER_ORG_STRUCTURE_ELEMENTS posev

113: (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
114: or (
115: (hoi.organization_id in (select
116: posev.ORGANIZATION_ID_child
117: from PER_ORG_STRUCTURE_ELEMENTS posev
118: where posev.org_structure_version_id = (pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
119: and exists (
120: select null
121: from hr_organization_information