APPS.OKL_AM_BTCH_EXP_LEASE_LOAN_PVT dependencies on OKC_K_HEADERS_V

Line 1891: FROM okc_k_headers_v k

1887: -- Get the contract details for contract number passed
1888: -- RMUNJULU 05-MAR-03 Performance Fix Replaced K_HDR_FULL
1889: CURSOR single_k_csr (p_khr_id IN NUMBER) IS
1890: SELECT k.contract_number
1891: FROM okc_k_headers_v k
1892: WHERE k.ID = p_khr_id;
1893:
1894: -- rmunjulu Added for bug 4385077 to do org strip
1895:

Line 1915: FROM okc_k_headers_v khr

1911: -- RMUNJULU 05-MAR-03 Performance Fix Replaced K_HDR_FULL
1912: CURSOR ter_cnt_csr (p_sysdate IN DATE) IS
1913: SELECT khr.ID,
1914: khr.contract_number
1915: FROM okc_k_headers_v khr
1916: WHERE TRUNC (khr.end_date) < TRUNC (p_sysdate)
1917: AND NVL (khr.sts_code, '?') IN ('BOOKED')
1918: AND khr.scs_code IN ('LEASE', 'LOAN')
1919: AND khr.ID NOT IN (

Line 1965: FROM okc_k_headers_v k, okl_trx_contracts t

1961: CURSOR ter_cnt_recy_csr (p_sysdate IN DATE) IS
1962: SELECT k.ID,
1963: k.contract_number,
1964: t.ID trn_id -- RMUNJULU 17-NOV-02 Bug # 2484327 Added
1965: FROM okc_k_headers_v k, okl_trx_contracts t
1966: WHERE NVL (t.tmt_recycle_yn, '?') = 'Y'
1967: AND NVL (t.tmt_status_code, '?') NOT IN ('PROCESSED', 'CANCELED')
1968: --rkuttiya added for 12.1.1 Multi GAAP
1969: AND t.representation_type = 'PRIMARY'

Line 1986: FROM okc_k_headers_v khr

1982: -- and no accepted quotes.
1983: CURSOR exp_chr_csr (p_khr_id IN NUMBER, p_sysdate IN DATE) IS
1984: SELECT khr.ID,
1985: khr.contract_number
1986: FROM okc_k_headers_v khr
1987: WHERE khr.ID = p_khr_id
1988: AND TRUNC (khr.end_date) < TRUNC (p_sysdate)
1989: AND NVL (khr.sts_code, '?') IN ('BOOKED')
1990: AND khr.scs_code IN ('LEASE', 'LOAN')

Line 2029: FROM okc_k_headers_v k, okl_trx_contracts t

2025: CURSOR recy_chr_csr (p_khr_id IN NUMBER, p_sysdate IN DATE) IS
2026: SELECT k.ID,
2027: k.contract_number,
2028: t.ID trn_id
2029: FROM okc_k_headers_v k, okl_trx_contracts t
2030: WHERE k.ID = p_khr_id
2031: AND NVL (t.tmt_recycle_yn, '?') = 'Y'
2032: AND NVL (t.tmt_status_code, '?') NOT IN ('PROCESSED', 'CANCELED')
2033: --akrangan changed for sla tmt_status_Code cr