DBA Data[Home] [Help]

APPS.PSA_XFR_TO_GL_PKG dependencies on PSA_MF_ADJ_DIST_ALL

Line 2556: psa_mf_adj_dist_all psa_adj_dist,

2552: '2', 'ADJ_ADJ',
2553: '3', 'ADJ_FINCHRG') ref29,
2554: 'PSA_ADJ_DIST' ref30
2555: FROM ar_adjustments adj,
2556: psa_mf_adj_dist_all psa_adj_dist,
2557: psa_mf_trx_dist_all psa_trx_dist,
2558: ra_customer_trx ct,
2559: ra_cust_trx_line_gl_dist ctlgd,
2560: ra_cust_trx_types ctt,

Line 2762: UPDATE psa_mf_adj_dist_all pada

2758: END LOOP;
2759:
2760: END LOOP;
2761:
2762: UPDATE psa_mf_adj_dist_all pada
2763: SET pada.posting_control_id = l_pst_ctrl_id
2764: WHERE pada.adjustment_id IN
2765: (SELECT adjustment_id FROM ar_adjustments aa
2766: WHERE aa.posting_control_id = l_pst_ctrl_id);

Line 2771: ' --> (PSA_MF_ADJ_DIST_ALL) Posting control id updated for '

2767:
2768: IF (SQL%FOUND) THEN
2769: -- ========================= FND LOG ===========================
2770: psa_utils.debug_other_string(g_state_level,l_full_path,
2771: ' --> (PSA_MF_ADJ_DIST_ALL) Posting control id updated for '
2772: || (SQL%ROWCOUNT));
2773: -- ========================= FND LOG ===========================
2774: END IF;
2775: