APPS.PSA_MF_CREATE_DISTRIBUTIONS dependencies on RA_CUSTOMER_TRX

Line 38: FROM ra_customer_trx trx, psa_trx_types_all psa

34:
35: CURSOR a (cust_trx_id in number)
36: IS
37: SELECT trx.customer_trx_id
38: FROM ra_customer_trx trx, psa_trx_types_all psa
39: WHERE trx.customer_trx_id = nvl(cust_trx_id,trx.customer_trx_id)
40: AND trx.cust_trx_type_id = psa.psa_trx_type_id
41: AND set_of_books_id = p_set_of_books_id;
42:

Line 495: FROM ra_customer_trx trx,

491: IS
492:
493: CURSOR c_selected_trx IS
494: SELECT distinct trx.customer_trx_id document_id
495: FROM ra_customer_trx trx,
496: psa_trx_types_all psa,
497: ra_cust_trx_line_gl_dist gd
498: WHERE trx.cust_trx_type_id = psa.psa_trx_type_id
499: AND trx.set_of_books_id = p_set_of_books_id

Line 503: TYPE trx_id_type IS TABLE OF ra_customer_trx.customer_trx_id%TYPE;

499: AND trx.set_of_books_id = p_set_of_books_id
500: AND trx.customer_trx_id = gd.customer_trx_id
501: AND gd.gl_date between nvl(p_gl_date_from, gd.gl_date) and nvl(p_gl_date_to, gd.gl_date);
502:
503: TYPE trx_id_type IS TABLE OF ra_customer_trx.customer_trx_id%TYPE;
504: l_trx_id_tab trx_id_type;
505:
506: BEGIN
507: