APPS.OKL_SPLIT_ASSET_COMP_PVT dependencies on OKL_TXD_ASSETS_V

Line 45: FROM okl_txd_assets_v a

41: CURSOR c(p_tal_id NUMBER)
42: IS
43: SELECT a.id,
44: a.SPLIT_PERCENT
45: FROM okl_txd_assets_v a
46: WHERE TAL_ID = p_tal_id
47: ;
48:
49: CURSOR c_org(p_tal_id NUMBER)

Line 416: FROM okl_txd_assets_v

412:
413: CURSOR c(p_tal_id NUMBER)
414: IS
415: SELECT NVL(SUM(SPLIT_PERCENT),0)
416: FROM okl_txd_assets_v
417: WHERE TAL_ID = p_tal_id
418: ;
419:
420: BEGIN

Line 467: FROM okl_txd_assets_v

463: --cursor to check duplicate within same transaction
464: CURSOR c(p_tal_id NUMBER)
465: IS
466: SELECT asset_number
467: FROM okl_txd_assets_v
468: WHERE TAL_ID = p_tal_id
469: GROUP BY asset_number
470: HAVING COUNT(1) > 1
471: ;

Line 476: FROM okl_txd_assets_v

472: --bug #2465479 begin
473: --cursor to fetch asset number
474: CURSOR asset_cur(p_asd_id IN NUMBER) IS
475: SELECT asset_number
476: FROM okl_txd_assets_v
477: WHERE id = p_asd_id;
478:
479: --cursor to check duplicate in FA
480: CURSOR asset_chk_curs1 (p_asset_number IN VARCHAR2) IS

Line 633: FROM okl_txd_assets_v

629:
630: CURSOR c(p_tal_id NUMBER)
631: IS
632: SELECT inventory_item_id
633: FROM okl_txd_assets_v
634: WHERE TAL_ID = p_tal_id
635: GROUP BY inventory_item_id
636: HAVING COUNT(1) > 1
637: ;

Line 1196: FROM okl_txd_assets_v

1192:
1193: CURSOR c(p_tal_id NUMBER)
1194: IS
1195: SELECT NVL(SUM(SPLIT_PERCENT),0)
1196: FROM okl_txd_assets_v
1197: WHERE TAL_ID = p_tal_id
1198: ;
1199:
1200: BEGIN