DBA Data[Home] [Help]

APPS.PAY_DK_MIA_REPORT_PKG dependencies on HR_ORGANIZATION_UNITS

Line 66: FROM HR_ORGANIZATION_UNITS hou1

62: ,'ORGANIZATION_TOWN=P' ,substr((loc.POSTAL_CODE ||' ' || loc.TOWN_OR_CITY),1,40)
63: ,'PAY_PERIOD=P' , to_char(ppa.effective_date,'YYYYMM')
64: ,'PAYROLL_ACTION_ID=C' , ppa.payroll_action_id
65:
66: FROM HR_ORGANIZATION_UNITS hou1
67: , HR_ORGANIZATION_INFORMATION hoi1
68: , HR_ORGANIZATION_INFORMATION hoi2
69: , HR_LOCATIONS loc
70: , PAY_PAYROLL_ACTIONS ppa

Line 109: , HR_ORGANIZATION_UNITS hou

105: , pay_payrolls_f PPF
106: , pay_payroll_actions PPA
107: , per_periods_of_service PPS
108: , hr_soft_coding_keyflex SCL
109: , HR_ORGANIZATION_UNITS hou
110: , HR_ORGANIZATION_INFORMATION hoi1
111: , HR_ORGANIZATION_INFORMATION hoi2
112: WHERE
113: --ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')