DBA Data[Home] [Help]

APPS.PAY_KR_SPAY_EFILE dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 36: from PER_ORG_STRUCTURE_ELEMENTS posev

32: )
33: --Bug 5069923
34: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
35: or ( (hoi.organization_id in (select posev.ORGANIZATION_ID_child
36: from PER_ORG_STRUCTURE_ELEMENTS posev
37: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
38: and exists ( select null
39: from hr_organization_information
40: where organization_id = posev.ORGANIZATION_ID_child

Line 155: from PER_ORG_STRUCTURE_ELEMENTS posev

151: and xppa.report_type = 'KR_SEP'
152: --Bug 5069923
153: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
154: or ( (hoi.organization_id in ( select posev.ORGANIZATION_ID_child
155: from PER_ORG_STRUCTURE_ELEMENTS posev
156: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
157: and exists (select null
158: from hr_organization_information
159: where organization_id = posev.ORGANIZATION_ID_child