DBA Data[Home] [Help]

APPS.PSA_MF_UPD_PST_CTRL_PKG dependencies on PSA_MF_TRX_REC_BUF

Line 22: from psa_mf_trx_rec_buf

18: set gl_posted_date = l_gl_posted_date,
19: posting_control_id= p_posting_control_id,
20: last_update_date = sysdate
21: where customer_trx_id in (select customer_trx_id
22: from psa_mf_trx_rec_buf
23: where pst_ctrl_id = p_posting_control_id);
24:
25: update ar_receivable_applications
26: set gl_posted_date = l_gl_posted_date,

Line 42: delete from psa_mf_trx_rec_buf

38: from psa_mf_adj_rec_buf
39: where pst_ctrl_id = p_posting_control_id);
40:
41:
42: delete from psa_mf_trx_rec_buf
43: where last_update_date + 2 < sysdate;
44:
45: delete from psa_mf_rct_rec_buf
46: where last_update_date + 2 < sysdate;