APPS.PAY_DK_MIA_REPORT_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 67: , HR_ORGANIZATION_INFORMATION hoi1

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
71: WHERE

Line 68: , HR_ORGANIZATION_INFORMATION hoi2

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
71: WHERE
72: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 110: , HR_ORGANIZATION_INFORMATION hoi1

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')
114: ppa.business_group_id = PAY_DK_MIA_REPORT_PKG.get_business_group_id(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))

Line 111: , HR_ORGANIZATION_INFORMATION hoi2

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')
114: ppa.business_group_id = PAY_DK_MIA_REPORT_PKG.get_business_group_id(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
115: --AND PAA.business_group_id = ppa.business_group_id