DBA Data[Home] [Help]

APPS.IBE_ORDER_SAVE_PVT dependencies on JTF_RS_SALESREPS

Line 796: select SALESREP_ID into l_salesrep_id from JTF_RS_SALESREPS where SALESREP_NUMBER = l_salesrep_number and ORG_ID = l_user_orgid;

792: FND_Msg_Pub.Add;
793: RAISE FND_API.G_EXC_ERROR;
794: ELSE
795: -- Get the sales rep id from the sales rep number using the JTF table
796: select SALESREP_ID into l_salesrep_id from JTF_RS_SALESREPS where SALESREP_NUMBER = l_salesrep_number and ORG_ID = l_user_orgid;
797: END IF;
798:
799: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
800: Ibe_util.Debug('Sales Rep Id : ' ||l_salesrep_id);

Line 3606: select SALESREP_ID into l_salesrep_id from JTF_RS_SALESREPS where SALESREP_NUMBER = l_salesrep_number and ORG_ID = l_user_orgid;

3602: FND_Msg_Pub.Add;
3603: RAISE FND_API.G_EXC_ERROR;
3604: ELSE
3605: -- Get the sales rep id from the sales rep number using the JTF table
3606: select SALESREP_ID into l_salesrep_id from JTF_RS_SALESREPS where SALESREP_NUMBER = l_salesrep_number and ORG_ID = l_user_orgid;
3607: END IF;
3608:
3609: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3610: Ibe_util.Debug('Sales Rep Id : ' ||l_salesrep_id);