438: UPDATE ap_checks c
439: SET treasury_pay_number = l_begin_doc,
440: treasury_pay_date = g_accounting_date,
441: last_update_date = SYSDATE,
442: last_updated_by = fnd_global.user_id,
443: last_update_login = fnd_global.login_id
444: WHERE c.check_id = l_check_tbl(l_row_num).check_id;
445:
446:
439: SET treasury_pay_number = l_begin_doc,
440: treasury_pay_date = g_accounting_date,
441: last_update_date = SYSDATE,
442: last_updated_by = fnd_global.user_id,
443: last_update_login = fnd_global.login_id
444: WHERE c.check_id = l_check_tbl(l_row_num).check_id;
445:
446:
447: INSERT INTO fv_voided_checks
461: ac.checkrun_name,
462: ac.check_id,
463: 'N',
464: SYSDATE,
465: fnd_global.user_id,
466: SYSDATE,
467: fnd_global.user_id,
468: fnd_global.login_id,
469: ac.org_id
463: 'N',
464: SYSDATE,
465: fnd_global.user_id,
466: SYSDATE,
467: fnd_global.user_id,
468: fnd_global.login_id,
469: ac.org_id
470: FROM ap_checks ac,
471: ap_payment_history aph
464: SYSDATE,
465: fnd_global.user_id,
466: SYSDATE,
467: fnd_global.user_id,
468: fnd_global.login_id,
469: ac.org_id
470: FROM ap_checks ac,
471: ap_payment_history aph
472: WHERE ac.check_id = l_check_tbl(l_row_num).check_id
1074: ac.checkrun_name,
1075: ac.check_id,
1076: 'U',
1077: SYSDATE,
1078: fnd_global.user_id,
1079: SYSDATE,
1080: fnd_global.user_id,
1081: fnd_global.login_id,
1082: ac.org_id
1076: 'U',
1077: SYSDATE,
1078: fnd_global.user_id,
1079: SYSDATE,
1080: fnd_global.user_id,
1081: fnd_global.login_id,
1082: ac.org_id
1083: FROM ap_checks_all ac,
1084: fv_treasury_confirmations_all fvtc
1077: SYSDATE,
1078: fnd_global.user_id,
1079: SYSDATE,
1080: fnd_global.user_id,
1081: fnd_global.login_id,
1082: ac.org_id
1083: FROM ap_checks_all ac,
1084: fv_treasury_confirmations_all fvtc
1085: , ap_payment_history_all aph