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_NO_TC_DP_UPLOAD SQL Statements

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

Line: 67


      l_datetrack_update_mode        VARCHAR2(80);

Line: 125


        SELECT legislation_code, name
        FROM per_business_groups
        WHERE business_group_id = v_bg_id;

Line: 134


        SELECT  PAA.ASSIGNMENT_ID
	FROM per_all_assignments_f PAA
	, per_all_people_f PAP
	WHERE PAA.BUSINESS_GROUP_ID      = p_business_group_id
	AND PAP.per_information_category ='NO'
	AND PAP.NATIONAL_IDENTIFIER = p_ni
	AND PAA.PERSON_ID = PAP.PERSON_ID
	AND PAA.PRIMARY_FLAG = 'Y'
	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 ;

Line: 149


        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 = 'NO'
	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: 168


         SELECT user_key_value, unique_key_id
	 FROM   hr_pump_batch_line_user_keys
	 WHERE  user_key_value = p_user_key_value;

Line: 181


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

Line: 412


	 l_datetrack_update_mode := 'CORRECTION';

Line: 415


	 l_datetrack_update_mode := 'UPDATE_OVERRIDE';

Line: 417


	 l_datetrack_update_mode := 'UPDATE';

Line: 420


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

Line: 423


	       -- 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: 479


	     DELETE FROM HR_PUMP_BATCH_LINE_USER_KEYS WHERE unique_key_id =l_unique_key_id;

Line: 501


	       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: 997


		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: 1009


		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 = 'NO'))
		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' ))))) ;