3087: --AND OKLV.date_terminated IS NULL; -- RMUNJULU 18-FEB-03 2804703 removed
3088:
3089: --SECHAWLA 28-FEB-03 Bug # 2757175 : Added the following cursor
3090: -- This cursor isused to get the display name for a role
3091: CURSOR l_wfroles_csr(p_name wf_roles.name%TYPE) IS
3092: SELECT display_name
3093: FROM wf_roles
3094: WHERE name = p_name;
3095:
3089: --SECHAWLA 28-FEB-03 Bug # 2757175 : Added the following cursor
3090: -- This cursor isused to get the display name for a role
3091: CURSOR l_wfroles_csr(p_name wf_roles.name%TYPE) IS
3092: SELECT display_name
3093: FROM wf_roles
3094: WHERE name = p_name;
3095:
3096: l_display_name wf_roles.display_name%TYPE;
3097: lx_contract_status VARCHAR2(200);
3092: SELECT display_name
3093: FROM wf_roles
3094: WHERE name = p_name;
3095:
3096: l_display_name wf_roles.display_name%TYPE;
3097: lx_contract_status VARCHAR2(200);
3098: --SECHAWLA 28-FEB-03 Bug # 2757175 : end new declarations
3099:
3100: lp_quot_rec quot_rec_type := p_quot_rec;