APPS.OKL_QA_DATA_INTEGRITY dependencies on FND_LOOKUPS

Line 3902: l_fnd_meaning FND_LOOKUPS.MEANING%TYPE;

3898: l_assetrl_rec l_assetrl_csr%ROWTYPE;
3899: l_strm_asset_rec l_strm_asset_csr%ROWTYPE;
3900: l_rule_not_found BOOLEAN;
3901: l_fnd_rec fnd_csr%ROWTYPE;
3902: l_fnd_meaning FND_LOOKUPS.MEANING%TYPE;
3903: l_billtx_method FND_LOOKUPS.MEANING%TYPE;
3904:
3905: BEGIN
3906:

Line 3903: l_billtx_method FND_LOOKUPS.MEANING%TYPE;

3899: l_strm_asset_rec l_strm_asset_csr%ROWTYPE;
3900: l_rule_not_found BOOLEAN;
3901: l_fnd_rec fnd_csr%ROWTYPE;
3902: l_fnd_meaning FND_LOOKUPS.MEANING%TYPE;
3903: l_billtx_method FND_LOOKUPS.MEANING%TYPE;
3904:
3905: BEGIN
3906:
3907: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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

5405: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')
5406: AND sty.lty_code = 'FEE'
5407: AND l.dnz_chr_id = p_chrId;
5408:
5409: CURSOR fee_meaning_csr (p_fee_type_code FND_LOOKUPS.LOOKUP_CODE%TYPE) IS
5410: SELECT meaning
5411: FROM fnd_lookups
5412: WHERE lookup_code = p_fee_type_code
5413: AND lookup_type = 'OKL_FEE_TYPES';

Line 5411: FROM fnd_lookups

5407: AND l.dnz_chr_id = p_chrId;
5408:
5409: CURSOR fee_meaning_csr (p_fee_type_code FND_LOOKUPS.LOOKUP_CODE%TYPE) IS
5410: SELECT meaning
5411: FROM fnd_lookups
5412: WHERE lookup_code = p_fee_type_code
5413: AND lookup_type = 'OKL_FEE_TYPES';
5414:
5415: --------------

Line 5431: l_fee_type FND_LOOKUPS.MEANING%TYPE;

5427: --------------
5428: --Bug# 4350255
5429: --------------
5430:
5431: l_fee_type FND_LOOKUPS.MEANING%TYPE;
5432: l_pmnt_amount NUMBER;
5433:
5434: l_tot_pmnt NUMBER := 0;
5435: l_exp_present VARCHAR2(1) := 'N';