eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CPY_PDT_RULS_PVT dependencies on OKL_OVD_RUL_TMLS

Line 730: --cursor to get rule id from option value rule templates (okl_ovd_rul_tmls)

726: AND ove.ID = p_ove_id; --(p_ove id will be ove id fetched in last csr)
727:
728: l_opv_ruls_rec l_opv_ruls_csr%ROWTYPE;
729:
730: --cursor to get rule id from option value rule templates (okl_ovd_rul_tmls)
731: CURSOR l_ovd_rul_tmls_csr (p_ovd_id IN NUMBER) is
732: SELECT RUL_ID, --required fk to okc_rules_v.id
733: OVD_ID --fk to okl_opv_rules.id
734: FROM OKL_OVD_RUL_TMLS

Line 734: FROM OKL_OVD_RUL_TMLS

730: --cursor to get rule id from option value rule templates (okl_ovd_rul_tmls)
731: CURSOR l_ovd_rul_tmls_csr (p_ovd_id IN NUMBER) is
732: SELECT RUL_ID, --required fk to okc_rules_v.id
733: OVD_ID --fk to okl_opv_rules.id
734: FROM OKL_OVD_RUL_TMLS
735: WHERE OVD_ID = p_ovd_id; --(p_ovd_id will be id fetched in the last cursor)
736:
737: l_ovd_rul_tmls_rec l_ovd_rul_tmls_csr%ROWTYPE;
738: