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.PAY_SE_TAX_CARD SQL Statements

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

Line: 72


      l_datetrack_update_mode	VARCHAR2(80);

Line: 131


        SELECT legislation_code, name
        FROM per_business_groups
        WHERE business_group_id = v_bg_id;

Line: 140


        SELECT  PAA.ASSIGNMENT_ID
	FROM per_all_assignments_f PAA
	, per_all_people_f PAP
	, hr_soft_coding_keyflex SCL
	WHERE PAA.BUSINESS_GROUP_ID      = p_business_group_id
	AND PAP.per_information_category ='SE'
	AND PAP.NATIONAL_IDENTIFIER = p_pin
	AND PAA.PERSON_ID = PAP.PERSON_ID
	AND PAA.PRIMARY_FLAG = 'Y'
	AND PAA.soft_coding_keyflex_id = SCL.soft_coding_keyflex_id
	AND fnd_date.canonical_to_date(p_effective_date) between  PAA.EFFECTIVE_START_DATE
							 and	  PAA.EFFECTIVE_END_DATE
	AND fnd_date.canonical_to_date(p_effective_date) between  PAP.EFFECTIVE_START_DATE
							 and	  PAP.EFFECTIVE_END_DATE
	AND SCL.ENABLED_FLAG = 'Y'
	AND SCL.SEGMENT2       in
				(
					select to_char(hoi1.organization_id)
					from HR_ORGANIZATION_UNITS o1
					, HR_ORGANIZATION_INFORMATION hoi1
					, HR_ORGANIZATION_INFORMATION hoi2
					, HR_ORGANIZATION_INFORMATION hoi3
					, HR_ORGANIZATION_INFORMATION hoi4
					WHERE o1.business_group_id = p_business_group_id
					and hoi1.organization_id = o1.organization_id
					and hoi1.org_information1 = 'SE_LOCAL_UNIT'
					and hoi1.org_information_context = 'CLASS'
					and o1.organization_id = hoi2.org_information1
					and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNITS'
					and hoi2.organization_id =  hoi3.organization_id
					and hoi3.ORG_INFORMATION_CONTEXT='CLASS'
					and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
					and hoi4.ORG_INFORMATION_CONTEXT='SE_LEGAL_EMPLOYER_DETAILS'
					and hoi4.organization_id =  hoi3.organization_id
					and fnd_date.canonical_to_date(p_effective_date) >= o1.DATE_FROM
					and fnd_date.canonical_to_date(p_effective_date) <= nvl(o1.DATE_TO, fnd_date.canonical_to_date(p_effective_date))
				)  ;

Line: 182


        SELECT pee.ELEMENT_ENTRY_ID , pet.ELEMENT_NAME, pee.EFFECTIVE_START_DATE,pee.EFFECTIVE_END_DATE
	from pay_element_entries_f pee
	, pay_element_types_f pet
	, pay_element_links_f pel
	, per_all_assignments_f paa
	where pet.ELEMENT_NAME = 'Tax Card'
	and pet.legislation_code = 'SE'
	and pel.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID
	and pee.ELEMENT_LINK_ID = pel.ELEMENT_LINK_ID
	and paa.ASSIGNMENT_ID = pee.ASSIGNMENT_ID
	and pee.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID
	and pee.ASSIGNMENT_ID = p_assignment_id
	and fnd_date.canonical_to_date(p_effective_date) between	pee.EFFECTIVE_START_DATE
							 and		pee.EFFECTIVE_END_DATE
	and fnd_date.canonical_to_date(p_effective_date) between	pet.EFFECTIVE_START_DATE
							 and		pet.EFFECTIVE_END_DATE
	and fnd_date.canonical_to_date(p_effective_date) between	pel.EFFECTIVE_START_DATE
							 and		pel.EFFECTIVE_END_DATE
	and fnd_date.canonical_to_date(p_effective_date) between	paa.EFFECTIVE_START_DATE
							 and		paa.EFFECTIVE_END_DATE ;

