DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKC_STATUSES_V

Line 1792: OKC_STATUSES_V sts,

1788: chr.scs_code,
1789: chr.sts_code,
1790: sts.meaning
1791: FROM OKC_K_HEADERS_V chr,
1792: OKC_STATUSES_V sts,
1793: OKL_K_HEADERS_V khr
1794: WHERE chr.id = p_contract_id
1795: AND chr.sts_code = sts.code
1796: AND chr.id = khr.id;

Line 1803: FROM okc_k_headers_b khr, okc_statuses_v sts

1799: -- sure that the contract has a logical post
1800: -- booking status.
1801: CURSOR k_contractstatus_csr IS
1802: SELECT khr.contract_number, sts.ste_code, sts.meaning
1803: FROM okc_k_headers_b khr, okc_statuses_v sts
1804: WHERE khr.sts_code = sts.code
1805: AND khr.id = p_contract_id;
1806:
1807: -- Cursor to check if contract locked

Line 3499: OKC_STATUSES_V STS1

3495: OKC_K_LINES_B CLE1,
3496: OKC_LINE_STYLES_B LS1,
3497: okl_subsidies_b SUB,
3498: okl_subsidies_tl subt,
3499: OKC_STATUSES_V STS1
3500: -- ,okl_sgn_translations sgn --RMUNJULU *** --rmunjulu bug 4399352
3501: where KLE1.ID = CLE1.ID
3502: AND CLE1.LSE_ID = LS1.ID
3503: AND LS1.LTY_CODE ='SUBSIDY'