DBA Data[Home] [Help]

APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_LS_RT_FCTR_SETS_V

Line 4653: p_lrs_version_id IN okl_ls_rt_fctr_sets_v.ID%TYPE,

4649: x_lrs_levels OUT NOCOPY lrs_levels_tbl_type)
4650: IS
4651: -- Cursor Declarations
4652: CURSOR lrs_version_details_csr(
4653: p_lrs_version_id IN okl_ls_rt_fctr_sets_v.ID%TYPE,
4654: p_date IN DATE )
4655: IS
4656: SELECT
4657: hdr.id header_id,

Line 4676: FROM okl_ls_rt_fctr_sets_v hdr,

4672: ver.rate_tolerance rate_tolerance,
4673: ver.residual_tolerance residual_tolerance,
4674: ver.deferred_pmts deferred_pmts,
4675: ver.advance_pmts advance_pmts
4676: FROM okl_ls_rt_fctr_sets_v hdr,
4677: okl_fe_rate_set_versions_v ver
4678: WHERE ver.rate_set_id = hdr.id
4679: AND ver.rate_set_version_id = p_lrs_version_id
4680: AND trunc(ver.effective_from_date) <= p_date