DBA Data[Home] [Help]

APPS.PA_EXCEPTION_ENGINE_PKG dependencies on PA_PERF_COMMENTS

Line 1213: DELETE from pa_perf_comments

1209: pa_debug.write_file('LOG', 'Purging Project : ' || p_project_list(i));
1210: END IF;
1211:
1212: /*** clean up the comments transaction table based on project_id and purge_date ***/
1213: DELETE from pa_perf_comments
1214: WHERE perf_txn_id in (SELECT perf_txn_id
1215: FROM pa_perf_transactions
1216: WHERE perf_txn_obj_type = 'PA_PROJECTS'
1217: AND perf_txn_obj_id = p_project_list(i)