The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT trunc(dbi_SES_DTE,'Month')
INTO nti_CurMthStrtDte
FROM dual;
SELECT last_day(dbi_SES_DTE)
INTO nti_CurMthEndDte
FROM dual;
SELECT pbt.balance_type_id
INTO l_BalTypId
FROM pay_balance_types pbt
WHERE pbt.balance_name = p_BalNme;
SELECT pbt.balance_type_id
INTO l_BalTypId
FROM pay_balance_types pbt
WHERE pbt.balance_name = p_BalNme;
SELECT min(ptp.start_date)
INTO l_StrtDte
FROM per_time_periods ptp
WHERE ptp.prd_information1 = trc_AsgTxYear
AND ptp.payroll_id = con_PRL_ID;
SELECT max(ptp.end_date)
INTO l_EndDate
FROM per_time_periods ptp
WHERE ptp.prd_information1 = trc_AsgTxYear
AND ptp.payroll_id = con_PRL_ID;
SELECT MAX(ptp.end_date) "EndDate"
INTO l_EndDate
FROM per_time_periods ptp
WHERE ptp.payroll_id = con_PRL_ID
AND ptp.prd_information1 = trc_AsgTxYear
GROUP BY ptp.prd_information1;
SELECT MAX(ptp.end_date) "EndDate"
INTO l_EndDate
FROM per_time_periods ptp
WHERE ptp.payroll_id = con_PRL_ID
AND ptp.prd_information1 = trc_AsgTxYear
GROUP BY ptp.prd_information1;