The following lines contain the word 'select', 'insert', 'update' or 'delete':
select nvl(imp.same_pa_gl_period,'N')
into l_return_value
from pa_implementations_all imp
where imp.org_id = nvl(p_org_id, -99); /*5368274*/
PROCEDURE Update_PA_Period_Status is
cursor c_periods is
select b.period_name, b.closing_status, b.set_of_books_id ,
b.last_update_date, b.last_updated_by, b.last_update_login /* added bug 3111150 */
from pa_periods a, gl_period_statuses b
where a.period_name = b.period_name
and b.application_id = 8721
and b.set_of_books_id = (select set_of_books_id from pa_implementations)
and a.start_date = b.start_date
and a.end_Date = b.end_date
and a.status <> b.closing_status;
l_LastUpdateDate PA_PLSQL_DATATYPES.DateTabTyp; /* added bug 3111150 */
l_LastUpdatedBy PA_PLSQL_DATATYPES.IdTabTyp; /* added bug 3111150 */
l_LastUpdateLogin PA_PLSQL_DATATYPES.IdTabTyp; /* added bug 3111150 */
l_PeriodTab.Delete;
l_StatusTab.Delete;
l_SobId.Delete;
l_LastUpdateDate.Delete; /* added bug 3111150 */
l_LastUpdatedBy.Delete; /* added bug 3111150 */
l_LastUpdateLogin.Delete; /* added bug 3111150 */
l_LastUpdateDate, /* added bug 3111150 */
l_LastUpdatedBy, /* added bug 3111150 */
l_LastUpdateLogin /* added bug 3111150 */
limit 200;
update pa_periods_all pp
set pp.status = l_StatusTab(i),
pp.last_update_date = l_LastUpdateDate(i), /* added bug 3111150 */
pp.last_updated_by = l_LastUpdatedBy(i), /* added bug 3111150 */
pp.last_update_login = l_LastUpdateLogin(i) /* added bug 3111150 */
where pp.period_name = l_PeriodTab(i)
and pp.org_id in (select imp.org_id
from pa_implementations_all imp
where nvl(imp.same_pa_gl_period,'N') = 'Y'
and imp.set_of_books_id = l_SobId(i));
end Update_PA_Period_Status;
SELECT pa.period_name
FROM pa_periods pa,
gl_period_statuses gl
WHERE gl.set_of_books_id=p_sob_id
AND gl.application_id=8721
AND pa.period_name=gl.period_name
AND pa.status <>gl.closing_status;
SELECT Period_Set_Name,
Accounted_Period_Type
INTO lv_gl_period_set_name,
lv_gl_period_type
FROM gl_sets_of_books
WHERE Set_of_Books_ID=p_sob_id;