DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKC_STATUSES_V

Line 1814: OKC_STATUSES_V sts,

1810: chr.scs_code,
1811: chr.sts_code,
1812: sts.meaning
1813: FROM OKC_K_HEADERS_V chr,
1814: OKC_STATUSES_V sts,
1815: OKL_K_HEADERS_V khr
1816: WHERE chr.id = p_contract_id
1817: AND chr.sts_code = sts.code
1818: AND chr.id = khr.id;

Line 1825: FROM okc_k_headers_b khr, okc_statuses_v sts

1821: -- sure that the contract has a logical post
1822: -- booking status.
1823: CURSOR k_contractstatus_csr IS
1824: SELECT khr.contract_number, sts.ste_code, sts.meaning
1825: FROM okc_k_headers_b khr, okc_statuses_v sts
1826: WHERE khr.sts_code = sts.code
1827: AND khr.id = p_contract_id;
1828:
1829: -- Cursor to check if contract locked

Line 3521: OKC_STATUSES_V STS1

3517: OKC_K_LINES_B CLE1,
3518: OKC_LINE_STYLES_B LS1,
3519: okl_subsidies_b SUB,
3520: okl_subsidies_tl subt,
3521: OKC_STATUSES_V STS1
3522: -- ,okl_sgn_translations sgn --RMUNJULU *** --rmunjulu bug 4399352
3523: where KLE1.ID = CLE1.ID
3524: AND CLE1.LSE_ID = LS1.ID
3525: AND LS1.LTY_CODE ='SUBSIDY'