APPS.RCI_OPEN_REMED_SUMM_PKG dependencies on ENG_CHANGE_OBJ_RELATIONSHIPS

Line 1228: eng_engineering_changes eec1, eng_change_obj_relationships ecor

1224: v_period, v_qtr, v_year,
1225: to_number(to_char(v_end_date,'J')),/** 12.16.2005 npanandi: added report_date_julian **/
1226: G_USER_ID, G_USER_ID, SYSDATE, G_USER_ID, SYSDATE
1227: FROM
1228: eng_engineering_changes eec1, eng_change_obj_relationships ecor
1229: WHERE
1230: eec1.change_mgmt_type_code = 'AMW_REMEDIATION'
1231: AND ecor.relationship_code = 'RESOLVED_BY'
1232: AND eec1.change_id = ecor.object_to_id1;