Line: 206


		INSERT INTO fnd_sessions(SESSION_ID , EFFECTIVE_DATE )
		VALUES(userenv('SESSIONID'),fnd_date.canonical_to_date(p_effective_date)) ;

Line: 408


		 l_datetrack_update_mode := 'CORRECTION';

Line: 411


		 l_datetrack_update_mode := 'UPDATE_OVERRIDE';

Line: 413


		 l_datetrack_update_mode := 'UPDATE';

Line: 416


	hr_utility.set_location (   '  Datetrack Update Mode:' || l_datetrack_update_mode, 200);

Line: 418


	       -- Data Pump procedure called to create batch lines to update element entries
	       hrdpp_update_element_entry.insert_batch_lines
	        (
		 p_batch_id			=> l_batch_id
		,p_data_pump_business_grp_name 	=> l_bg_name
		,P_DATETRACK_UPDATE_MODE 	=> l_datetrack_update_mode
		,P_EFFECTIVE_DATE		=> fnd_date.canonical_to_date(p_effective_date)
		,P_ENTRY_VALUE1			=> l_entry_value1
		,P_ENTRY_VALUE2			=> l_entry_value2
		,P_ENTRY_VALUE3			=> l_entry_value3
		,P_ENTRY_VALUE4			=> l_entry_value4
		,P_ENTRY_VALUE5			=> l_entry_value5
		,P_ENTRY_VALUE6			=> l_entry_value6
		,P_ENTRY_VALUE7			=> l_entry_value7
		,P_ENTRY_VALUE8			=> l_entry_value8
		,P_ENTRY_VALUE9			=> l_entry_value9
		,P_ENTRY_VALUE10		=> l_entry_value10
		,P_ENTRY_VALUE11	 	=> l_entry_value11
		,P_ENTRY_VALUE12		=> l_entry_value12
		,P_ENTRY_VALUE13		=> l_entry_value13
		,P_ENTRY_VALUE14	 	=> l_entry_value14
		,P_ENTRY_VALUE15		=> l_entry_value15
		,P_ELEMENT_ENTRY_USER_KEY 	=> L_EE_USER_KEY
		,P_ELEMENT_NAME			=> L_ELEMENT_NAME
		,P_LANGUAGE_CODE		=> 'US'
		,P_INPUT_VALUE_NAME1		=> l_input_value_name1
		,P_INPUT_VALUE_NAME2		=> l_input_value_name2
		,P_INPUT_VALUE_NAME3		=> l_input_value_name3
		,P_INPUT_VALUE_NAME4		=> l_input_value_name4
		,P_INPUT_VALUE_NAME5		=> l_input_value_name5
		,P_INPUT_VALUE_NAME6		=> l_input_value_name6
		,P_INPUT_VALUE_NAME7		=> l_input_value_name7
		,P_INPUT_VALUE_NAME8		=> l_input_value_name8
		,P_INPUT_VALUE_NAME9		=> l_input_value_name9
		,P_INPUT_VALUE_NAME10		=> l_input_value_name10
		,P_INPUT_VALUE_NAME11		=> l_input_value_name11
		,P_INPUT_VALUE_NAME12		=> l_input_value_name12
		,P_INPUT_VALUE_NAME13		=> l_input_value_name13
		,P_INPUT_VALUE_NAME14		=> l_input_value_name14
		,P_INPUT_VALUE_NAME15		=> l_input_value_name15);

Line: 472


			hr_utility.set_location (   '  User Key deleted: ' , 201);

Line: 473


			DELETE FROM HR_PUMP_BATCH_LINE_USER_KEYS WHERE unique_key_id =l_unique_key_id;

