DBA Data[Home] [Help]

APPS.OKL_CONTRACT_TOP_LINE_PVT dependencies on OKC_K_HEADERS_V

Line 1745: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

1741: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1742: x_return_status OUT NOCOPY VARCHAR2,
1743: x_msg_count OUT NOCOPY NUMBER,
1744: x_msg_data OUT NOCOPY VARCHAR2,
1745: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1746: p_line_id IN OKC_K_LINES_V.ID%TYPE,
1747: p_no_of_period IN NUMBER,
1748: p_frequency IN VARCHAR2,
1749: p_amount_per_period IN NUMBER

Line 1759: CURSOR contract_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

1755:
1756: l_id1 VARCHAR2(30);
1757: scscode OKC_K_HEADERS_B.SCS_CODE%TYPE ;
1758:
1759: CURSOR contract_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1760: p_line_id OKC_K_LINES_V.ID%TYPE) IS
1761: SELECT line.start_date,
1762: line.end_date,
1763: line.amount,

Line 1775: CURSOR scscode_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE ) IS

1771: WHERE head.id = line.dnz_chr_id
1772: AND line.lse_id = style.id
1773: AND head.id = p_chr_id
1774: AND line.id = p_line_id;
1775: CURSOR scscode_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE ) IS
1776: SELECT head.scs_code
1777: FROM okc_k_headers_b head
1778: WHERE head.id = p_chr_id ;
1779: