DBA Data[Home] [Help]

APPS.FA_LEASE_PVT dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 250: ,AP_SYSTEM_PARAMETERS_ALL AP

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
253: AND PVS.ORG_ID IS NOT NULL
254: AND AP.ORG_ID = PVS.ORG_ID

Line 262: ,AP_SYSTEM_PARAMETERS_ALL AP

258: SELECT PVS.VENDOR_SITE_ID
259: ,SOB.CHART_OF_ACCOUNTS_ID COA_ID
260: ,PVS.ORG_ID LESSOR_SITE_ORG_ID
261: FROM GL_SETS_OF_BOOKS SOB
262: ,AP_SYSTEM_PARAMETERS_ALL AP
263: ,PO_VENDOR_SITES_ALL PVS
264: WHERE PVS.VENDOR_ID = P_VENDOR_ID
265: AND PVS.VENDOR_SITE_ID = P_VENDOR_SITE_ID
266: AND PVS.ORG_ID IS NULL

Line 319: ,AP_SYSTEM_PARAMETERS_ALL AP

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
322: AND PVS.ORG_ID IS NOT NULL
323: AND AP.ORG_ID = PVS.ORG_ID

Line 331: ,AP_SYSTEM_PARAMETERS_ALL AP

327: UNION
328: SELECT PVS.VENDOR_SITE_ID
329: ,SOB.CHART_OF_ACCOUNTS_ID COA_ID
330: FROM GL_SETS_OF_BOOKS SOB
331: ,AP_SYSTEM_PARAMETERS_ALL AP
332: ,PO_VENDOR_SITES_ALL PVS
333: WHERE PVS.VENDOR_ID = P_VENDOR_ID
334: AND PVS.VENDOR_SITE_CODE = P_VENDOR_SITE_CODE
335: AND PVS.ORG_ID IS NULL