APPS.PQP_AAD_SHD SQL Statements

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

Line: 64

    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;

Line: 155

    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;

Line: 236

	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;

Line: 269

  l_rec.treaty_info_update_date          := p_treaty_info_update_date;