eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KR_YEA_DON_EFILE_CONC_PKG dependencies on FND_DATE

Line 154: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy') = pay_kr_yea_don_efile_pkg.g_target_year;

150: between pp.effective_start_date and pp.effective_end_date
151: and pae.assignment_id = pa.assignment_id
152: and pae.information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
153: and pae.aei_information2 <= pay_kr_yea_don_efile_pkg.g_target_year
154: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy') = pay_kr_yea_don_efile_pkg.g_target_year;
155:
156: cursor csr_count_d is
157: select
158: count(*)

Line 198: and fnd_date.canonical_to_date(aei.aei_information1)

194: --
195: and paa.tax_unit_id = bp.organization_id
196: and paa.action_status = 'C'
197: and pa.assignment_id = paa.assignment_id
198: and fnd_date.canonical_to_date(aei.aei_information1)
199: between pa.effective_start_date and pa.effective_end_date
200: and fnd_date.canonical_to_date(aei.aei_information1)
201: between pp.effective_start_date and pp.effective_end_date
202: and pa.person_id = resreg.person_id

Line 200: and fnd_date.canonical_to_date(aei.aei_information1)

196: and paa.action_status = 'C'
197: and pa.assignment_id = paa.assignment_id
198: and fnd_date.canonical_to_date(aei.aei_information1)
199: between pa.effective_start_date and pa.effective_end_date
200: and fnd_date.canonical_to_date(aei.aei_information1)
201: between pp.effective_start_date and pp.effective_end_date
202: and pa.person_id = resreg.person_id
203: and fnd_date.canonical_to_date(aei.aei_information1) BETWEEN resreg.cont_effective_start_date
204: AND resreg.cont_effective_end_date

Line 203: and fnd_date.canonical_to_date(aei.aei_information1) BETWEEN resreg.cont_effective_start_date

199: between pa.effective_start_date and pa.effective_end_date
200: and fnd_date.canonical_to_date(aei.aei_information1)
201: between pp.effective_start_date and pp.effective_end_date
202: and pa.person_id = resreg.person_id
203: and fnd_date.canonical_to_date(aei.aei_information1) BETWEEN resreg.cont_effective_start_date
204: AND resreg.cont_effective_end_date
205: and fnd_date.canonical_to_date(aei.aei_information1) BETWEEN resreg.person_effective_start_date
206: AND resreg.person_effective_end_date
207: and fnd_date.canonical_to_date(aei.aei_information1) BETWEEN nvl(resreg.relationship_start_date, fnd_date.canonical_to_date(aei.aei_information1))

Line 205: and fnd_date.canonical_to_date(aei.aei_information1) BETWEEN resreg.person_effective_start_date

201: between pp.effective_start_date and pp.effective_end_date
202: and pa.person_id = resreg.person_id
203: and fnd_date.canonical_to_date(aei.aei_information1) BETWEEN resreg.cont_effective_start_date
204: AND resreg.cont_effective_end_date
205: and fnd_date.canonical_to_date(aei.aei_information1) BETWEEN resreg.person_effective_start_date
206: AND resreg.person_effective_end_date
207: and fnd_date.canonical_to_date(aei.aei_information1) BETWEEN nvl(resreg.relationship_start_date, fnd_date.canonical_to_date(aei.aei_information1))
208: AND decode(resreg.relationship_end_date,NULL,fnd_date.canonical_to_date(aei.aei_information1),
209: decode(resreg.relationship_end_reason,'D',

Line 207: and fnd_date.canonical_to_date(aei.aei_information1) BETWEEN nvl(resreg.relationship_start_date, fnd_date.canonical_to_date(aei.aei_information1))

203: and fnd_date.canonical_to_date(aei.aei_information1) BETWEEN resreg.cont_effective_start_date
204: AND resreg.cont_effective_end_date
205: and fnd_date.canonical_to_date(aei.aei_information1) BETWEEN resreg.person_effective_start_date
206: AND resreg.person_effective_end_date
207: and fnd_date.canonical_to_date(aei.aei_information1) BETWEEN nvl(resreg.relationship_start_date, fnd_date.canonical_to_date(aei.aei_information1))
208: AND decode(resreg.relationship_end_date,NULL,fnd_date.canonical_to_date(aei.aei_information1),
209: decode(resreg.relationship_end_reason,'D',
210: TRUNC(add_months(resreg.relationship_end_date,12),'YYYY') -1,resreg.relationship_end_date))
211: and resreg.cont_person_id = pp.person_id

Line 208: AND decode(resreg.relationship_end_date,NULL,fnd_date.canonical_to_date(aei.aei_information1),

204: AND resreg.cont_effective_end_date
205: and fnd_date.canonical_to_date(aei.aei_information1) BETWEEN resreg.person_effective_start_date
206: AND resreg.person_effective_end_date
207: and fnd_date.canonical_to_date(aei.aei_information1) BETWEEN nvl(resreg.relationship_start_date, fnd_date.canonical_to_date(aei.aei_information1))
208: AND decode(resreg.relationship_end_date,NULL,fnd_date.canonical_to_date(aei.aei_information1),
209: decode(resreg.relationship_end_reason,'D',
210: TRUNC(add_months(resreg.relationship_end_date,12),'YYYY') -1,resreg.relationship_end_date))
211: and resreg.cont_person_id = pp.person_id
212: and pp.national_identifier = aei.aei_information13

Line 215: and to_char(fnd_date.canonical_to_date(aei.aei_information1),'yyyy') = pay_kr_yea_don_efile_pkg.g_target_year

211: and resreg.cont_person_id = pp.person_id
212: and pp.national_identifier = aei.aei_information13
213: and aei.assignment_id = pa.assignment_id
214: and aei.information_type = 'KR_YEA_DETAIL_DONATION_INFO'
215: and to_char(fnd_date.canonical_to_date(aei.aei_information1),'yyyy') = pay_kr_yea_don_efile_pkg.g_target_year
216: group by aei.assignment_id,
217: aei.aei_information13,
218: pp.last_name || pp.first_name,
219: aei.aei_information12,