DBA Data[Home] [Help]

APPS.HR_DE_ORGANIZATION_UPLOAD dependencies on HR_DE_TAX_OFFICE_DEFINITION_V

Line 13: FROM hr_de_tax_office_definition_v

9: SELECT hr_general.decode_lookup('DE_FED_STATE', bundesland) bundesland_description
10: ,bundesland
11: ,tax_office_no
12: ,tax_office_name
13: FROM hr_de_tax_office_definition_v
14: WHERE bundesland = NVL(p_bundesland, bundesland)
15: ORDER BY hr_general.decode_lookup('DE_FED_STATE', bundesland) ASC;
16: --
17: --