APPS.IBE_QUOTE_SAVE_PVT dependencies on JTF_RS_SALESREPS_MO_V

Line 3606: from jtf_rs_salesreps_mo_v

3602: from aso_quote_headers_all
3603: where quote_header_id = qte_hdr_id;
3604: /*Cursor c_get_jtf_resource(salesrep number) is
3605: select resource_id
3606: from jtf_rs_salesreps_mo_v
3607: where salesrep_id = salesrep;*/
3608: /*10/17/2005:Mannamra: Bug ref #4682364. Modified cursor for getting the resource.
3609: This query will get us the primary resource id */
3610: CURSOR c_get_jtf_resource (l_Srep VARCHAR2) IS

Line 3613: FROM JTF_RS_SALESREPS_MO_V

3609: This query will get us the primary resource id */
3610: CURSOR c_get_jtf_resource (l_Srep VARCHAR2) IS
3611: SELECT Resource_Id
3612: /* FROM JTF_RS_SRP_VL */
3613: FROM JTF_RS_SALESREPS_MO_V
3614: WHERE Salesrep_number = l_Srep
3615: AND NVL(status,'A') = 'A'
3616: AND nvl(trunc(start_date_active), trunc(sysdate)) <= trunc(sysdate)
3617: AND nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate) ;

Line 3753: --table jtf_rs_salesreps_mo_v. --Old comment

3749: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3750: IBE_UTIL.debug('Salesrep id from ASO profile is '||l_salesrep_id);
3751: END IF;
3752: --Profile value(ASO_DEFAULT_PERSON_ID) has salesrep_id, obtain resource_id from the
3753: --table jtf_rs_salesreps_mo_v. --Old comment
3754: /*--10/17/2005: Mannamra: In light of MOAC chages, default salesrep setting is no
3755: longer a profile value but is instead stored
3756: as Quoting parameter.However we will still obtainb the resource id
3757: for the corresponding salesrep id from jtf_rs_salesreps_mo_v. Bug ref: 4682364*/

Line 3757: for the corresponding salesrep id from jtf_rs_salesreps_mo_v. Bug ref: 4682364*/

3753: --table jtf_rs_salesreps_mo_v. --Old comment
3754: /*--10/17/2005: Mannamra: In light of MOAC chages, default salesrep setting is no
3755: longer a profile value but is instead stored
3756: as Quoting parameter.However we will still obtainb the resource id
3757: for the corresponding salesrep id from jtf_rs_salesreps_mo_v. Bug ref: 4682364*/
3758:
3759: for rec_get_jtf_resource in c_get_jtf_resource(l_salesrep_id) loop
3760: L_resource_id := rec_get_jtf_resource.resource_id;
3761: IF (IBE_UTIL.G_DEBUGON = l_true) THEN