DBA Data[Home] [Help]

APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 123: from PER_ORG_STRUCTURE_ELEMENTS posev

119: (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
120: or (
121: (hoi.organization_id in (select
122: posev.ORGANIZATION_ID_child
123: from PER_ORG_STRUCTURE_ELEMENTS posev
124: where posev.org_structure_version_id = (pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
125: and exists (
126: select null
127: from hr_organization_information