DBA Data[Home] [Help]

APPS.JA_CN_APAR_COMMON_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 158: FROM Ra_Cust_Trx_Types_All rctt

154: --Transanction type for document type 'Receivable'
155: SELECT TO_CHAR(rctt.cust_trx_type_id) Tran_Type_Num
156: , rctt.NAME Tran_Type_Name
157: , 'RECEIVABLES' Source
158: FROM Ra_Cust_Trx_Types_All rctt
159: WHERE EXISTS (SELECT hro.ORGANIZATION_ID
160: FROM hr_operating_units hro, xle_entity_profiles xfi
161: WHERE xfi.legal_entity_id = hro.default_legal_context_id
162: AND hro.set_of_books_id = pn_ledger_id --parameter: pn_ledger_id