The following lines contain the word 'select', 'insert', 'update' or 'delete':
select assignment_number
into x_assignment_number
from per_assignments_f
-- where assignment_id = assignment_id
where assignment_id = v_assignment_id
AND assignment_type ='E' and rownum < 2; return(x_assignment_number);
select end_date into x_end_date
from per_time_periods
where time_period_id = p_time_period_id;
select full_name into x_person_name
from per_people_f
-- where person_id = person_id
where person_id = v_person_id
and x_end_date BETWEEN effective_start_date and effective_end_date;
select start_date into p_start_date
from per_time_periods
where time_period_id = p_time_period_id;
/*srw.message(1,'Start Date not found for the selected time period id');*/null;
/*srw.message(2,'Too many rows found for the selected time period id');*/null;
SELECT sum(decode(a.dr_cr_flag, 'C',b.distribution_amount,0)) pgdl_Credit_Amount,
sum(decode(a.dr_cr_flag, 'D',b.distribution_amount,0)) pgdl_Debit_Amount,
B.suspense_reason_code FROM PSP_SUMMARY_LINES A,
PSP_PRE_GEN_DIST_LINES_HISTORY B
WHERE A.SUMMARY_LINE_ID = B.SUMMARY_LINE_ID
AND A.STATUS_CODE = 'A' AND B.STATUS_CODE = 'A'
AND a.source_type = p_source_type
and a.source_code = p_source_code
and a.time_period_id = p_time_period_id
and (a.interface_batch_name = p_batch_name or a.interface_batch_name IS NULL)
-- and a.person_id = person_id
-- and a.assignment_id = assignment_id
-- and a.gl_code_combination_id = gl_code_combination_id
and a.person_id = v_person_id
and a.assignment_id = v_assignment_id
and a.gl_code_combination_id = v_gl_code_combination_id
GROUP BY B.suspense_reason_code;
SELECT sum(decode(a.dr_cr_flag, 'C',b.distribution_amount,0)) pgdl_Credit_Amount,
sum(decode(a.dr_cr_flag, 'D',b.distribution_amount,0)) pgdl_Debit_Amount,
B.suspense_reason_code FROM PSP_SUMMARY_LINES A,
PSP_PRE_GEN_DIST_LINES_HISTORY B
WHERE A.SUMMARY_LINE_ID = B.SUMMARY_LINE_ID
AND A.STATUS_CODE = 'A' AND B.STATUS_CODE = 'A'
AND a.source_type = p_source_type
and a.source_code = p_source_code
and a.time_period_id = p_time_period_id
and (a.interface_batch_name = p_batch_name or a.interface_batch_name IS NULL)
-- and a.person_id = person_id
-- and a.assignment_id = assignment_id
-- and A.project_id = project_id
-- and a.task_id = task_id
-- and ( a.award_id = award_id
-- OR (a.award_id IS NULL AND award_id IS NULL))
-- and a.expenditure_type = expenditure_type
-- and a.expenditure_organization_id = expenditure_organization_id
and a.person_id = v_person_id
and a.assignment_id = v_assignment_id
and A.project_id = v_project_id
and a.task_id = v_task_id
and ( a.award_id = v_award_id
-- OR (a.award_id IS NULL AND award_id IS NULL))
OR (a.award_id IS NULL AND v_award_id IS NULL))
and a.expenditure_type = v_expenditure_type
and a.expenditure_organization_id = v_expenditure_organization_id
GROUP BY B.suspense_reason_code;
select name into x_org_name from hr_organization_units where organization_id = TO_NUMBER(x_org_id);
select meaning into x_source_type from psp_lookups
where lookup_type = 'PSP_SOURCE_TYPE' and lookup_code = p_source_type;
select period_name into x_time_period from per_time_periods
where time_period_id = p_time_period_id;
SELECT ppa.name
FROM pa_projects_all ppa
-- WHERE ppa.project_id = project_id;
SELECT pt.task_number
FROM pa_tasks pt
-- WHERE pt.task_id = task_id;
SELECT gma.award_number
FROM gms_awards_all gma
-- WHERE gma.award_id = award_id;
SELECT haou.name
FROM hr_all_organization_units haou
-- WHERE haou.organization_id = expenditure_organization_id;