The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT PA_STD_BILL_SCH_S.NextVal
INTO l_Bill_Rate_Sch_ID
FROM DUAL;
SELECT Org_ID
INTO l_Org_ID
FROM PA_Implementations;
SELECT 1 INTO l_Exists_Flag
FROM
PA_STD_BILL_RATE_SCHEDULES_ALL
WHERE
ORG_ID = l_Org_ID
AND STD_BILL_RATE_SCHEDULE = P_Source_Rate_Schedule
AND Organization_ID = P_Source_Organization_ID;
INSERT INTO
PA_STD_BILL_RATE_SCHEDULES_ALL (
ORGANIZATION_ID,
STD_BILL_RATE_SCHEDULE,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
SCHEDULE_TYPE,
DESCRIPTION,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ORG_ID,
BILL_RATE_SCH_ID,
JOB_GROUP_ID,
RATE_SCH_CURRENCY_CODE,
SHARE_ACROSS_OU_FLAG )
SELECT
P_ORGANIZATION_ID,
P_RATE_SCHEDULE,
sysdate, -- LAST_UPDATE_DATE,
FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
sysdate, -- CREATION_DATE,
FND_GLOBAL.User_ID, -- CREATED_BY,
FND_GLOBAL.User_ID, -- LAST_UPDATE_LOGIN,
SCHEDULE_TYPE,
P_Rate_Schedule_Desc,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ORG_ID,
l_Bill_Rate_Sch_ID,
JOB_GROUP_ID,
P_Rate_Sch_Currency_Code,
P_Share_Across_OU_Flag
FROM
PA_STD_BILL_RATE_SCHEDULES_ALL
WHERE
ORG_ID = l_Org_ID
AND STD_BILL_RATE_SCHEDULE = P_Source_Rate_Schedule
AND Organization_ID = P_Source_Organization_ID;
INSERT INTO
PA_BILL_RATES_ALL (
BILL_RATE_ORGANIZATION_ID,
STD_BILL_RATE_SCHEDULE,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
START_DATE_ACTIVE,
PERSON_ID,
JOB_ID,
EXPENDITURE_TYPE,
NON_LABOR_RESOURCE,
RATE,
BILL_RATE_UNIT,
MARKUP_PERCENTAGE,
END_DATE_ACTIVE,
ORG_ID,
BILL_RATE_SCH_ID,
JOB_GROUP_ID,
RATE_CURRENCY_CODE,
Resource_Class_Code,
Res_Class_Organization_Id
)
SELECT
P_Organization_ID,
P_Rate_Schedule,
sysdate, -- LAST_UPDATE_DATE,
FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
Sysdate, -- CREATION_DATE,
FND_GLOBAL.User_ID, -- CREATED_BY,
FND_GLOBAL.User_ID, -- LAST_UPDATE_LOGIN,
START_DATE_ACTIVE,
PERSON_ID,
JOB_ID,
EXPENDITURE_TYPE,
NON_LABOR_RESOURCE,
RATE*(1 + NVL(P_Escalated_Rate_Perc,0)/100),
BILL_RATE_UNIT,
MARKUP_PERCENTAGE*(1 + NVL(P_Escalated_Markup_Perc,0)/100),
END_DATE_ACTIVE,
ORG_ID,
l_Bill_Rate_Sch_ID,
JOB_GROUP_ID,
P_Rate_Sch_Currency_Code,
Resource_Class_Code,
Res_Class_Organization_Id
FROM
PA_BILL_RATES_ALL
WHERE
ORG_ID = l_Org_ID
AND STD_BILL_RATE_SCHEDULE = P_Source_Rate_Schedule
AND Bill_Rate_Organization_ID = P_Source_Organization_ID;