DBA Data[Home] [Help]

APPS.OKL_CONTRACT_TOP_LINE_PVT dependencies on OKC_K_HEADERS_V

Line 1690: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

1686: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1687: x_return_status OUT NOCOPY VARCHAR2,
1688: x_msg_count OUT NOCOPY NUMBER,
1689: x_msg_data OUT NOCOPY VARCHAR2,
1690: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1691: p_line_id IN OKC_K_LINES_V.ID%TYPE,
1692: p_no_of_period IN NUMBER,
1693: p_frequency IN VARCHAR2,
1694: p_amount_per_period IN NUMBER

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

1700:
1701: l_id1 VARCHAR2(30);
1702: scscode OKC_K_HEADERS_B.SCS_CODE%TYPE ;
1703:
1704: CURSOR contract_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1705: p_line_id OKC_K_LINES_V.ID%TYPE) IS
1706: SELECT line.start_date,
1707: line.end_date,
1708: line.amount,

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

1716: WHERE head.id = line.dnz_chr_id
1717: AND line.lse_id = style.id
1718: AND head.id = p_chr_id
1719: AND line.id = p_line_id;
1720: CURSOR scscode_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE ) IS
1721: SELECT head.scs_code
1722: FROM okc_k_headers_b head
1723: WHERE head.id = p_chr_id ;
1724: