APPS.OKL_AM_UTIL_PVT dependencies on OKL_CS_ALC_SUMMARY_UV

Line 4922: FROM okl_cs_alc_summary_uv

4918: p_top_line_id IN NUMBER) RETURN NUMBER IS
4919:
4920: CURSOR get_tax_amount_csr (cp_top_line_id IN NUMBER) IS
4921: SELECT tax_amount
4922: FROM okl_cs_alc_summary_uv
4923: WHERE dnz_cle_id = cp_top_line_id
4924: AND tsu_code = 'PROCESSED';
4925:
4926: l_tax_amount NUMBER;

Line 4955: FROM okl_cs_alc_summary_uv

4951: p_top_line_id IN NUMBER) RETURN NUMBER IS
4952:
4953: CURSOR get_req_id_csr (cp_top_line_id IN NUMBER) IS
4954: SELECT request_id
4955: FROM okl_cs_alc_summary_uv
4956: WHERE dnz_cle_id = cp_top_line_id
4957: AND tsu_code = 'PROCESSED';
4958:
4959: l_req_id NUMBER;

Line 5031: FROM okl_cs_alc_summary_uv

5027: p_top_line_id IN NUMBER) RETURN DATE IS
5028:
5029: CURSOR get_eff_Date_csr (cp_top_line_id IN NUMBER) IS
5030: SELECT DATE_EFFECTIVE
5031: FROM okl_cs_alc_summary_uv
5032: WHERE dnz_cle_id = cp_top_line_id
5033: AND tsu_code = 'PROCESSED';
5034:
5035: l_eff_date DATE;

Line 5064: FROM okl_cs_alc_summary_uv

5060: p_top_line_id IN NUMBER) RETURN VARCHAR2 IS
5061:
5062: CURSOR get_req_sts_csr (cp_top_line_id IN NUMBER) IS
5063: SELECT TSU_CODE
5064: FROM okl_cs_alc_summary_uv
5065: WHERE dnz_cle_id = cp_top_line_id;
5066:
5067: l_req_sts VARCHAR2(30);
5068: