DBA Data[Home] [Help]

APPS.JA_CN_APAR_COMMON_PKG dependencies on HR_OPERATING_UNITS

Line 160: FROM hr_operating_units hro, xle_entity_profiles xfi

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
163: AND xfi.legal_entity_id = pn_legal_entity_id --parameter: pn_legal_entity_id
164: AND rctt.Org_Id = hro.ORGANIZATION_ID