APPS.OKL_ACC_CALL_PVT dependencies on OKL_TRX_TYPES_TL

Line 22: FROM okl_trx_types_tl

18: RETURN NUMBER IS
19:
20: CURSOR c_trx_type (cp_name VARCHAR2, cp_language VARCHAR2) IS
21: SELECT id
22: FROM okl_trx_types_tl
23: WHERE name = cp_name
24: AND LANGUAGE = cp_language;
25:
26: -- Replace with following query

Line 545: FROM okl_trx_types_tl

541: --Bug# 4488818: Changes for Rollover, Release Billing: Start
542:
543: CURSOR trx_type_csr(p_id NUMBER, p_language VARCHAR2) IS
544: SELECT name
545: FROM okl_trx_types_tl
546: WHERE id = p_id
547: AND language = p_language;
548:
549: trx_type_rec trx_type_csr%ROWTYPE;

Line 550: l_orig_try_id okl_trx_types_tl.id%TYPE;

546: WHERE id = p_id
547: AND language = p_language;
548:
549: trx_type_rec trx_type_csr%ROWTYPE;
550: l_orig_try_id okl_trx_types_tl.id%TYPE;
551:
552: CURSOR orig_billing_csr(p_orig_qte_id NUMBER,
553: p_orig_quote_line_id NUMBER,
554: p_orig_try_id NUMBER)

Line 1966: FROM okl_trx_types_tl

1962: --Bug# 4488818: Changes for Rollover, Release Billing: Start
1963:
1964: CURSOR trx_type_csr(p_id NUMBER, p_language VARCHAR2) IS
1965: SELECT name
1966: FROM okl_trx_types_tl
1967: WHERE id = p_id
1968: AND language = p_language;
1969:
1970: trx_type_rec trx_type_csr%ROWTYPE;

Line 1971: l_orig_try_id okl_trx_types_tl.id%TYPE;

1967: WHERE id = p_id
1968: AND language = p_language;
1969:
1970: trx_type_rec trx_type_csr%ROWTYPE;
1971: l_orig_try_id okl_trx_types_tl.id%TYPE;
1972:
1973: CURSOR orig_billing_csr(p_orig_qte_id NUMBER,
1974: p_orig_quote_line_id NUMBER,
1975: p_orig_try_id NUMBER)