DBA Data[Home] [Help]

APPS.FA_LEASE_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 248: ,HR_ALL_ORGANIZATION_UNITS HAO

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

Line 317: ,HR_ALL_ORGANIZATION_UNITS HAO

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