[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
effort_report_detail_id
,effort_report_id
,object_version_number
,assignment_id
,assignment_number
,gl_sum_criteria_segment_name
,gl_segment1
,gl_segment2
,gl_segment3
,gl_segment4
,gl_segment5
,gl_segment6
,gl_segment7
,gl_segment8
,gl_segment9
,gl_segment10
,gl_segment11
,gl_segment12
,gl_segment13
,gl_segment14
,gl_segment15
,gl_segment16
,gl_segment17
,gl_segment18
,gl_segment19
,gl_segment20
,gl_segment21
,gl_segment22
,gl_segment23
,gl_segment24
,gl_segment25
,gl_segment26
,gl_segment27
,gl_segment28
,gl_segment29
,gl_segment30
,project_id
,project_number
,project_name
,expenditure_organization_id
,exp_org_name
,expenditure_type
,task_id
,task_number
,task_name
,award_id
,award_number
,award_short_name
,actual_salary_amt
,payroll_percent
,proposed_salary_amt
,proposed_effort_percent
,committed_cost_share
,schedule_start_date
,schedule_end_date
,ame_transaction_id
,investigator_name
,investigator_person_id
,investigator_org_name
,investigator_primary_org_id
,value1
,value2
,value3
,value4
,value5
,value6
,value7
,value8
,value9
,value10
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,grouping_category
from psp_eff_report_details
where effort_report_detail_id = p_effort_report_detail_id;
select
effort_report_detail_id
,effort_report_id
,object_version_number
,assignment_id
,assignment_number
,gl_sum_criteria_segment_name
,gl_segment1
,gl_segment2
,gl_segment3
,gl_segment4
,gl_segment5
,gl_segment6
,gl_segment7
,gl_segment8
,gl_segment9
,gl_segment10
,gl_segment11
,gl_segment12
,gl_segment13
,gl_segment14
,gl_segment15
,gl_segment16
,gl_segment17
,gl_segment18
,gl_segment19
,gl_segment20
,gl_segment21
,gl_segment22
,gl_segment23
,gl_segment24
,gl_segment25
,gl_segment26
,gl_segment27
,gl_segment28
,gl_segment29
,gl_segment30
,project_id
,project_number
,project_name
,expenditure_organization_id
,exp_org_name
,expenditure_type
,task_id
,task_number
,task_name
,award_id
,award_number
,award_short_name
,actual_salary_amt
,payroll_percent
,proposed_salary_amt
,proposed_effort_percent
,committed_cost_share
,schedule_start_date
,schedule_end_date
,ame_transaction_id
,investigator_name
,investigator_person_id
,investigator_org_name
,investigator_primary_org_id
,value1
,value2
,value3
,value4
,value5
,value6
,value7
,value8
,value9
,value10
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,grouping_category
from psp_eff_report_details
where effort_report_detail_id = p_effort_report_detail_id
for update nowait;