DBA Data[Home] [Help]

APPS.OKL_FE_ADJ_MATRIX_PVT dependencies on OKL_LS_RT_FCTR_SETS_V

Line 1881: FROM OKL_FE_RATE_SET_VERSIONS vers, OKL_LS_RT_FCTR_SETS_V hdr

1877: -- cursor to calculate the LRS objects which are referncing this adjustment matrix
1878:
1879: CURSOR lrs_invalids_csr(p_version_id IN NUMBER) IS
1880: SELECT vers.RATE_SET_VERSION_ID ID,hdr.name NAME,vers.version_number VERSION_NUMBER
1881: FROM OKL_FE_RATE_SET_VERSIONS vers, OKL_LS_RT_FCTR_SETS_V hdr
1882: WHERE vers.rate_set_id = hdr.id AND vers.adj_mat_version_id=p_version_id
1883: AND vers.STS_CODE='ACTIVE';
1884:
1885: -- cursor to calculate the LRS invalid for the invalid SRTs

Line 1891: ,okl_ls_rt_fctr_sets_v hdr

1887: SELECT vers.rate_set_version_id id
1888: ,hdr.name name
1889: ,vers.version_number version_number
1890: FROM okl_fe_rate_set_versions vers
1891: ,okl_ls_rt_fctr_sets_v hdr
1892: WHERE vers.rate_set_id = hdr.id
1893: AND vers.std_rate_tmpl_ver_id = p_version_id
1894: AND vers.sts_code = 'ACTIVE';
1895: