DBA Data[Home] [Help]

APPS.PAY_CA_WF_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1448: from hr_all_organization_units hou,

1444: if p_gre_or_tax_group = 'Tax Group' then
1445: begin
1446: select hou.name
1447: into lv_tax_group
1448: from hr_all_organization_units hou,
1449: hr_organization_information hoi
1450: where hou.organization_id = hoi.organization_id
1451: and hoi.org_information_context = 'CLASS'
1452: and hoi.org_information1 = 'CA_TAX_GROUP'

Line 3584: from hr_all_organization_units hou,

3580: if p_gre_or_tax_group = 'Tax Group' then
3581: begin
3582: select hou.name
3583: into lv_tax_group
3584: from hr_all_organization_units hou,
3585: hr_organization_information hoi
3586: where hou.organization_id = hoi.organization_id
3587: and hoi.org_information_context = 'CLASS'
3588: and hoi.org_information1 = 'CA_TAX_GROUP'