APPS.PSA_MFAR_TRANSACTIONS dependencies on RA_CUSTOMER_TRX_ALL

Line 4: g_cust_trx_id ra_customer_trx_all.customer_trx_id%type;

1: PACKAGE BODY PSA_MFAR_TRANSACTIONS AS
2: /* $Header: PSAMFTXB.pls 120.15 2006/09/13 14:00:54 agovil ship $ */
3:
4: g_cust_trx_id ra_customer_trx_all.customer_trx_id%type;
5: g_set_of_books_id ra_customer_trx_all.set_of_books_id%type;
6: g_receivables_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%type;
7: g_run_id NUMBER;
8: --===========================FND_LOG.START=====================================

Line 5: g_set_of_books_id ra_customer_trx_all.set_of_books_id%type;

1: PACKAGE BODY PSA_MFAR_TRANSACTIONS AS
2: /* $Header: PSAMFTXB.pls 120.15 2006/09/13 14:00:54 agovil ship $ */
3:
4: g_cust_trx_id ra_customer_trx_all.customer_trx_id%type;
5: g_set_of_books_id ra_customer_trx_all.set_of_books_id%type;
6: g_receivables_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%type;
7: g_run_id NUMBER;
8: --===========================FND_LOG.START=====================================
9: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 62: FROM ra_customer_trx_all A,

58:
59: CURSOR c_trx_type
60: IS
61: SELECT A.rowid row_id
62: FROM ra_customer_trx_all A,
63: ra_cust_trx_types_all B
64: WHERE A.customer_trx_id = g_cust_trx_id
65: AND A.cust_trx_type_id = B.cust_trx_type_id
66: And (B.type = 'INV' OR B.type = 'DM')

Line 445: FROM ra_customer_trx_all

441:
442: CURSOR c_trx_complete
443: IS
444: SELECT complete_flag
445: FROM ra_customer_trx_all
446: WHERE customer_trx_id = g_cust_trx_id;
447:
448: l_trx_complete_rec c_trx_complete%rowtype;
449: -- ========================= FND LOG ===========================