DBA Data[Home] [Help]

APPS.TRR_ENGINE_PKG dependencies on HR_TAX_UNITS_V

Line 22: hr_tax_units_v htu

18: c_jurisdiction_code varchar2)
19: is
20: select count(*) gre_size, puar.tax_unit_id gre_id, htu.name gre_name
21: from pay_us_asg_reporting puar,
22: hr_tax_units_v htu
23: where puar.tax_unit_id=htu.tax_unit_id
24: and htu.business_group_id=c_business_group_id
25: and substr(puar.jurisdiction_code,1,2)=
26: nvl(c_jurisdiction_code,substr(puar.jurisdiction_code,1,2))

Line 249: hr_tax_units_v htu

245: c_jurisdiction_code varchar2)
246: is
247: select count(*) gre_size,puar.tax_unit_id gre_id,htu.name gre_name
248: from pay_us_asg_reporting puar,
249: hr_tax_units_v htu
250: where puar.tax_unit_id=htu.tax_unit_id
251: and htu.business_group_id=c_business_group_id
252: and substr(puar.jurisdiction_code,1,2)=
253: nvl(c_jurisdiction_code,substr(puar.jurisdiction_code,1,2))