eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PY_SE_TAX_CARD SQL Statements

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

Line: 54


  PROCEDURE insert_taxcard (
   	p_legislation_code		IN 	VARCHAR2
	,p_effective_date		IN	DATE
	,p_assignment_id		IN	VARCHAR2
	,p_person_id			IN	VARCHAR2
	,p_business_group_id	IN	VARCHAR2
	,p_tax_percentage		IN	NUMBER   	DEFAULT NULL
	,p_tax_free_threshold	IN	NUMBER		DEFAULT NULL
	,p_calculation_sum		IN	NUMBER		DEFAULT NULL
	,p_method_of_receipt	IN	VARCHAR2	DEFAULT NULL
	,p_tax_column			IN	VARCHAR2	DEFAULT NULL
	,p_tax_card_type		IN	VARCHAR2	DEFAULT NULL
	,p_tax_table_number		IN	VARCHAR2	DEFAULT NULL
	,p_calculation_code		IN	VARCHAR2	DEFAULT NULL
	) IS
	-- Declarations here
	l_start_date		DATE;

Line: 97


		SELECT
		et.element_type_id,
		MIN(DECODE(iv.name, 'Tax Percentage', iv.input_value_id, null)) iv1,
		MIN(DECODE(iv.name, 'Tax Free Threshold', iv.input_value_id, null)) iv2,
		MIN(DECODE(iv.name, 'Calculation Sum', iv.input_value_id, null)) iv3,
		MIN(DECODE(iv.name, 'Method of Receipt', iv.input_value_id, null)) iv4,
		MIN(DECODE(iv.name, 'Tax Column', iv.input_value_id, null)) iv5,
		MIN(DECODE(iv.name, 'Tax Card Type', iv.input_value_id, null)) iv6,
		MIN(DECODE(iv.name, 'Tax Table Number', iv.input_value_id, null)) iv7,
		MIN(DECODE(iv.name, 'Calculation Code', iv.input_value_id, null)) iv8
		FROM
		pay_element_types_f et,
		pay_input_values_f iv
		WHERE et.element_name = 'Tax Card'
		AND et.legislation_code = 'SE'
		AND et.business_group_id is null
		AND fnd_date.canonical_to_date(p_effective_date) BETWEEN
			et.effective_start_date AND et.effective_end_date
		AND iv.element_type_id = et.element_type_id
		AND fnd_date.canonical_to_date(p_effective_date)
			BETWEEN iv.effective_start_date AND iv.effective_end_date
		GROUP BY
			et.element_type_id;

Line: 121


	l_proc    varchar2(72) := g_package||'insert_taxcard';

Line: 125


	select session_id
	from fnd_sessions
	where session_id = userenv('sessionid')
	and effective_date = p_effective_date;

Line: 136


		--Insert row into fnd_Sessions table.
		OPEN  CSR_CHECK_FND_SESSION;

Line: 141


              INSERT INTO fnd_sessions(session_id, effective_date) VALUES(userenv('sessionid'), p_effective_date);

Line: 250


		-- insert records into pay_element_entries_f and pay_element_entry_values_f
		pay_element_entry_api.create_element_entry
		(p_effective_date		=> p_effective_date
		,p_business_group_id	=> p_business_group_id
		,p_assignment_id		=> p_assignment_id
		,p_element_link_id		=> l_element_link_id
		,p_entry_type 			=> 'E'
		,p_input_value_id1		=> l_input_value_id1
		,p_input_value_id2		=> l_input_value_id2
		,p_input_value_id3		=> l_input_value_id3
		,p_input_value_id4		=> l_input_value_id4
		,p_input_value_id5		=> l_input_value_id5
		,p_input_value_id6		=> l_input_value_id6
		,p_input_value_id7		=> l_input_value_id7
		,p_input_value_id8		=> l_input_value_id8
		,p_entry_value1 		=> l_tax_percentage
		,p_entry_value2     	=> l_tax_free_threshold
		,p_entry_value3		    => l_calculation_sum
		,p_entry_value4	        => l_method_of_receipt
		,p_entry_value5			=> l_tax_column
		,p_entry_value6		    => p_tax_card_type
		,p_entry_value7	    	=> l_tax_table_number
		,p_entry_value8 		=> l_calculation_code
		,p_effective_start_date	=> l_start_date
		,p_effective_end_date	=> l_end_date
		,p_element_entry_id		=> l_element_entry_id
		,p_object_version_number => l_ovn
		,p_create_warning		=> l_warning
		);

Line: 287


	END insert_taxcard;

