49: where hoi.organization_id = info.organization_id
50: and info.org_information_context = 'CLASS'
51: and info.org_information1 = 'HR_LEGAL'
52: and hoi.business_group_id = p_business_group
53: and trunc(nvl(date_to,fnd_date.canonical_to_date(p_start_date)),'Y') >= trunc(fnd_date.canonical_to_date(p_start_date),'Y')
54: group by info.organization_id,hoi.name
55: order by count(*);
56:
57: cursor gre_sizes_gre_state is
77: where hoi.organization_id = info.organization_id
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
175: and pbd.database_item_suffix = '_GRE_JD_RUN'
176: and pdb.defined_balance_id = pbv.defined_balance_id
177: and pbv.business_group_id = p_business_group
178: and nvl(pbv.balance_load_date,
179: fnd_date.canonical_to_date(p_start_date))
180: <= fnd_date.canonical_to_date(p_start_date);
181:
182:
183: if l_valid_status = 'V' then
176: and pdb.defined_balance_id = pbv.defined_balance_id
177: and pbv.business_group_id = p_business_group
178: and nvl(pbv.balance_load_date,
179: fnd_date.canonical_to_date(p_start_date))
180: <= fnd_date.canonical_to_date(p_start_date);
181:
182:
183: if l_valid_status = 'V' then
184: --call the new report
412: where hoi.organization_id = info.organization_id
413: and info.org_information_context = 'CLASS'
414: and info.org_information1 = 'HR_LEGAL'
415: and hoi.business_group_id = p_business_group
416: and trunc(nvl(date_to,fnd_date.canonical_to_date(p_start_date)),'Y') >= trunc(fnd_date.canonical_to_date(p_start_date),'Y')
417: group by info.organization_id,hoi.name
418: order by count(*);
419:
420: cursor gre_sizes_gre_juri(cv_jurisdiction varchar2) is
440: where hoi.organization_id = info.organization_id
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