APPS.PSA_MFAR_TRANSACTIONS dependencies on PSA_MF_TRX_DIST_ALL

Line 49: psa_mf_trx_dist_all B

45: A.code_combination_id rev_ccid,
46: B.mf_receivables_ccid mf_ccid,
47: B.prev_mf_receivables_ccid prev_mf_ccid
48: FROM ra_cust_trx_line_gl_dist_all A,
49: psa_mf_trx_dist_all B
50: WHERE A.cust_trx_line_gl_dist_id = B.cust_trx_line_gl_dist_id
51: AND A.customer_trx_id = g_cust_trx_id;
52: /* bug 2737029
53: AND EXISTS

Line 304: FROM psa_mf_trx_dist_all psa

300: FROM ra_cust_trx_line_gl_dist_all y
301: WHERE customer_trx_id = g_cust_trx_id
302: AND account_class <> 'REC'
303: AND NOT EXISTS ( SELECT 'x'
304: FROM psa_mf_trx_dist_all psa
305: WHERE psa.cust_trx_line_gl_dist_id = y.cust_trx_line_gl_dist_id
306: );
307: /* bug 2737029
308: AND EXISTS

Line 332: Delete FROM psa_mf_trx_dist_all

328: --
329: -- Delete existing records if any
330: --
331:
332: Delete FROM psa_mf_trx_dist_all
333: WHERE cust_trx_line_gl_dist_id In
334: (SELECT cust_trx_line_gl_dist_id
335: FROM ra_cust_trx_line_gl_dist_all
336: WHERE customer_trx_id = g_cust_trx_id)

Line 341: ' Generate_trx_dist --> delete from psa_mf_trx_dist_all -->'

337: AND posting_control_id IS NULL;
338:
339: -- ========================= FND LOG ===========================
340: psa_utils.debug_other_string(g_state_level,l_full_path,
341: ' Generate_trx_dist --> delete from psa_mf_trx_dist_all -->'
342: || SQL%ROWCOUNT);
343: -- ========================= FND LOG ===========================
344:
345: --

Line 394: -- Insert into psa_mf_trx_dist_all table

390: RAISE FLEX_BUILD_ERROR;
391: END IF;
392:
393: --
394: -- Insert into psa_mf_trx_dist_all table
395: --
396:
397: PSA_MFAR_TRANSACTION_COVER_PKG.INSERT_ROW
398: (X_ROWID => l_rowid,

Line 498: psa_mf_trx_dist_all B

494:
495: CURSOR c_mf_trx_count IS
496: SELECT count(B.cust_trx_line_gl_dist_id) mf_dist_count
497: FROM ra_cust_trx_line_gl_dist_all A,
498: psa_mf_trx_dist_all B
499: WHERE A.cust_trx_line_gl_dist_id = B.cust_trx_line_gl_dist_id
500: AND A.customer_trx_id = g_cust_trx_id;
501:
502: l_core_count NUMBER;

Line 528: DELETE FROM psa_mf_trx_dist_all

524: -- ========================= FND LOG ===========================
525:
526: -- Bug 3671841, Delete statement commented and now placed in PSAMFG2B.pls
527: /*
528: DELETE FROM psa_mf_trx_dist_all
529: WHERE cust_trx_line_gl_dist_id Not In
530: ( SELECT cust_trx_line_gl_dist_id FROM ra_cust_trx_line_gl_dist_all );
531: */
532:

Line 535: ' Transaction_modified --> delete psa_mf_trx_dist_all --> '

531: */
532:
533: -- ========================= FND LOG ===========================
534: psa_utils.debug_other_string(g_state_level,l_full_path,
535: ' Transaction_modified --> delete psa_mf_trx_dist_all --> '
536: || SQL%ROWCOUNT);
537: -- ========================= FND LOG ===========================
538:
539: IF l_core_count <> l_mf_dist_count THEN