DBA Data[Home] [Help]

APPS.OKL_AM_CREATE_QUOTE_PVT dependencies on WF_ROLES

Line 3091: CURSOR l_wfroles_csr(p_name wf_roles.name%TYPE) IS

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:

Line 3093: FROM wf_roles

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);

Line 3096: l_display_name wf_roles.display_name%TYPE;

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;