Line: 355


  PROCEDURE update_taxcard (
	p_legislation_code		IN	VARCHAR2
	,p_effective_date		IN	DATE
	,p_assignment_id		IN	VARCHAR2
	,p_person_id			IN	VARCHAR2
	,p_business_group_id	IN	VARCHAR2
	,p_tax_percentage		IN	NUMBER   	DEFAULT NULL
	,p_tax_free_threshold	IN	NUMBER		DEFAULT NULL
	,p_calculation_sum		IN	NUMBER		DEFAULT NULL
	,p_method_of_receipt	IN	VARCHAR2	DEFAULT NULL
	,p_tax_column			IN	VARCHAR2	DEFAULT NULL
	,p_tax_card_type		IN	VARCHAR2	DEFAULT NULL
	,p_tax_table_number		IN	VARCHAR2	DEFAULT NULL
	,p_calculation_code		IN	VARCHAR2	DEFAULT NULL
	,p_element_entry_id		IN	VARCHAR2
	,p_element_link_id		IN	VARCHAR2
	,p_object_version_number	IN	VARCHAR2
	,p_input_value_id1		IN	VARCHAR2	DEFAULT NULL
	,p_input_value_id2		IN	VARCHAR2	DEFAULT NULL
	,p_input_value_id3		IN	VARCHAR2	DEFAULT NULL
	,p_input_value_id4		IN	VARCHAR2	DEFAULT NULL
	,p_input_value_id5		IN	VARCHAR2	DEFAULT NULL
	,p_input_value_id6		IN	VARCHAR2	DEFAULT NULL
	,p_input_value_id7		IN	VARCHAR2	DEFAULT NULL
	,p_input_value_id8		IN	VARCHAR2	DEFAULT NULL
	,p_datetrack_update_mode	IN	VARCHAR2	DEFAULT NULL
	) IS

	l_start_date		DATE;

Line: 397


	l_proc    varchar2(72) := g_package||'update_taxcard';