Line: 493


	       hrdpp_create_element_entry.insert_batch_lines
	        (p_batch_id			=> l_batch_id
		,p_data_pump_business_grp_name 	=> l_bg_name
		,P_EFFECTIVE_DATE		=> fnd_date.canonical_to_date(p_effective_date)
		,P_ENTRY_TYPE			=>  'E'
		,P_CREATOR_TYPE			=>  'F'
		,P_ENTRY_VALUE1			=> l_entry_value1
		,P_ENTRY_VALUE2			=> l_entry_value2
		,P_ENTRY_VALUE3			=> l_entry_value3
		,P_ENTRY_VALUE4			=> l_entry_value4
		,P_ENTRY_VALUE5			=> l_entry_value5
		,P_ENTRY_VALUE6			=> l_entry_value6
		,P_ENTRY_VALUE7			=> l_entry_value7
		,P_ENTRY_VALUE8			=> l_entry_value8
		,P_ENTRY_VALUE9			=> l_entry_value9
		,P_ENTRY_VALUE10		=> l_entry_value10
		,P_ENTRY_VALUE11		=> l_entry_value11
		,P_ENTRY_VALUE12		=> l_entry_value12
		,P_ENTRY_VALUE13		=> l_entry_value13
		,P_ENTRY_VALUE14		=> l_entry_value14
		,P_ENTRY_VALUE15		=> l_entry_value15
		,P_ELEMENT_ENTRY_USER_KEY	 => L_EE_USER_KEY
		,P_ASSIGNMENT_USER_KEY 		=> L_ASSIGNMENT_USER_KEY
		,P_ELEMENT_LINK_USER_KEY 	=> L_ELEMENT_LINK_USER_KEY
		,P_ELEMENT_NAME			=> 'Tax Card'
		,P_LANGUAGE_CODE		=> 'US'
		,P_INPUT_VALUE_NAME1		=> l_input_value_name1
		,P_INPUT_VALUE_NAME2		=> l_input_value_name2
		,P_INPUT_VALUE_NAME3		=> l_input_value_name3
		,P_INPUT_VALUE_NAME4		=> l_input_value_name4
		,P_INPUT_VALUE_NAME5		=> l_input_value_name5
		,P_INPUT_VALUE_NAME6		=> l_input_value_name6
		,P_INPUT_VALUE_NAME7		=> l_input_value_name7
		,P_INPUT_VALUE_NAME8		=> l_input_value_name8
		,P_INPUT_VALUE_NAME9		=> l_input_value_name9
		,P_INPUT_VALUE_NAME10		=> l_input_value_name10
		,P_INPUT_VALUE_NAME11		=> l_input_value_name11
		,P_INPUT_VALUE_NAME12		=> l_input_value_name12
		,P_INPUT_VALUE_NAME13		=> l_input_value_name13
		,P_INPUT_VALUE_NAME14		=> l_input_value_name14
		,P_INPUT_VALUE_NAME15		=> l_input_value_name15);

Line: 910


	   select unique_key_id
	   into   l_id
	   from   hr_pump_batch_line_user_keys
	   where  user_key_value = p_user_key_value;

Line: 950


		SELECT  payroll_id
		FROM per_all_assignments_f
		WHERE business_group_id     = p_business_group_id
		AND assignment_id	    = p_assignment_id
		AND fnd_date.canonical_to_date(p_effective_date)
		BETWEEN  effective_start_date  AND effective_end_date ;

Line: 962


		SELECT element.element_link_id
		FROM pay_paywsmee_elements_lov element
		WHERE element.assignment_id = p_assignment_id
		AND  element.element_name = p_element_name
		AND (element.business_group_id = p_business_group_id
		OR (element.business_group_id is null and element.legislation_code = 'SE'))
		AND ( element.multiple_entries_allowed_flag = 'Y'
		OR (element.normal_exists = 'N'
		OR (p_payroll_id is not null
		AND ( (element.additional_entry_allowed_flag = 'Y'
		AND element.additional_exists = 'N' )
		OR (element.overridden = 'N' and element.adjusted = 'N' ))))) ;