439: UPDATE ap_checks c
440: SET treasury_pay_number = l_begin_doc,
441: treasury_pay_date = g_accounting_date,
442: last_update_date = SYSDATE,
443: last_updated_by = fnd_global.user_id,
444: last_update_login = fnd_global.login_id
445: WHERE c.check_id = l_check_tbl(l_row_num).check_id;
446:
447: l_row_num := l_row_num+1;
440: SET treasury_pay_number = l_begin_doc,
441: treasury_pay_date = g_accounting_date,
442: last_update_date = SYSDATE,
443: last_updated_by = fnd_global.user_id,
444: last_update_login = fnd_global.login_id
445: WHERE c.check_id = l_check_tbl(l_row_num).check_id;
446:
447: l_row_num := l_row_num+1;
448: l_begin_doc := l_begin_doc +1;
518: ac.checkrun_name,
519: ac.check_id,
520: 'U',
521: SYSDATE,
522: fnd_global.user_id,
523: SYSDATE,
524: fnd_global.user_id,
525: fnd_global.login_id,
526: ac.org_id,
520: 'U',
521: SYSDATE,
522: fnd_global.user_id,
523: SYSDATE,
524: fnd_global.user_id,
525: fnd_global.login_id,
526: ac.org_id,
527: g_payment_instr_id
528: FROM ap_checks_all ac,
521: SYSDATE,
522: fnd_global.user_id,
523: SYSDATE,
524: fnd_global.user_id,
525: fnd_global.login_id,
526: ac.org_id,
527: g_payment_instr_id
528: FROM ap_checks_all ac,
529: fv_treasury_confirmations_all fvc
1018: ac.checkrun_name,
1019: ac.check_id,
1020: 'U',
1021: SYSDATE,
1022: fnd_global.user_id,
1023: SYSDATE,
1024: fnd_global.user_id,
1025: fnd_global.login_id,
1026: ac.org_id
1020: 'U',
1021: SYSDATE,
1022: fnd_global.user_id,
1023: SYSDATE,
1024: fnd_global.user_id,
1025: fnd_global.login_id,
1026: ac.org_id
1027: FROM ap_checks_all ac,
1028: fv_treasury_confirmations_all fvtc
1021: SYSDATE,
1022: fnd_global.user_id,
1023: SYSDATE,
1024: fnd_global.user_id,
1025: fnd_global.login_id,
1026: ac.org_id
1027: FROM ap_checks_all ac,
1028: fv_treasury_confirmations_all fvtc
1029: WHERE ac.org_id = g_org_id