DBA Data[Home] [Help]

APPS.FA_LEASE_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 250: ,HR_ALL_ORGANIZATION_UNITS HAO

246: PVS.VENDOR_SITE_ID
247: ,SOB.CHART_OF_ACCOUNTS_ID COA_ID
248: ,PVS.ORG_ID LESSOR_SITE_ORG_ID
249: FROM GL_SETS_OF_BOOKS SOB
250: ,HR_ALL_ORGANIZATION_UNITS HAO
251: ,PO_VENDOR_SITES_ALL PVS
252: ,AP_SYSTEM_PARAMETERS_ALL AP
253: WHERE PVS.VENDOR_ID = P_VENDOR_ID
254: AND PVS.VENDOR_SITE_ID = P_VENDOR_SITE_ID

Line 319: ,HR_ALL_ORGANIZATION_UNITS HAO

315: SELECT
316: PVS.VENDOR_SITE_ID
317: ,SOB.CHART_OF_ACCOUNTS_ID COA_ID
318: FROM GL_SETS_OF_BOOKS SOB
319: ,HR_ALL_ORGANIZATION_UNITS HAO
320: ,PO_VENDOR_SITES_ALL PVS
321: ,AP_SYSTEM_PARAMETERS_ALL AP
322: WHERE PVS.VENDOR_ID = P_VENDOR_ID
323: AND PVS.VENDOR_SITE_CODE = P_VENDOR_SITE_CODE