APPS.PQP_DET_SHD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 69

    select
	analyzed_data_details_id,
	analyzed_data_id,
	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,
	nra_exempt_from_ss,
	nra_exempt_from_medicare,
	student_exempt_from_ss,
	student_exempt_from_medicare,
	addl_withholding_flag,
	constant_addl_tax,
	addl_withholding_amt,
	addl_wthldng_amt_period_type,
	personal_exemption,
	addl_exemption_allowed,
	treaty_ben_allowed_flag,
	treaty_benefits_start_date,
	object_version_number,
        retro_loss_notification_sent,
        current_analysis,
        forecast_income_code
    from	pqp_analyzed_alien_details
    where	analyzed_data_details_id = p_analyzed_data_details_id;

Line: 165

    select 	analyzed_data_details_id,
	analyzed_data_id,
	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,
	nra_exempt_from_ss,
	nra_exempt_from_medicare,
	student_exempt_from_ss,
	student_exempt_from_medicare,
	addl_withholding_flag,
	constant_addl_tax,
	addl_withholding_amt,
	addl_wthldng_amt_period_type,
	personal_exemption,
	addl_exemption_allowed,
	treaty_ben_allowed_flag,
	treaty_benefits_start_date,
	object_version_number,
        retro_loss_notification_sent,
        current_analysis,
        forecast_income_code
    from	pqp_analyzed_alien_details
    where	analyzed_data_details_id = p_analyzed_data_details_id
    for	update nowait;