APPS.PV_ASSIGNMENT_PVT dependencies on PV_OPPTY_ROUTING_LOGS

Line 65: CURSOR C2 IS SELECT PV_OPPTY_ROUTING_LOGS_S.nextval FROM sys.dual;

61: IS
62: l_api_name CONSTANT VARCHAR2(30) := 'Create_Oppty_Routing_Log_Row';
63: l_api_version_number CONSTANT NUMBER := 1.0;
64:
65: CURSOR C2 IS SELECT PV_OPPTY_ROUTING_LOGS_S.nextval FROM sys.dual;
66:
67: CURSOR get_org_id ( pc_user_id NUMBER)
68: IS
69: SELECT business_group_id

Line 118: INSERT INTO pv_oppty_routing_logs

114: CLOSE get_org_id;
115:
116: END IF;
117:
118: INSERT INTO pv_oppty_routing_logs
119: (
120: OPPTY_ROUTING_LOG_ID
121: , EVENT
122: , LEAD_ID