APPS.OKL_MASS_REBOOK_PVT dependencies on FND_LOOKUPS

Line 189: FROM fnd_lookups

185: ORDER BY line_number;
186:
187: CURSOR crit_csr (p_code VARCHAR2) IS
188: SELECT 'Y'
189: FROM fnd_lookups
190: WHERE lookup_type = 'OKL_MASS_RBK_CRITERIA'
191: AND lookup_code = p_code;
192:
193: l_query VARCHAR2(2000);

Line 5943: p_ppd_reason_code IN FND_LOOKUPS.LOOKUP_CODE%TYPE,

5939: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
5940: p_transaction_date IN OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE,
5941: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE,
5942: p_ppd_amount IN NUMBER,
5943: p_ppd_reason_code IN FND_LOOKUPS.LOOKUP_CODE%TYPE,
5944: p_payment_struc IN okl_mass_rebook_pvt.strm_lalevl_tbl_type
5945: )
5946: IS
5947: l_api_name VARCHAR2(35) := 'apply_mass_rebook';