[Home] [Help]
2664: FOR k IN lt_task_id.FIRST..lt_task_id.LAST LOOP
2665:
2666: IF lt_process_task_flag(k) = 'Y' THEN
2667:
2668: INSERT INTO pa_cint_source_details
2669: (alloc_txn_id
2670: ,run_period_end_date
2671: ,project_id
2672: ,expenditure_item_id
3034:
3035: -- Delete rows in specified increments until no rows remain to be deleted
3036: LOOP
3037: BEGIN
3038: DELETE FROM pa_cint_source_details pcsd
3039: WHERE pcsd.run_period_end_date <= ld_period_end_date
3040: AND EXISTS
3041: (SELECT pp.project_id
3042: FROM pa_projects pp