DBA Data[Home] [Help]

APPS.FA_LEASE_PVT dependencies on GL_SETS_OF_BOOKS

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

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

Line 249: FROM GL_SETS_OF_BOOKS SOB

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

Line 263: FROM GL_SETS_OF_BOOKS SOB

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

Line 310: X_CHART_OF_ACCOUNTS_ID OUT NOCOPY GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE

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

Line 318: FROM GL_SETS_OF_BOOKS SOB

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

Line 332: FROM GL_SETS_OF_BOOKS SOB

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