DBA Data[Home] [Help]

APPS.FA_LEASE_PVT dependencies on GL_SETS_OF_BOOKS

Line 238: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,

234: -------------------------------------------
235: FUNCTION CHECK_LESSOR_SITE_ID (
236: P_VENDOR_SITE_ID IN PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
237: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
238: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
239: X_LESSOR_SITE_ORG_ID OUT NOCOPY NUMBER,
240: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
241:
242: CURSOR C_LESSOR_SITE_ID IS

Line 247: FROM GL_SETS_OF_BOOKS SOB

243: SELECT
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

Line 261: FROM GL_SETS_OF_BOOKS SOB

257: UNION
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

Line 309: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,

305: P_VENDOR_SITE_CODE IN PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE%TYPE,
306: P_VENDOR_ID IN PO_VENDOR_SITES_ALL.VENDOR_ID%TYPE,
307: P_VENDOR_SITE_ORG_ID IN PO_VENDOR_SITES_ALL.ORG_ID%TYPE,
308: X_VENDOR_SITE_ID OUT NOCOPY PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%TYPE,
309: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE,
310: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
311:
312: CURSOR C_LESSOR_SITE_CODE IS
313: SELECT

Line 316: FROM GL_SETS_OF_BOOKS SOB

312: CURSOR C_LESSOR_SITE_CODE IS
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

Line 330: FROM GL_SETS_OF_BOOKS SOB

326: AND PVS.ORG_ID = P_VENDOR_SITE_ORG_ID
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