DBA Data[Home] [Help]

APPS.PSA_MF_CREATE_DISTRIBUTIONS dependencies on PSA_TRX_TYPES_ALL

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 496: psa_trx_types_all psa,

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
500: AND trx.customer_trx_id = gd.customer_trx_id