APPS.RCI_OPEN_REMED_SUMM_PKG dependencies on ENG_ENGINEERING_CHANGES

Line 999: eng_engineering_changes eec1

995: v_period, v_qtr, v_year,
996: to_number(to_char(v_end_date,'J')),/** 12.16.2005 npanandi: added report_date_julian **/
997: G_USER_ID, G_USER_ID, SYSDATE, G_USER_ID, SYSDATE
998: FROM
999: eng_engineering_changes eec1
1000: WHERE
1001: eec1.change_mgmt_type_code = 'AMW_PROJ_FINDING';
1002: END LOOP;--inner loop
1003: END LOOP;--outer loop

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;