[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
alien_transaction_id,
person_id,
data_source_type,
tax_year,
income_code,
withholding_rate,
income_code_sub_type,
exemption_code,
maximum_benefit_amount,
retro_lose_ben_amt_flag,
date_benefit_ends,
retro_lose_ben_date_flag,
current_residency_status,
nra_to_ra_date,
target_departure_date,
tax_residence_country_code,
treaty_info_update_date,
nra_exempt_from_fica,
student_exempt_from_fica,
addl_withholding_flag,
addl_withholding_amt,
addl_wthldng_amt_period_type,
personal_exemption,
addl_exemption_allowed,
number_of_days_in_usa,
wthldg_allow_eligible_flag,
treaty_ben_allowed_flag,
treaty_benefits_start_date,
ra_effective_date,
state_code,
state_honors_treaty_flag,
ytd_payments,
ytd_w2_payments,
ytd_w2_withholding,
ytd_withholding_allowance,
ytd_treaty_payments,
ytd_treaty_withheld_amt,
record_source,
visa_type,
j_sub_type,
primary_activity,
non_us_country_code,
citizenship_country_code,
constant_addl_tax,
date_8233_signed,
date_w4_signed,
error_indicator,
prev_er_treaty_benefit_amt,
error_text,
object_version_number ,
current_analysis,
forecast_income_code
from pqp_alien_transaction_data
where alien_transaction_id = p_alien_transaction_id;
select alien_transaction_id,
person_id,
data_source_type,
tax_year,
income_code,
withholding_rate,
income_code_sub_type,
exemption_code,
maximum_benefit_amount,
retro_lose_ben_amt_flag,
date_benefit_ends,
retro_lose_ben_date_flag,
current_residency_status,
nra_to_ra_date,
target_departure_date,
tax_residence_country_code,
treaty_info_update_date,
nra_exempt_from_fica,
student_exempt_from_fica,
addl_withholding_flag,
addl_withholding_amt,
addl_wthldng_amt_period_type,
personal_exemption,
addl_exemption_allowed,
number_of_days_in_usa,
wthldg_allow_eligible_flag,
treaty_ben_allowed_flag,
treaty_benefits_start_date,
ra_effective_date,
state_code,
state_honors_treaty_flag,
ytd_payments,
ytd_w2_payments,
ytd_w2_withholding,
ytd_withholding_allowance,
ytd_treaty_payments,
ytd_treaty_withheld_amt,
record_source,
visa_type,
j_sub_type,
primary_activity,
non_us_country_code,
citizenship_country_code,
constant_addl_tax,
date_8233_signed,
date_w4_signed,
error_indicator,
prev_er_treaty_benefit_amt,
error_text,
object_version_number,
current_analysis,
forecast_income_code
from pqp_alien_transaction_data
where alien_transaction_id = p_alien_transaction_id
for update nowait;
p_treaty_info_update_date in date,
p_nra_exempt_from_fica in varchar2,
p_student_exempt_from_fica in varchar2,
p_addl_withholding_flag in varchar2,
p_addl_withholding_amt in number,
p_addl_wthldng_amt_period_type in varchar2,
p_personal_exemption in number,
p_addl_exemption_allowed in number,
p_number_of_days_in_usa in number,
p_wthldg_allow_eligible_flag in varchar2,
p_treaty_ben_allowed_flag in varchar2,
p_treaty_benefits_start_date in date,
p_ra_effective_date in date,
p_state_code in varchar2,
p_state_honors_treaty_flag in varchar2,
p_ytd_payments in number,
p_ytd_w2_payments in number,
p_ytd_w2_withholding in number,
p_ytd_withholding_allowance in number,
p_ytd_treaty_payments in number,
p_ytd_treaty_withheld_amt in number,
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_constant_addl_tax in number,
p_date_8233_signed in date,
p_date_w4_signed in date,
p_error_indicator in varchar2,
p_prev_er_treaty_benefit_amt in number,
p_error_text in varchar2,
p_object_version_number in number,
p_current_analysis in varchar2,
p_forecast_income_code in varchar2
)
Return g_rec_type is
--
l_rec g_rec_type;
l_rec.treaty_info_update_date := p_treaty_info_update_date;