The following lines contain the word 'select', 'insert', 'update' or 'delete':
select pbg.security_group_id,
pbg.legislation_code
from per_business_groups_perf pbg
, psp_organization_accounts poa
where poa.organization_account_id = p_organization_account_id
and pbg.business_group_id = poa.business_group_id;
select pbg.legislation_code
from per_business_groups_perf pbg
, psp_organization_accounts poa
where poa.organization_account_id = p_organization_account_id
and pbg.business_group_id = poa.business_group_id;
Procedure chk_non_updateable_args
(p_rec in psp_poa_shd.g_rec_type
) IS
--
l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
End chk_non_updateable_args;
CURSOR date_selection_csr IS
SELECT start_date_active, end_date_active
FROM psp_organization_accounts
WHERE organization_id = p_organization_id
AND account_type_code = p_account_type
AND business_group_id = p_per_business_group_id
AND set_of_books_id = p_gl_set_of_bks_id
AND organization_account_id <> NVL(p_organization_account_id,-999)
AND funding_source_code = p_funding_source_code;
SELECT name
FROM hr_organization_units
WHERE business_group_id = p_per_business_group_id
AND organization_id = p_organization_id
AND trunc(sysdate) between date_from and nvl(date_to,trunc(sysdate));
OPEN date_selection_csr;
fetch date_selection_csr INTO l_start_date_active, l_end_date_active ;
EXIT WHEN date_selection_csr%NOTFOUND;
CLOSE date_selection_csr;
OPEN date_selection_csr;
fetch date_selection_csr INTO l_start_date_active, l_end_date_active ;
EXIT WHEN date_selection_csr%NOTFOUND;
CLOSE date_selection_csr;
OPEN date_selection_csr;
fetch date_selection_csr INTO l_start_date_active, l_end_date_active ;
EXIT WHEN date_selection_csr%NOTFOUND ;
CLOSE date_selection_csr;
SELECT start_date, completion_date
FROM gms_projects_expend_v
WHERE project_id = p_project_id;
SELECT start_date, completion_date
FROM pa_tasks_expend_v
WHERE task_id = p_task_id;
SELECT count(*)
FROM gms_awards_basic_v
WHERE project_id = p_project_id
AND award_id = p_award_id;
SELECT date_from, date_to
FROM pa_all_organizations p,hr_all_organization_units h
WHERE p.organization_id = h.organization_id
AND p.pa_org_use_type = 'EXPENDITURES'
AND h.organization_id = p_expenditure_organization_id
AND h.business_group_id = l_business_group_id
-- AND nvl(p.org_id, -9999) = nvl(l_operating_unit, -9999)
AND ((mo_global.get_current_org_id is NULL and mo_global.check_access(p.org_id) = 'Y')
or ( mo_global.get_current_org_id is NOT NULL and p.org_id = mo_global.get_current_org_id ))
AND NVL(inactive_date,to_date('31/12/4712','DD/MM/RRRR')) > p_start_date_active;
Procedure insert_validate
(p_rec in psp_poa_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate
(p_rec in psp_poa_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'update_validate';
chk_non_updateable_args
(p_rec => p_rec
);
End update_validate;
Procedure delete_validate
(p_rec in psp_poa_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;