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: group by

Line 217: per_assignment_extra_info where assignment_id = p_assignment_id

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

Line 270: per_assignment_extra_info where assignment_id = p_assignment_id

266: aei_information8 res_reg_no
267: ,aei_information7 relationship
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

Line 290: per_assignment_extra_info where assignment_id = p_assignment_id

286: aei_information8 res_reg_no
287: ,aei_information9 aged_disabled
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