DBA Data[Home] [Help]

APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_LS_RT_FCTR_SETS_V

Line 4675: p_lrs_version_id IN okl_ls_rt_fctr_sets_v.ID%TYPE,

4671: x_lrs_levels OUT NOCOPY lrs_levels_tbl_type)
4672: IS
4673: -- Cursor Declarations
4674: CURSOR lrs_version_details_csr(
4675: p_lrs_version_id IN okl_ls_rt_fctr_sets_v.ID%TYPE,
4676: p_date IN DATE )
4677: IS
4678: SELECT
4679: hdr.id header_id,

Line 4698: FROM okl_ls_rt_fctr_sets_v hdr,

4694: ver.rate_tolerance rate_tolerance,
4695: ver.residual_tolerance residual_tolerance,
4696: ver.deferred_pmts deferred_pmts,
4697: ver.advance_pmts advance_pmts
4698: FROM okl_ls_rt_fctr_sets_v hdr,
4699: okl_fe_rate_set_versions_v ver
4700: WHERE ver.rate_set_id = hdr.id
4701: AND ver.rate_set_version_id = p_lrs_version_id
4702: AND trunc(ver.effective_from_date) <= p_date