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_MED_EFILE_CONC_PKG dependencies on FND_DATE

Line 105: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =

101: ,count(*) cnt
102: from
103: per_assignment_extra_info where assignment_id = p_assignment_id
104: and information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
105: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
106: trunc(p_yea_date, 'yyyy')
107: group by
108: aei_information8
109: ,aei_information7

Line 128: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =

124: ,count(*) cnt
125: from
126: per_assignment_extra_info where assignment_id = p_assignment_id
127: and information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
128: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
129: trunc(p_yea_date, 'yyyy')
130: group by
131: aei_information8
132: ,aei_information9

Line 151: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =

147: ,count(*) cnt
148: from
149: per_assignment_extra_info where assignment_id = p_assignment_id
150: and information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
151: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
152: trunc(p_yea_date, 'yyyy')
153: and ( aei_information13 <> '1' or (aei_information5 is not null and aei_information6 is not null)) -- Bug 8280944
154: group by
155: aei_information5

Line 220: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =

216: ,count(*) cnt
217: from
218: per_assignment_extra_info where assignment_id = p_assignment_id
219: and information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
220: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
221: trunc(p_yea_date, 'yyyy')
222: and ( aei_information13 <> '1' or (aei_information5 is not null and aei_information6 is not null)) -- Bug 8280944
223: group by
224: aei_information5

Line 274: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =

270: ,count(*) cnt
271: from
272: per_assignment_extra_info where assignment_id = p_assignment_id
273: and information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
274: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
275: trunc(p_yea_date, 'yyyy')
276: group by
277: aei_information8
278: ,aei_information7

Line 294: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =

290: ,count(*) cnt
291: from
292: per_assignment_extra_info where assignment_id = p_assignment_id
293: and information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
294: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
295: trunc(p_yea_date, 'yyyy')
296: group by
297: aei_information8
298: ,aei_information9