DBA Data[Home] [Help]

APPS.FA_LEASE_PVT dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 252: ,AP_SYSTEM_PARAMETERS_ALL AP

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

Line 264: ,AP_SYSTEM_PARAMETERS_ALL AP

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

Line 321: ,AP_SYSTEM_PARAMETERS_ALL AP

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

Line 333: ,AP_SYSTEM_PARAMETERS_ALL AP

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