APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKL_PROD_QLTY_VAL_UV

Line 378: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v

374:
375: FUNCTION CHECK_DATE_ACCRUED_TILL(p_khr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE
376: ,p_date IN DATE) RETURN VARCHAR2 IS
377:
378: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
379: CURSOR get_rev_rec_method_csr(p_chr_id NUMBER) IS
380: SELECT pdt.quality_val revenue_recognition_method
381: FROM OKL_PROD_QLTY_VAL_UV pdt,
382: OKL_K_HEADERS_FULL_V khr

Line 381: FROM OKL_PROD_QLTY_VAL_UV pdt,

377:
378: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
379: CURSOR get_rev_rec_method_csr(p_chr_id NUMBER) IS
380: SELECT pdt.quality_val revenue_recognition_method
381: FROM OKL_PROD_QLTY_VAL_UV pdt,
382: OKL_K_HEADERS_FULL_V khr
383: WHERE khr.id = p_chr_id
384: AND khr.pdt_id = pdt.pdt_id
385: AND pdt.quality_name = 'REVENUE_RECOGNITION_METHOD'

Line 10011: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v

10007: l_data_found BOOLEAN := FALSE;
10008: l_num_workers NUMBER;
10009: l_worker_id VARCHAR2(2000);
10010:
10011: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
10012: CURSOR chk_update_header_csr is
10013: SELECT chr.contract_number
10014: FROM OKC_K_HEADERS_B chr,
10015: OKL_K_HEADERS khr,

Line 10016: OKL_PROD_QLTY_VAL_UV pdt

10012: CURSOR chk_update_header_csr is
10013: SELECT chr.contract_number
10014: FROM OKC_K_HEADERS_B chr,
10015: OKL_K_HEADERS khr,
10016: OKL_PROD_QLTY_VAL_UV pdt
10017: WHERE chr.scs_code = 'LEASE'
10018: AND chr.sts_code IN ('BOOKED','EVERGREEN')
10019: AND chr.id = khr.id
10020: AND khr.pdt_id = pdt.pdt_id

Line 10090: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v

10086:
10087: -- -- Cursor to select contracts for accrual processing
10088: -- -- modified cursor to select only lease contracts
10089: -- -- bug#2618966
10090: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
10091: CURSOR accrual_contract_csr IS
10092: SELECT chr.id
10093: ,chr.contract_number
10094: ,chr.start_date

Line 10106: OKL_PROD_QLTY_VAL_UV pdt

10102: ,khr.currency_conversion_rate
10103: ,khr.currency_conversion_date
10104: FROM OKC_K_HEADERS_B chr,
10105: OKL_K_HEADERS khr,
10106: OKL_PROD_QLTY_VAL_UV pdt
10107: WHERE chr.contract_number = p_contract_number
10108: AND chr.id = khr.id
10109: AND chr.scs_code = 'LEASE'
10110: AND chr.sts_code IN ('BOOKED','EVERGREEN')

Line 11051: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v

11047: l_accrual_date DATE;
11048: l_process_accrual_rec process_accrual_rec_type;
11049: l_rev_rec_method VARCHAR2(2000);
11050:
11051: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
11052: CURSOR accrual_contract_csr (p_khr_id NUMBER) IS
11053: SELECT chr.contract_number
11054: ,chr.start_date
11055: ,chr.sts_code

Line 11067: OKL_PROD_QLTY_VAL_UV pdt

11063: ,khr.currency_conversion_date
11064: ,pdt.quality_val revenue_recognition_method
11065: FROM OKC_K_HEADERS_B chr,
11066: OKL_K_HEADERS khr,
11067: OKL_PROD_QLTY_VAL_UV pdt
11068: WHERE chr.id = p_khr_id
11069: AND chr.id = khr.id
11070: AND chr.scs_code = 'LEASE'
11071: AND chr.sts_code IN ('BOOKED','EVERGREEN')