APPS.OKL_ACCRUAL_DEPRN_ADJ_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

	SELECT period_set_name, accounted_period_type
	FROM GL_LEDGERS_PUBLIC_V
	WHERE ledger_id = p_sob_id;

Line: 19

    SELECT period_name
	FROM gl_periods
    WHERE start_date <= p_current_date
	AND end_date >= p_current_date
    AND period_set_name = p_period_set_name
    AND period_type = p_user_period_type;

Line: 95

    SELECT CONCATENATED_SEGMENTS
	FROM FA_CATEGORIES_B_KFV
	WHERE category_id = p_category_id;

Line: 266

	-- Cursor to select contracts for accrual processing
	-- commenting where condition for Evergreen contracts processing
    CURSOR select_contracts_csr IS
    SELECT chr.id,
           chr.contract_number
    FROM OKC_K_HEADERS_B chr,
         OKL_K_HEADERS khr
    WHERE chr.scs_code = 'LEASE'
    AND chr.id = khr.id
	AND chr.sts_code IN ('BOOKED','EVERGREEN') --bug 3448057. Removing approved and under revision status
	AND khr.deal_type = 'LEASEOP';

Line: 284

    SELECT fad.asset_category_id,
           trx.accrual_activity,
           trx.date_accrual,
           SUM(fds.deprn_amount) deprn_amount
	FROM
	   OKL_TRX_CONTRACTS trx,
	   OKC_K_ITEMS cli,
	   OKC_K_LINES_B cle,
	   OKC_LINE_STYLES_B cls,
       FA_BOOKS fab,
	   FA_ADDITIONS_B fad,
       FA_BOOK_CONTROLS fbc,
	   FA_CATEGORIES_B fcb,
	   FA_DEPRN_SUMMARY fds,
	   FA_DEPRN_PERIODS fdp
 --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
	WHERE trx.tsu_code = 'PROCESSED'
	AND trx.tcn_type = 'ACL'
	AND trx.accrual_activity IN ('CATCH-UP','NON-ACCRUAL')
	AND trx.khr_id = p_khr_id
--rkuttiya added for 12.1.1 Multi GAAP Project
    AND trx.representation_type = 'PRIMARY'
--
    AND trx.date_transaction_occurred BETWEEN l_period_from AND l_period_to -- Bug 3130551
	AND cle.dnz_chr_id = trx.khr_id
    AND cle.id = cli.cle_id
    AND cle.dnz_chr_id = p_khr_id
    AND cli.dnz_chr_id = cle.dnz_chr_id
    AND cle.lse_id = cls.id
    AND cls.lty_code = 'FIXED_ASSET'
	AND fad.asset_id = TO_NUMBER(cli.object1_id1)
    AND fad.asset_category_id = fcb.category_id
    AND fad.asset_id = fab.asset_id
    AND fab.book_type_code = fbc.book_type_code
    AND fab.transaction_header_id_out is null
    AND NVL(fbc.date_ineffective,sysdate+1) > sysdate
    AND fbc.book_class = 'CORPORATE'
    AND fds.asset_id = fad.asset_id
	AND fds.book_type_code = fab.book_type_code
	AND fds.book_type_code = fdp.book_type_code
    AND fds.period_counter = fdp.period_counter
    AND fdp.period_name = GET_PERIOD_NAME(trx.date_accrual)
	GROUP BY fad.asset_category_id,trx.date_accrual,trx.accrual_activity;

Line: 330

    SELECT SUM(kleb_rv.percent_stake) percent_stake
    FROM okl_k_lines kleb_rv,
         okc_k_lines_b cles_rv,
         okc_line_styles_b lseb_rv,
         okl_strm_type_b styb_rv,
         okc_k_lines_b cles_iv,
         okc_line_styles_b lseb_iv
    WHERE cles_iv.dnz_chr_id = p_inv_id
    AND cles_iv.lse_id = lseb_iv.id
    AND lseb_iv.lty_code = 'INVESTMENT'
    AND cles_rv.cle_id = cles_iv.id
    AND cles_rv.lse_id = lseb_rv.id
    AND lseb_rv.lty_code = 'REVENUE_SHARE'
    AND kleb_rv.id = cles_rv.id
    AND kleb_rv.sty_id = styb_rv.id
    AND styb_rv.code ='RENT';

Line: 349

    SELECT name
    FROM hr_operating_units
    WHERE organization_id = p_org_id;

Line: 355

    SELECT id
    FROM OKL_STRM_TYPE_B
    WHERE code = 'RENT';

Line: 361

    SELECT contract_number
    FROM OKC_K_HEADERS_B
	WHERE id = p_agr_id;

Line: 450

	--FETCH select_contracts_csr BULK COLLECT INTO l_depr_contracts_tbl;

Line: 451

	--CLOSE select_contracts_csr;

Line: 453

	FOR x in select_contracts_csr
	LOOP
	  l_depr_contracts_tbl(select_contracts_csr%ROWCOUNT).contract_id := x.id;

Line: 456

	  l_depr_contracts_tbl(select_contracts_csr%ROWCOUNT).contract_number := x.contract_number;