[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
,p_receipt_last_updated IN varchar2
,p_alt_element_id IN number
,p_alt_archive_ref IN varchar2
,p_curr_state IN varchar2
,p_next_state IN varchar2
,p_object_version_number IN number
,p_tfr_information_category IN varchar2
,p_tfr_information1 IN varchar2
,p_tfr_information2 IN varchar2
,p_tfr_information3 IN varchar2
,p_tfr_information4 IN varchar2
,p_tfr_information5 IN varchar2
,p_tfr_information6 IN varchar2
,p_tfr_information7 IN varchar2
,p_tfr_information8 IN varchar2
,p_tfr_information9 IN varchar2
,p_tfr_information10 IN varchar2
,p_tfr_information11 IN varchar2
,p_tfr_information12 IN varchar2
,p_tfr_information13 IN varchar2
,p_tfr_information14 IN varchar2
,p_tfr_information15 IN varchar2
,p_tfr_information16 IN varchar2
,p_tfr_information17 IN varchar2
,p_tfr_information18 IN varchar2
,p_tfr_information19 IN varchar2
,p_tfr_information20 IN varchar2) RETURN g_rec_type IS
l_rec g_rec_type;
SELECT transfer_id
,transfer_status
,concurrent_request_id
,payroll_action_id
,report_name
,run_effective_date
,shipment_reference
,organization_id
,business_group_id
,receipt_id
,receipt_status
,receipt_text
,receipt_last_updated
,alt_element_id
,alt_archive_ref
,curr_state
,next_state
,tfr_information_category
,tfr_information1
,tfr_information2
,tfr_information3
,tfr_information4
,tfr_information5
,tfr_information6
,tfr_information7
,tfr_information8
,tfr_information9
,tfr_information10
,tfr_information11
,tfr_information12
,tfr_information13
,tfr_information14
,tfr_information15
,tfr_information16
,tfr_information17
,tfr_information18
,tfr_information19
,tfr_information20
,object_version_number
FROM pay_no_altinn_transfers
WHERE transfer_id = p_transfer_id;
SELECT transfer_id
,transfer_status
,concurrent_request_id
,payroll_action_id
,report_name
,run_effective_date
,shipment_reference
,organization_id
,business_group_id
,receipt_id
,receipt_status
,receipt_text
,receipt_last_updated
,alt_element_id
,alt_archive_ref
,curr_state
,next_state
,object_version_number
,tfr_information_category
,tfr_information1
,tfr_information2
,tfr_information3
,tfr_information4
,tfr_information5
,tfr_information6
,tfr_information7
,tfr_information8
,tfr_information9
,tfr_information10
,tfr_information11
,tfr_information12
,tfr_information13
,tfr_information14
,tfr_information15
,tfr_information16
,tfr_information17
,tfr_information18
,tfr_information19
,tfr_information20
FROM pay_no_altinn_transfers
WHERE transfer_id = p_transfer_id
FOR UPDATE NOWAIT;