PA Generate Cross Charge Accounting Events

SELECT   plk2.meaning gl_category,
                 plk1.meaning rejection_reason,
                 pdls.code_combination_id account_id,  
                 pdls.pa_date pa_date, 
                 pdls.gl_date gl_date, 
                 pdls.number_of_lines dist_count, 
                 pdls.denom_tp_currency_code d_cur, 
                 pdls.entered_dr  entered_dr, 
                 pdls.entered_cr  entered_cr, 
                 pdls.ACCT_CURRENCY_CODE a_cur, 
                 pdls.accounted_dr  accounted_dr, 
                 pdls.accounted_cr  accounted_cr, 
	PA_PACCGLTR_XMLP_PKG.cf_account_idformula(pdls.code_combination_id) CF_account_id
FROM
             pa_cc_dist_lines_summarize_v pdls,  
             pa_lookups  plk1,
             pa_lookups plk2
WHERE 
              pdls.transfer_rejection_code=plk1.lookup_code
    AND  plk1.lookup_type='TRANSFER REJECTION CODE'
    AND  pdls.transfer_status_code='R'
    AND  pdls.line_type=plk2.lookup_code
    AND  plk2.lookup_type='CC_DIST_LINE_TYPE'
    AND  pdls.request_id=fnd_global.conc_request_id
    AND  pdls.org_id = pa_moac_utils.get_current_org_id
ORDER BY  account_id,  pa_date, gl_date