DBA Data[Home] [Help]

APPS.HR_DYNSQL dependencies on HR_ORGANIZATION_INFORMATION

Line 2008: hr_organization_information houi

2004: from dual
2005: where exists (
2006: select ''
2007: from hr_organization_units hou,
2008: hr_organization_information houi
2009: where hou.organization_id = houi.organization_id
2010: and hou.organization_id = l_local_unit_id
2011: and houi.org_information_context = 'CLASS'
2012: and houi.org_information1 =

Line 3718: hr_organization_information hoi

3714: orgfrom := '
3715: from
3716: pay_payroll_actions pay_pac,
3717: hr_organization_units hou,
3718: hr_organization_information hoi
3719: where pay_pac.payroll_action_id = pay_proc_environment_pkg.get_pactid()
3720: and hou.business_group_id = pay_pac.business_group_id
3721: and hoi.organization_id = hou.organization_id
3722: and hoi.org_information_context = ''CLASS''