The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
analyzed_data_id,
assignment_id,
data_source,
tax_year,
current_residency_status,
nra_to_ra_date,
target_departure_date,
tax_residence_country_code,
treaty_info_update_date,
number_of_days_in_usa,
withldg_allow_eligible_flag,
ra_effective_date,
record_source,
visa_type,
j_sub_type,
primary_activity,
non_us_country_code,
citizenship_country_code,
object_version_number ,
date_8233_signed,
date_w4_signed
from pqp_analyzed_alien_data
where analyzed_data_id = p_analyzed_data_id;
select analyzed_data_id,
assignment_id,
data_source,
tax_year,
current_residency_status,
nra_to_ra_date,
target_departure_date,
tax_residence_country_code,
treaty_info_update_date,
number_of_days_in_usa,
withldg_allow_eligible_flag,
ra_effective_date,
record_source,
visa_type,
j_sub_type,
primary_activity,
non_us_country_code,
citizenship_country_code,
object_version_number ,
date_8233_signed,
date_w4_signed
from pqp_analyzed_alien_data
where analyzed_data_id = p_analyzed_data_id
for update nowait;
p_treaty_info_update_date in date,
p_number_of_days_in_usa in number,
p_withldg_allow_eligible_flag in varchar2,
p_ra_effective_date in date,
p_record_source in varchar2,
p_visa_type in varchar2,
p_j_sub_type in varchar2,
p_primary_activity in varchar2,
p_non_us_country_code in varchar2,
p_citizenship_country_code in varchar2,
p_object_version_number in number ,
p_date_8233_signed in date ,
p_date_w4_signed in date
)
Return g_rec_type is
--
l_rec g_rec_type;
l_rec.treaty_info_update_date := p_treaty_info_update_date;