APPS.RCI_OPEN_ISSUE_SUMM_PKG dependencies on ENG_CHANGE_SUBJECTS

Line 158: eng_change_subjects ecs,

154: ftd.ENT_QTR_ID, /**as entQuarterId,**/
155: ftd.ENT_PERIOD_ID, /**as entPeriodId,**/
156: to_number(to_char(agpv.end_date,'J')) /**as reportDateJulian**/
157: from eng_engineering_changes eec,
158: eng_change_subjects ecs,
159: AMW_FIN_PROC_CERT_RELAN afpcr,
160: amw_certification_b proc_cert,
161: amw_certification_b fin_cert,
162: amw_gl_periods_v agpv,

Line 197: from ENG_CHANGE_SUBJECTS where change_id = cur_rec.change_id

193: /*** the below is not needed, as certificationId is prepopulated above
194: begin
195: select pk1_value
196: into l_cert_id
197: from ENG_CHANGE_SUBJECTS where change_id = cur_rec.change_id
198: and entity_name = 'CERTIFICATION';
199: exception
200: when no_data_found then
201: l_cert_id := null;

Line 209: from ENG_CHANGE_SUBJECTS where change_id = cur_rec.change_id

205:
206: begin
207: select pk1_value
208: into l_org_id
209: from ENG_CHANGE_SUBJECTS where change_id = cur_rec.change_id
210: and entity_name = 'ORGANIZATION';
211: exception
212: when no_data_found then
213: l_org_id := null;

Line 221: from ENG_CHANGE_SUBJECTS where change_id = cur_rec.change_id

217:
218: begin
219: select pk1_value
220: into l_proc_id
221: from ENG_CHANGE_SUBJECTS where change_id = cur_rec.change_id
222: and entity_name = 'PROCESS';
223: exception
224: when no_data_found then
225: l_proc_id := null;