DBA Data[Home] [Help]

APPS.OKL_LOAN_AMORT_SCHEDULE_PVT dependencies on OKC_K_HEADERS_B

Line 1386: FROM okc_k_headers_b chr

1382: l_last_bill_date OKL_STRM_ELEMENTS.stream_element_date%TYPE;
1383:
1384: CURSOR chr_csr(p_chr_id IN NUMBER) IS
1385: SELECT chr.start_date
1386: FROM okc_k_headers_b chr
1387: WHERE chr.id = p_chr_id;
1388:
1389: --Bug# 14683157: Fetch Principal and Interest only for Assets
1390: CURSOR amort_sched_dtl_csr(p_chr_id IN NUMBER,

Line 1666: FROM okc_k_headers_b chr

1662: l_last_bill_date OKL_STRM_ELEMENTS.stream_element_date%TYPE;
1663:
1664: CURSOR chr_csr(p_chr_id IN NUMBER) IS
1665: SELECT chr.start_date
1666: FROM okc_k_headers_b chr
1667: WHERE chr.id = p_chr_id;
1668:
1669: --Bug# 14683157: Fetch Principal and Interest only for Assets
1670: CURSOR amort_sched_dtl_csr(p_chr_id IN NUMBER,

Line 2896: okc_k_headers_b chrb

2892: chrb.start_date
2893: FROM okl_k_headers khr,
2894: okl_prod_qlty_val_uv ppm_rrm,
2895: okl_prod_qlty_val_uv ppm_icb,
2896: okc_k_headers_b chrb
2897: WHERE chrb.id = p_chr_id
2898: AND khr.id = chrb.id
2899: AND ppm_rrm.pdt_id = khr.pdt_id
2900: AND ppm_rrm.quality_name = 'REVENUE_RECOGNITION_METHOD'