[Home] [Help]
3844: (p_rgd_code in varchar2, p_rdf_code in varchar2, p_intent varchar2, p_number number)
3845: return varchar2 is
3846: CURSOR l_csr IS
3847: SELECT JTOT_OBJECT_CODE
3848: FROM okc_rule_def_sources_v
3849: WHERE RGR_RGD_CODE = p_rgd_code
3850: and RGR_RDF_CODE = p_rdf_code
3851: and BUY_OR_SELL = p_intent
3852: and OBJECT_ID_NUMBER = p_number