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: group by
154: aei_information5
155: ,aei_information6

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

215: ,count(*) cnt
216: from
217: per_assignment_extra_info where assignment_id = p_assignment_id
218: and information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
219: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
220: trunc(p_yea_date, 'yyyy')
221: group by
222: aei_information5
223: ,aei_information6

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

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

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

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