APPS.PAY_NL_WW_ADJUSTMENTS SQL Statements

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

Line: 18

SELECT hoi.org_information5 basis_calc_rule
FROM hr_organization_information hoi
WHERE
	Hoi.Organization_id = c_si_provider
AND	hoi.org_information_context = 'NL_SIT'
AND	hoi.org_information4 = c_si_type
AND	c_date between fnd_date.canonical_to_date(hoi.org_information1) AND nvl(fnd_date.canonical_to_date(hoi.org_information2),hr_general.end_of_time);

Line: 55

SELECT hoi.org_information14 gross_net
FROM hr_organization_information hoi
WHERE
	Hoi.Organization_id = c_si_provider
AND	hoi.org_information_context = 'NL_SIT'
AND	hoi.org_information4 = c_si_type
AND	c_date between fnd_date.canonical_to_date(hoi.org_information1) AND NVL(fnd_date.canonical_to_date(hoi.org_information2),hr_general.end_of_time);

Line: 96

SELECT    fnd_number.canonical_to_number(hoi.org_information6) ee_perc,
	      fnd_number.canonical_to_number(hoi.org_information7) er_perc,
	      fnd_number.canonical_to_number(hoi.org_information17) sr_ee_perc,
	      fnd_number.canonical_to_number(hoi.org_information18) sr_er_perc,
	      hoi.org_information3 si_type_name
FROM
	hr_organization_information hoi
WHERE
	hoi.org_information4 = c_si_type
AND	hoi.organization_id = to_number(c_si_provider)
AND	hoi.org_information_context = 'NL_SIT'
AND	c_date_earned BETWEEN fnd_date.canonical_to_date(hoi.org_information1) AND nvl(fnd_date.canonical_to_date(hoi.org_information2),hr_general.end_of_time);

Line: 110

l_delete VARCHAR2(15) := 'Y';

Line: 121

	t1.delete;

Line: 167

			hr_utility.set_location('Ins Get_Adjstment_s : T1 LOOP: SELECTED SIP'||t1(i).si_provider_id||'SIT '||p_source_text,1816);

Line: 173

	-- Delete entries for the SI type after all SIPs are processed
	FOR i in t1.FIRST..t1.LAST LOOP
		IF t1(i).processed_flag = 'Y' AND t1(i).si_type = p_source_text AND t1(i).asg_act_id = p_assignment_action_id THEN
			hr_utility.set_location('Deleted row'||' : SIP'||t1(i).si_provider_id||'SIT '||t1(i).si_type||' Flag ='||t1(i).processed_flag, 1878);

Line: 177

			t1.delete(i);

Line: 204

SELECT 	distinct hr_nl_org_info.GET_SI_PROVIDER_INFO(paa.organization_id, c_si_type, paa.assignment_id) si_provider_id
FROM
	per_all_assignments_f paa,
	per_all_assignments_f paa1,
	pay_assignment_actions pac
WHERE
	pac.assignment_action_id=c_assignment_action_id
AND	paa1.assignment_id = pac.assignment_id
AND	paa1.person_id	   = paa.person_id
AND 	hr_nl_org_info.GET_SI_PROVIDER_INFO(paa.organization_id, c_si_type, paa.assignment_id) <> -1;

Line: 275

select count(distinct(context_value)) into l_si_prov_count
                                      from pay_action_contexts
                                      where context_id IN (select context_id from ff_contexts
                                                          where context_name = 'SOURCE_TEXT2')
                                      and assignment_action_id in (select paa.assignment_action_id from
                                                                   per_all_assignments_f paaf,
                                                                   pay_assignment_Actions paa,
                                                                   pay_payroll_actions ppa,
                                                                   per_time_periods ptp

                                                                   where paaf.person_id = (select distinct(person_id) from per_all_assignments_f
                                                                                           where assignment_id = p_assignment_id)
                                                                   and paaf.assignment_id = paa.assignment_id
                                                                   and paa.payroll_action_id = ppa.payroll_action_id
                                                                   --  and ppa.payroll_id = ptp.payroll_id
                                                                   AND	paa.action_status='C'
                                                                   AND ppa.action_type in ('R','Q','V','B','I')
                                                                   and paa.source_action_id is NOT NULL
                                                                   -- and ptp.time_period_id = ppa.time_period_id
                                                                   and ptp.time_period_id IN (select ppa1.time_period_id
                                                                                             from pay_payroll_actions ppa1, pay_assignment_Actions paa1
                                                                                             where paa1.assignment_action_id = p_assignment_action_id
                                                                                             and paa1.payroll_action_id = ppa1.payroll_action_id)
                                                                    and ppa.date_earned between ptp.start_date and ptp.cut_off_date);