Line: 491


	-- insert records into pay_element_entries_f and pay_element_entry_values_f

	pay_element_entry_api.update_element_entry
	     (p_validate			=>  FALSE
	     ,p_object_version_number		=>  l_ovn
	     ,p_update_warning			=>  l_warning
	     ,p_datetrack_update_mode		=>  p_datetrack_update_mode
	     ,p_effective_date			=>  p_effective_date
	     ,p_business_group_id		=> p_business_group_id
	     ,p_input_value_id1			=> p_input_value_id1
	     ,p_input_value_id2			=> p_input_value_id2
	     ,p_input_value_id3			=> p_input_value_id3
	     ,p_input_value_id4			=> p_input_value_id4
	     ,p_input_value_id5			=> p_input_value_id5
	     ,p_input_value_id6			=> p_input_value_id6
	     ,p_input_value_id7			=> p_input_value_id7
	     ,p_input_value_id8			=> p_input_value_id8
	     ,p_entry_value1		    => l_tax_percentage
	     ,p_entry_value2   		    => l_tax_free_threshold
	     ,p_entry_value3		    => l_calculation_sum
	     ,p_entry_value4		    => l_method_of_receipt
	     ,p_entry_value5			=> l_tax_column
	     ,p_entry_value6		    => p_tax_card_type
         ,p_entry_value7		    => l_tax_table_number
	     ,p_entry_value8	  	    => l_calculation_code
	     ,p_effective_start_date	=> l_start_date
	     ,p_effective_end_date		=> l_end_date
	     ,p_element_entry_id		=> l_element_entry_id
	     ,p_cost_allocation_keyflex_id	=> hr_api.g_number
	     ,p_updating_action_id		=> hr_api.g_number
	     ,p_original_entry_id		=> hr_api.g_number
	     ,p_creator_type			=> hr_api.g_varchar2
	     ,p_comment_id			=> hr_api.g_number
	     ,p_creator_id			=> hr_api.g_number
	     ,p_reason				=> hr_api.g_varchar2
	     ,p_subpriority			=> hr_api.g_number
	     ,p_date_earned			=> hr_api.g_date
	     ,p_personal_payment_method_id	=> hr_api.g_number
	     ,p_attribute_category		=> hr_api.g_varchar2
	     ,p_attribute1			=> hr_api.g_varchar2
	     ,p_attribute2			=> hr_api.g_varchar2
	     ,p_attribute3			=> hr_api.g_varchar2
	     ,p_attribute4			=> hr_api.g_varchar2
	     ,p_attribute5			=> hr_api.g_varchar2
	     ,p_attribute6			=> hr_api.g_varchar2
	     ,p_attribute7			=> hr_api.g_varchar2
	     ,p_attribute8			=> hr_api.g_varchar2
	     ,p_attribute9			=> hr_api.g_varchar2
	     ,p_attribute10			=> hr_api.g_varchar2
	     ,p_attribute11			=> hr_api.g_varchar2
	     ,p_attribute12			=> hr_api.g_varchar2
	     ,p_attribute13			=> hr_api.g_varchar2
	     ,p_attribute14			=> hr_api.g_varchar2
	     ,p_attribute15			=> hr_api.g_varchar2
	     ,p_attribute16			=> hr_api.g_varchar2
	     ,p_attribute17			=> hr_api.g_varchar2
	     ,p_attribute18			=> hr_api.g_varchar2
	     ,p_attribute19			=> hr_api.g_varchar2
	     ,p_attribute20			=> hr_api.g_varchar2
	     ,p_updating_action_type		=> hr_api.g_varchar2
	     ,p_entry_information_category	=> hr_api.g_varchar2
	     ,p_entry_information1		=> hr_api.g_varchar2
	     ,p_entry_information2		=> hr_api.g_varchar2
	     ,p_entry_information3		=> hr_api.g_varchar2
	     ,p_entry_information4		=> hr_api.g_varchar2
	     ,p_entry_information5		=> hr_api.g_varchar2
	     ,p_entry_information6		=> hr_api.g_varchar2
	     ,p_entry_information7		=> hr_api.g_varchar2
	     ,p_entry_information8		=> hr_api.g_varchar2
	     ,p_entry_information9		=> hr_api.g_varchar2
	     ,p_entry_information10		=> hr_api.g_varchar2
	     ,p_entry_information11		=> hr_api.g_varchar2
	     ,p_entry_information12		=> hr_api.g_varchar2
	     ,p_entry_information13		=> hr_api.g_varchar2
	     ,p_entry_information14		=> hr_api.g_varchar2
	     ,p_entry_information15		=> hr_api.g_varchar2
	     ,p_entry_information16		=> hr_api.g_varchar2
	     ,p_entry_information17		=> hr_api.g_varchar2
	     ,p_entry_information18		=> hr_api.g_varchar2
	     ,p_entry_information19		=> hr_api.g_varchar2
	     ,p_entry_information20		=> hr_api.g_varchar2
	     ,p_entry_information21		=> hr_api.g_varchar2
	     ,p_entry_information22		=> hr_api.g_varchar2
	     ,p_entry_information23		=> hr_api.g_varchar2
	     ,p_entry_information24		=> hr_api.g_varchar2
	     ,p_entry_information25		=> hr_api.g_varchar2
	     ,p_entry_information26		=> hr_api.g_varchar2
	     ,p_entry_information27		=> hr_api.g_varchar2
	     ,p_entry_information28		=> hr_api.g_varchar2
	     ,p_entry_information29		=> hr_api.g_varchar2
	     ,p_entry_information30		=> hr_api.g_varchar2);

Line: 591


	END update_taxcard;

Line: 642


		 ,p_update			OUT NOCOPY BOOLEAN
		 ,p_update_override		OUT NOCOPY BOOLEAN
		 ,p_update_change_insert	OUT NOCOPY BOOLEAN
		 ,p_correction_start_date	OUT NOCOPY DATE
		 ,p_correction_end_date		OUT NOCOPY DATE
		 ,p_update_start_date		OUT NOCOPY DATE
		 ,p_update_end_date		OUT NOCOPY DATE
		 ,p_override_start_date		OUT NOCOPY DATE
		 ,p_override_end_date		OUT NOCOPY DATE
		 ,p_upd_chg_start_date		OUT NOCOPY DATE
		 ,p_upd_chg_end_date		OUT NOCOPY DATE
		 ) IS

	l_proc 	varchar2(72) := g_package||'find_dt_upd_modes';

Line: 670


		,p_update			=> p_update
		,p_update_override		=> p_update_override
		,p_update_change_insert		=> p_update_change_insert
		,p_correction_start_date	=> p_correction_start_date
		,p_correction_end_date		=> p_correction_end_date
		,p_update_start_date		=> p_update_start_date
		,p_update_end_date		=> p_update_end_date
		,p_override_start_date		=> p_override_start_date
		,p_override_end_date		=> p_override_end_date
		,p_upd_chg_start_date		=> p_upd_chg_start_date
		,p_upd_chg_end_date		=> p_upd_chg_end_date);

Line: 727


		SELECT global_value
		FROM ff_globals_f
		WHERE global_name = p_global_name
		AND legislation_code = p_legislation_code
		AND business_group_id  IS NULL
		AND p_effective_date BETWEEN effective_start_date AND effective_end_date;