DBA Data[Home] [Help]

APPS.OKL_TAL_PVT dependencies on FA_ASSET_KEYWORDS

Line 1334: -- in FA_ASSET_KEYWORDS

1330: -- Procedure Name : Validate_asset_key
1331: -- Description : validate asset key ccid
1332: --
1333: -- Business Rules : Asset_Key_Id should exist as a valid code_combination_id
1334: -- in FA_ASSET_KEYWORDS
1335: -- Parameters : OUT Return Status, IN Rec Info
1336: -- Version : 1.0
1337: -- End of Commnets
1338:

Line 1347: from FA_ASSET_KEYWORDS fak

1343:
1344: --cursor to check asset key ccid
1345: cursor l_fak_csr(p_asset_key_id in number) is
1346: select 'Y'
1347: from FA_ASSET_KEYWORDS fak
1348: where fak.CODE_COMBINATION_ID = p_asset_key_id
1349: and fak.enabled_flag = 'Y';
1350: --and trunc(sysdate) between trunc(nvl(start_date_active,sysdate))
1351: --and trunc(nvl(end_date_active,sysdate));