350: BEGIN
351:
352: SELECT COUNT(*)
353: INTO cup_counter
354: FROM ap_invoice_payments_all
355: WHERE accounting_date BETWEEN p_start_date AND p_end_date
356: AND posted_flag IN ('N','S') --Bug3476167
357: AND org_id = co_org_id
358: AND rownum = 1;
726:
727: /*srw.message('12', 'Updating invoice payments....');*/null;
728:
729:
730: UPDATE ap_invoice_payments_all aip
731: SET accounting_date = c_sweep_to_date,
732: period_name = p_to_period,
733: last_update_date = sysdate,
734: last_updated_by = 5
847:
848: /*srw.message('12', 'Updating invoice payments....');*/null;
849:
850:
851: UPDATE ap_invoice_payments_all aip
852: SET accounting_date = c_sweep_to_date,
853: period_name = p_to_period,
854: last_update_date = sysdate,
855: last_updated_by = 5
1064: AND rownum = 1;
1065:
1066: SELECT COUNT(*)
1067: INTO cup_counter
1068: FROM ap_invoice_payments_all
1069: WHERE accounting_date BETWEEN p_start_date AND p_end_date
1070: AND posted_flag IN ('N','S') AND org_id = co_org_id
1071: AND rownum = 1;
1072:
1259: AND rownum = 1;
1260:
1261: SELECT COUNT(*)
1262: INTO cup_counter
1263: FROM ap_invoice_payments_all
1264: WHERE accounting_date BETWEEN p_start_date AND p_end_date
1265: AND posted_flag IN ('N','S') --Bug 3476167
1266: AND set_of_books_id = p_set_of_books_id
1267: AND rownum = 1;