APPS.PAY_US_TRR_ENGINE_PKG dependencies on PAY_US_ASG_REPORTING

Line 22: from pay_us_asg_reporting puar,

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

Line 66: and exists (select '1' from pay_us_asg_reporting puar

62: and info.org_information_context = 'CLASS'
63: and info.org_information1 = 'HR_LEGAL'
64: and hoi.business_group_id = p_business_group
65: and info.organization_id = p_gre
66: and exists (select '1' from pay_us_asg_reporting puar
67: where puar.tax_unit_id = info.organization_id
68: and puar.jurisdiction_code like p_state||'%')
69: group by info.organization_id,hoi.name
70: order by count(*);

Line 82: and exists (select '1' from pay_us_asg_reporting puar

78: and info.org_information_context = 'CLASS'
79: and info.org_information1 = 'HR_LEGAL'
80: and hoi.business_group_id = p_business_group
81: and trunc(nvl(date_to,fnd_date.canonical_to_date(p_start_date)),'Y') >= trunc(fnd_date.canonical_to_date(p_start_date),'Y')
82: and exists (select '1' from pay_us_asg_reporting puar
83: where puar.tax_unit_id = info.organization_id
84: and puar.jurisdiction_code like p_state||'%')
85: group by info.organization_id,hoi.name
86: order by count(*);

Line 387: from pay_us_asg_reporting puar,

383: c_tax_unit_id number,
384: c_jurisdiction_code varchar2)
385: is
386: select count(*) gre_size,puar.tax_unit_id gre_id,htu.name gre_name
387: from pay_us_asg_reporting puar,
388: hr_tax_units_v htu
389: where puar.tax_unit_id=htu.tax_unit_id
390: and htu.business_group_id=c_business_group_id
391: and substr(puar.jurisdiction_code,1,2)=

Line 431: and exists (select '1' from pay_us_asg_reporting puar

427: and info.org_information_context = 'CLASS'
428: and info.org_information1 = 'HR_LEGAL'
429: and hoi.business_group_id = p_business_group
430: and info.organization_id = p_gre
431: and exists (select '1' from pay_us_asg_reporting puar
432: where puar.tax_unit_id = info.organization_id
433: and puar.jurisdiction_code like cv_jurisdiction)
434: group by info.organization_id,hoi.name
435: order by count(*);

Line 447: and exists (select '1' from pay_us_asg_reporting puar

443: and info.org_information_context = 'CLASS'
444: and info.org_information1 = 'HR_LEGAL'
445: and hoi.business_group_id = p_business_group
446: and trunc(nvl(date_to,fnd_date.canonical_to_date(p_start_date)),'Y') >= trunc(fnd_date.canonical_to_date(p_start_date),'Y')
447: and exists (select '1' from pay_us_asg_reporting puar
448: where puar.tax_unit_id = info.organization_id
449: and puar.jurisdiction_code like cv_jurisdiction)
450: group by info.organization_id,hoi.name
451: order by count(*);