DBA Data[Home] [Help]

APPS.HR_DYNSQL dependencies on HR_ORGANIZATION_INFORMATION

Line 1973: hr_organization_information houi

1969: from dual
1970: where exists (
1971: select ''
1972: from hr_organization_units hou,
1973: hr_organization_information houi
1974: where hou.organization_id = houi.organization_id
1975: and hou.organization_id = l_local_unit_id
1976: and houi.org_information_context = 'CLASS'
1977: and houi.org_information1 =

Line 3599: hr_organization_information hoi

3595: orgfrom := '
3596: from
3597: pay_payroll_actions pay_pac,
3598: hr_organization_units hou,
3599: hr_organization_information hoi
3600: where pay_pac.payroll_action_id = pay_proc_environment_pkg.get_pactid()
3601: and hou.business_group_id = pay_pac.business_group_id
3602: and hoi.organization_id = hou.organization_id
3603: and hoi.org_information_context = ''CLASS''