DBA Data[Home] [Help]

APPS.OKL_FE_STD_RATE_TMPL_PVT dependencies on OKL_LS_RT_FCTR_SETS_V

Line 1587: ,okl_ls_rt_fctr_sets_v hdr

1583: SELECT vers.rate_set_version_id id
1584: ,hdr.name name
1585: ,vers.version_number version_number
1586: FROM okl_fe_rate_set_versions vers
1587: ,okl_ls_rt_fctr_sets_v hdr
1588: WHERE vers.rate_set_id = hdr.id
1589: AND vers.std_rate_tmpl_ver_id = p_version_id
1590: AND vers.sts_code = 'ACTIVE';
1591: l_version_id NUMBER := p_version_id;

Line 1865: ,okl_ls_rt_fctr_sets_v hdr

1861: SELECT vers.rate_set_version_id id
1862: ,hdr.name name
1863: ,vers.version_number version_number
1864: FROM okl_fe_rate_set_versions vers
1865: ,okl_ls_rt_fctr_sets_v hdr
1866: WHERE vers.rate_set_id = hdr.id
1867: AND vers.std_rate_tmpl_ver_id = p_version_id
1868: AND vers.sts_code = 'ACTIVE';
1869: lp_srv_rec okl_srv_rec;