DBA Data[Home] [Help]

APPS.OKL_AM_CREATE_QUOTE_PVT dependencies on WF_ROLES

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

3031: --AND OKLV.date_terminated IS NULL; -- RMUNJULU 18-FEB-03 2804703 removed
3032:
3033: --SECHAWLA 28-FEB-03 Bug # 2757175 : Added the following cursor
3034: -- This cursor isused to get the display name for a role
3035: CURSOR l_wfroles_csr(p_name wf_roles.name%TYPE) IS
3036: SELECT display_name
3037: FROM wf_roles
3038: WHERE name = p_name;
3039:

Line 3037: FROM wf_roles

3033: --SECHAWLA 28-FEB-03 Bug # 2757175 : Added the following cursor
3034: -- This cursor isused to get the display name for a role
3035: CURSOR l_wfroles_csr(p_name wf_roles.name%TYPE) IS
3036: SELECT display_name
3037: FROM wf_roles
3038: WHERE name = p_name;
3039:
3040: l_display_name wf_roles.display_name%TYPE;
3041: lx_contract_status VARCHAR2(200);

Line 3040: l_display_name wf_roles.display_name%TYPE;

3036: SELECT display_name
3037: FROM wf_roles
3038: WHERE name = p_name;
3039:
3040: l_display_name wf_roles.display_name%TYPE;
3041: lx_contract_status VARCHAR2(200);
3042: --SECHAWLA 28-FEB-03 Bug # 2757175 : end new declarations
3043:
3044: lp_quot_rec quot_rec_type := p_quot_rec;