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 PER_ASSIGNMENT_EXTRA_INFO

Line 103: per_assignment_extra_info where assignment_id = p_assignment_id

99: aei_information8 res_reg_no
100: ,aei_information7 relationship
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

Line 126: per_assignment_extra_info where assignment_id = p_assignment_id

122: aei_information8 res_reg_no
123: ,aei_information9 aged_disabled
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

Line 149: per_assignment_extra_info where assignment_id = p_assignment_id

145: aei_information5 med_ser_prov_reg_no
146: ,aei_information6 med_ser_prov_name
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

Line 218: per_assignment_extra_info where assignment_id = p_assignment_id

214: aei_information5 med_ser_prov_reg_no
215: ,aei_information6 med_ser_prov_name
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

Line 272: per_assignment_extra_info where assignment_id = p_assignment_id

268: aei_information8 res_reg_no
269: ,aei_information7 relationship
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

Line 292: per_assignment_extra_info where assignment_id = p_assignment_id

288: aei_information8 res_reg_no
289: ,aei_information9 aged_disabled
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