593:
594: cursor c_open_cc_lines is
595: select cdl1.rowid
596: from pa_expenditure_items_all ei,
597: pa_cc_dist_lines_all cdl1
598: where cdl1.expenditure_item_id = ei.expenditure_item_id
599: and ei.expenditure_item_date <= p_txn_to_date
600: and ei.project_id = p_project_id;
601:
600: and ei.project_id = p_project_id;
601:
602: cursor c_close_cc_lines is
603: select cdl1.rowid
604: from pa_cc_dist_lines_all cdl1
605: where cdl1.project_id = p_project_id;
606:
607: begin
608:
776: cdl.PROJECT_TP_EXCHANGE_RATE,
777: cdl.PROJECT_TRANSFER_PRICE,
778: cdl.PROJFUNC_TP_CURRENCY_CODE,
779: cdl.ACCT_EVENT_ID -- R12 change
780: from pa_cc_dist_lines_all cdl
781: where cdl.rowid = l_cc_dist_rowid_tab(exp_ind);
782:
783: l_NoOfRecordsIns := SQL%ROWCOUNT ;
784: end if;
837: l_MRC_NoOfRecordsDel := SQL%ROWCOUNT ;
838: End If;
839:
840: FORALL exp_ind In l_cc_dist_rowid_tab.FIRST .. l_cc_dist_rowid_tab.LAST
841: delete from pa_cc_dist_lines_all cdl
842: where cdl.rowid = l_cc_dist_rowid_tab(exp_ind);
843:
844: l_NoOfRecordsDel := SQL%ROWCOUNT ;
845: