APPS.OKL_SECURITIZATION_PVT dependencies on FND_LOOKUPS

Line 1149: ,x_fact_synd_code OUT NOCOPY fnd_lookups.lookup_code%TYPE

1145: ,x_msg_data OUT NOCOPY VARCHAR2
1146: ,p_khr_id IN NUMBER
1147: ,p_scs_code IN okc_k_headers_b.scs_code%TYPE DEFAULT NULL
1148: ,p_trx_date IN DATE
1149: ,x_fact_synd_code OUT NOCOPY fnd_lookups.lookup_code%TYPE
1150: ,x_inv_acct_code OUT NOCOPY okc_rules_b.RULE_INFORMATION1%TYPE
1151: )
1152: IS
1153: l_api_name CONSTANT VARCHAR2(30) := 'check_khr_ia_associated';

Line 1168: FROM fnd_lookups

1164: l_investor_code okc_rules_b.rule_information1%TYPE;
1165:
1166: CURSOR fact_synd_code IS
1167: SELECT lookup_code
1168: FROM fnd_lookups
1169: WHERE lookup_type = 'OKL_FACTORING_SYNDICATION'
1170: AND lookup_code = 'INVESTOR';
1171: l_fact_synd_code fnd_lookups.lookup_code%TYPE;
1172:

Line 1171: l_fact_synd_code fnd_lookups.lookup_code%TYPE;

1167: SELECT lookup_code
1168: FROM fnd_lookups
1169: WHERE lookup_type = 'OKL_FACTORING_SYNDICATION'
1170: AND lookup_code = 'INVESTOR';
1171: l_fact_synd_code fnd_lookups.lookup_code%TYPE;
1172:
1173: CURSOR ia_number (p_chr_id IN NUMBER, p_trx_date IN DATE)IS
1174: SELECT COUNT(khr_id)
1175: FROM okl_pools