APPS.PSA_MF_GL_TRANSFER_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

	update psa_mf_trx_dist_all
           set posting_control_id = p_trx_rec.pst_ctrl_id
         where cust_trx_line_gl_dist_id in (select cust_trx_line_gl_dist_id
					      from ra_cust_trx_line_gl_dist
					     where customer_trx_id = p_trx_rec.customer_trx_id);

Line: 42

	update psa_mf_adj_dist_all
           set posting_control_id = p_adj_rec.pst_ctrl_id
         where adjustment_id = p_adj_rec.adjustment_id;

Line: 62

	update psa_mf_rct_dist_all
           set posting_control_id        = p_rct_rec.pst_ctrl_id
         where receivable_application_id = p_rct_rec.ra_receivable_application_id;

Line: 70

/* Function to Insert TRX additionalMFAR jes into GL Interface */
/******************************************************/
FUNCTION psa_mf_MFAR_trx_jes(p_trx_rec in PSA_MFAR_UTILS.trx_rec)
return varchar2
IS
BEGIN
RETURN 'TRUE';

Line: 80

/* Function to Insert ADJ additionalMFAR jes into GL Interface */
/******************************************************/
FUNCTION psa_mf_MFAR_adj_jes(p_adj_rec in PSA_MFAR_UTILS.adj_rec)
RETURN varchar2
IS
BEGIN
RETURN 'TRUE';

Line: 90

/* Function to Insert RCT additionalMFAR jes into GL Interface */
/*****************************************************/
FUNCTION psa_mf_MFAR_rct_jes(p_rct_rec in PSA_MFAR_UTILS.rct_rec)
RETURN varchar2
IS
BEGIN
  RETURN 'TRUE';