DBA Data[Home] [Help]

APPS.PSA_MF_UPD_PST_CTRL_PKG dependencies on PSA_MF_ADJ_REC_BUF

Line 38: from psa_mf_adj_rec_buf

34: set gl_posted_date = l_gl_posted_date,
35: posting_control_id= p_posting_control_id,
36: last_update_date = sysdate
37: where adjustment_id in (select adjustment_id
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

Line 48: delete from psa_mf_adj_rec_buf

44:
45: delete from psa_mf_rct_rec_buf
46: where last_update_date + 2 < sysdate;
47:
48: delete from psa_mf_adj_rec_buf
49: where last_update_date + 2 < sysdate;
50:
51: commit;
52: end update_posting_control;