DBA Data[Home] [Help]

APPS.PAY_IE_P35 dependencies on HR_ORGANIZATION_INFORMATION

Line 4574: hr_organization_information hoi1,

4570: NVL (TRIM (RPAD (hl.TELEPHONE_NUMBER_2, 12)), ' ') --('FAX_NO=P') /*Added for bug fix 3815830*/
4571: FROM hr_all_organization_units hou,
4572: hr_locations hl,
4573: pay_payroll_actions ppa,
4574: hr_organization_information hoi1,
4575: hr_organization_information hoi2
4576: WHERE ppa.payroll_action_id = p_payroll_action_id
4577: AND hou.business_group_id = ppa.business_group_id
4578: AND hou.organization_id = pay_ie_p35.get_parameter (ppa.payroll_action_id, 'EMP_NO')

Line 4575: hr_organization_information hoi2

4571: FROM hr_all_organization_units hou,
4572: hr_locations hl,
4573: pay_payroll_actions ppa,
4574: hr_organization_information hoi1,
4575: hr_organization_information hoi2
4576: WHERE ppa.payroll_action_id = p_payroll_action_id
4577: AND hou.business_group_id = ppa.business_group_id
4578: AND hou.organization_id = pay_ie_p35.get_parameter (ppa.payroll_action_id, 'EMP_NO')
4579: AND hl.location_id(+) = hou.location_id