APPS.PAY_US_TRR_ENGINE_PKG dependencies on FND_DATE

Line 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')

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

Line 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')

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

Line 179: fnd_date.canonical_to_date(p_start_date))

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

Line 180: <= fnd_date.canonical_to_date(p_start_date);

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

Line 418: and trunc(nvl(date_to,fnd_date.canonical_to_date(p_start_date)),'Y') >= trunc(fnd_date.canonical_to_date(p_start_date),'Y')

414: where hoi.organization_id = info.organization_id
415: and info.org_information_context = 'CLASS'
416: and info.org_information1 = 'HR_LEGAL'
417: and hoi.business_group_id = p_business_group
418: and trunc(nvl(date_to,fnd_date.canonical_to_date(p_start_date)),'Y') >= trunc(fnd_date.canonical_to_date(p_start_date),'Y')
419: group by info.organization_id,hoi.name
420: order by count(*);
421:
422: cursor gre_sizes_gre_juri(cv_jurisdiction varchar2) is

Line 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')

442: where hoi.organization_id = info.organization_id
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