DBA Data[Home] [Help]

APPS.PAY_CA_WF_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1170: from hr_all_organization_units hou,

1166: if p_gre_or_tax_group = 'Tax Group' then
1167: begin
1168: select hou.name
1169: into lv_tax_group
1170: from hr_all_organization_units hou,
1171: hr_organization_information hoi
1172: where hou.organization_id = hoi.organization_id
1173: and hoi.org_information_context = 'CLASS'
1174: and hoi.org_information1 = 'CA_TAX_GROUP'