APPS.OKL_QA_DATA_INTEGRITY dependencies on FND_LOOKUPS

Line 4224: l_fnd_meaning FND_LOOKUPS.MEANING%TYPE;

4220: l_assetrl_rec l_assetrl_csr%ROWTYPE;
4221: l_strm_asset_rec l_strm_asset_csr%ROWTYPE;
4222: l_rule_not_found BOOLEAN;
4223: l_fnd_rec fnd_csr%ROWTYPE;
4224: l_fnd_meaning FND_LOOKUPS.MEANING%TYPE;
4225: l_billtx_method FND_LOOKUPS.MEANING%TYPE;
4226:
4227: BEGIN
4228:

Line 4225: l_billtx_method FND_LOOKUPS.MEANING%TYPE;

4221: l_strm_asset_rec l_strm_asset_csr%ROWTYPE;
4222: l_rule_not_found BOOLEAN;
4223: l_fnd_rec fnd_csr%ROWTYPE;
4224: l_fnd_meaning FND_LOOKUPS.MEANING%TYPE;
4225: l_billtx_method FND_LOOKUPS.MEANING%TYPE;
4226:
4227: BEGIN
4228:
4229: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 5796: CURSOR fee_meaning_csr (p_fee_type_code FND_LOOKUPS.LOOKUP_CODE%TYPE) IS

5792: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')
5793: AND sty.lty_code = 'FEE'
5794: AND l.dnz_chr_id = p_chrId;
5795:
5796: CURSOR fee_meaning_csr (p_fee_type_code FND_LOOKUPS.LOOKUP_CODE%TYPE) IS
5797: SELECT meaning
5798: FROM fnd_lookups
5799: WHERE lookup_code = p_fee_type_code
5800: AND lookup_type = 'OKL_FEE_TYPES';

Line 5798: FROM fnd_lookups

5794: AND l.dnz_chr_id = p_chrId;
5795:
5796: CURSOR fee_meaning_csr (p_fee_type_code FND_LOOKUPS.LOOKUP_CODE%TYPE) IS
5797: SELECT meaning
5798: FROM fnd_lookups
5799: WHERE lookup_code = p_fee_type_code
5800: AND lookup_type = 'OKL_FEE_TYPES';
5801:
5802: --------------

Line 5818: l_fee_type FND_LOOKUPS.MEANING%TYPE;

5814: --------------
5815: --Bug# 4350255
5816: --------------
5817:
5818: l_fee_type FND_LOOKUPS.MEANING%TYPE;
5819: l_pmnt_amount NUMBER;
5820:
5821: l_tot_pmnt NUMBER := 0;
5822: l_exp_present VARCHAR2(1) := 'N';