The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select distinct party_name
into x_party_name
from HZ_PARTIES
where party_id = p_party_id;
SELECT jtf_terr_results_s.nextval into x_session_id FROM sys.dual;
SELECT TA.NAME
INTO l_terr_group_name
FROM JTF_TERR TA,
JTF_TERR TA2
WHERE
TA.TERR_ID = TA2.PARENT_TERRITORY_ID
AND TA2.TERR_ID = lx_winners_rec.terr_id(i);
SELECT ROLE_NAME
INTO l_role_name
FROM JTF_RS_ROLES_VL
WHERE ROLE_CODE = lx_winners_rec.role(i);
INSERT INTO JTF_TAE_RPT_STAGING_OUT(
TRANS_OBJECT_ID,
TRANS_DETAIL_OBJECT_ID,
TRANS_OBJECT_TYPE_ID,
SOURCE_ID,
SESSION_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATED_BY,
CREATION_DATE,
LAST_UPDATE_LOGIN,
TERR_ID,
TERR_RANK,
RESOURCE_ID,
RESOURCE_TYPE,
GROUP_ID,
ROLE,
RESOURCE_NAME,
AT_CHAR01,
AT_CHAR02,
AT_CHAR03,
AT_CHAR04,
AT_CHAR05,
AT_CHAR06,
AT_CHAR07
) VALUES (
lx_winners_rec.trans_object_id(i),
nvl(lx_winners_rec.trans_detail_object_id(i), -1),
-1,
-1, --p_source_id,
x_session_id,
SYSDATE,
-1,
-1,
SYSDATE,
-1,
lx_winners_rec.terr_id(i),
lx_winners_rec.absolute_rank(i),
lx_winners_rec.resource_id(i),
lx_winners_rec.resource_type(i),
lx_winners_rec.group_id(i),
lx_winners_rec.role(i),
lx_winners_rec.resource_name(i),
lx_winners_rec.resource_job_title(i),
lx_winners_rec.resource_phone(i),
lx_winners_rec.resource_email(i),
lx_winners_rec.resource_mgr_name(i),
lx_winners_rec.resource_mgr_phone(i),
l_role_name,
lx_winners_rec.resource_mgr_email(i)
);