DBA Data[Home] [Help]

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 6083: p_ppd_reason_code IN FND_LOOKUPS.LOOKUP_CODE%TYPE,

6079: p_source_trx_type IN OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
6080: p_transaction_date IN OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE,
6081: x_mass_rebook_trx_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE,
6082: p_ppd_amount IN NUMBER,
6083: p_ppd_reason_code IN FND_LOOKUPS.LOOKUP_CODE%TYPE,
6084: p_payment_struc IN okl_mass_rebook_pvt.strm_lalevl_tbl_type
6085: )
6086: IS
6087: l_api_name VARCHAR2(35) := 'apply_mass_rebook';