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 385: from pay_us_asg_reporting puar,

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

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

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

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

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