APPS.PAY_DK_TC_DP_UPLOAD SQL Statements

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

Line: 57

      l_datetrack_update_mode        VARCHAR2(80);

Line: 121

	select batch_name from hr_pump_batch_headers where batch_name = p_batch_name;

Line: 125

        SELECT legislation_code, name
        FROM per_business_groups_perf
        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 ='DK'
	AND PAP.NATIONAL_IDENTIFIER = p_cpr
	AND PAA.PERSON_ID = PAP.PERSON_ID
	AND PAA.PRIMARY_FLAG = 'Y'
	AND p_date between  PAA.EFFECTIVE_START_DATE  and PAA.EFFECTIVE_END_DATE
	AND p_date between  PAP.EFFECTIVE_START_DATE  and PAP.EFFECTIVE_END_DATE ;

Line: 147

        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 = 'DK'
	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 p_date between pee.EFFECTIVE_START_DATE and pee.EFFECTIVE_END_DATE
	and p_date between pet.EFFECTIVE_START_DATE and pet.EFFECTIVE_END_DATE
	and p_date between pel.EFFECTIVE_START_DATE and pel.EFFECTIVE_END_DATE
	and p_date between paa.EFFECTIVE_START_DATE and paa.EFFECTIVE_END_DATE ;

Line: 166

         SELECT user_key_value, unique_key_id
	 FROM   hr_pump_batch_line_user_keys
	 WHERE  user_key_value = p_user_key_value;

Line: 172

        SELECT hoi.org_information1, hoi.org_information5
	FROM hr_organization_units hru, hr_organization_information hoi
        WHERE business_group_id = v_bg_id
	and hru.organization_id = hoi.organization_id
        and hoi.ORG_INFORMATION_CONTEXT = 'DK_LEGAL_ENTITY_DETAILS';

Line: 294

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

Line: 443

		   select tl.name
		   into l_input_value_name1
		   from pay_input_values_f_tl tl, pay_input_values_f t
		   where t.input_value_id = tl.input_value_id
		   and t.legislation_code ='DK'
		   and t.name = l_input_value_name1
		   and tl.language ='US';

Line: 453

		   select tl.name
		   into l_input_value_name2
		   from pay_input_values_f_tl tl, pay_input_values_f t
		   where t.input_value_id = tl.input_value_id
		   and t.legislation_code ='DK'
		   and t.name = l_input_value_name2
		   and tl.language ='US';

Line: 463

		   select tl.name
		   into l_input_value_name3
		   from pay_input_values_f_tl tl, pay_input_values_f t
		   where t.input_value_id = tl.input_value_id
		   and t.legislation_code ='DK'
		   and t.name = l_input_value_name3
		   and tl.language ='US';

Line: 472

		   select tl.name
		   into l_input_value_name4
		   from pay_input_values_f_tl tl, pay_input_values_f t
		   where t.input_value_id = tl.input_value_id
		   and t.legislation_code ='DK'
		   and t.name = l_input_value_name4
		   and tl.language ='US';

Line: 481

		   select tl.name
		   into l_input_value_name5
		   from pay_input_values_f_tl tl, pay_input_values_f t
		   where t.input_value_id = tl.input_value_id
		   and t.legislation_code ='DK'
		   and t.name = l_input_value_name5
		   and tl.language ='US';

Line: 490

		   select tl.name
		   into l_input_value_name6
		   from pay_input_values_f_tl tl, pay_input_values_f t
		   where t.input_value_id = tl.input_value_id
		   and t.legislation_code ='DK'
		   and t.name = l_input_value_name6
		   and tl.language ='US';

Line: 499

		   select tl.name
		   into l_input_value_name7
		   from pay_input_values_f_tl tl, pay_input_values_f t
		   where t.input_value_id = tl.input_value_id
		   and t.legislation_code ='DK'
		   and t.name = l_input_value_name7
		   and tl.language ='US';

Line: 507

		   select tl.name
		   into l_input_value_name8
		   from pay_input_values_f_tl tl, pay_input_values_f t
		   where t.input_value_id = tl.input_value_id
		   and t.legislation_code ='DK'
		   and t.name = l_input_value_name8
		   and tl.language ='US';

Line: 529

	           select ELEMENTTL.element_name
		   into l_element_name_tl
		   from PAY_ELEMENT_TYPES_F_TL ELEMENTTL, PAY_ELEMENT_TYPES_F ELEMENT
		   where ELEMENT.ELEMENT_TYPE_ID = ELEMENTTL.ELEMENT_TYPE_ID
		   and ELEMENT.LEGISLATION_CODE ='DK'
		   and ELEMENT.ELEMENT_NAME = 'Tax Card'
		   AND ELEMENTTL.LANGUAGE = USERENV('LANG');

Line: 537

                   select ELEMENTTL.element_name
                   into l_element_name
                   from PAY_ELEMENT_TYPES_F_TL ELEMENTTL, PAY_ELEMENT_TYPES_F ELEMENT
                   where ELEMENT.ELEMENT_TYPE_ID = ELEMENTTL.ELEMENT_TYPE_ID
                   and ELEMENT.LEGISLATION_CODE ='DK'
                   and ELEMENT.ELEMENT_NAME = 'Tax Card'
                   AND ELEMENTTL.LANGUAGE = 'US';

Line: 585

			 l_datetrack_update_mode := 'CORRECTION';

Line: 587

			 l_datetrack_update_mode := 'UPDATE_OVERRIDE';

Line: 589

			 l_datetrack_update_mode := 'UPDATE';

Line: 592

		 --fnd_file.put_line(fnd_file.LOG,'l_datetrack_update_mode : '||l_datetrack_update_mode);

Line: 594

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

Line: 595

	         -- Data Pump procedure called to create batch lines to update element entries
		 -- Bug fix 4215700
	         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(l_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 => NULL
		,P_ENTRY_VALUE11 => NULL
		,P_ENTRY_VALUE12 => NULL
		,P_ENTRY_VALUE13 => NULL
		,P_ENTRY_VALUE14 => NULL
		,P_ENTRY_VALUE15 => NULL
		,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: 636

		-- fnd_file.put_line (fnd_file.LOG,'After hrdpp_update_element_entry.insert_batch_lines 1');

Line: 649

		--DELETE the key
		IF csr_get_user_key%FOUND THEN
			begin
				DELETE FROM HR_PUMP_BATCH_LINE_USER_KEYS WHERE unique_key_id =l_unique_key_id;

Line: 677

	        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(l_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 => NULL
		,P_ENTRY_VALUE11 => NULL
		,P_ENTRY_VALUE12 => NULL
		,P_ENTRY_VALUE13 => NULL
		,P_ENTRY_VALUE14 => NULL
		,P_ENTRY_VALUE15 => NULL
		,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 => 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: 1130

		SELECT  payroll_id
		FROM per_all_assignments_f
		WHERE business_group_id     = p_business_group_id
		AND assignment_id	    = p_assignment_id
		AND p_date
		BETWEEN  effective_start_date  AND effective_end_date ;

Line: 1141

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