DBA Data[Home] [Help]

APPS.PAY_DK_TAX_CARD_REQUEST_PKG dependencies on HR_LOCATIONS

Line 32: , HR_LOCATIONS loc

28: ,'ORGANIZATION_ADDR=P', loc.ADDRESS_LINE_1||' '||loc.ADDRESS_LINE_2||' '||loc.ADDRESS_LINE_3
29: FROM HR_ORGANIZATION_UNITS hou1
30: , HR_ORGANIZATION_INFORMATION hoi1
31: , HR_ORGANIZATION_INFORMATION hoi2
32: , HR_LOCATIONS loc
33: , PAY_PAYROLL_ACTIONS ppa
34: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
35: and hou1.business_group_id = ppa.BUSINESS_GROUP_ID
36: and hou1.organization_id = nvl(PAY_DK_TAX_CARD_REQUEST_PKG.get_parameter(legislative_parameters,'LEGAL_EMPLOYER_NAME',null),hou1.organization_id)