APPS.PAY_JP_DEF_ARCHIVE SQL Statements

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

Line: 33

  select ppa.business_group_id,
         ppa.effective_date,
         ppa.legislative_parameters,
         bg.legislation_code
  from   per_business_groups_perf  bg,
         pay_payroll_actions   ppa
  where  ppa.payroll_action_id = p_payroll_action_id
  and    bg.business_group_id = ppa.business_group_id;

Line: 95

		select	'Y'
		from	pay_jp_def_pact_v
		where	payroll_action_id = p_payroll_action_id;

Line: 99

		select	hoi2.org_information1							tax_office_name,
			hoi1.org_information1							salary_payer_name,
			hoi1.org_information6 || hoi1.org_information7 || hoi1.org_information8	salary_payer_address
		from	hr_organization_information	hoi2,
			hr_organization_information	hoi1,
			hr_all_organization_units	hou
		where	hou.organization_id = g_organization_id
		and	hoi1.organization_id(+) = hou.organization_id
		and	hoi1.org_information_context(+) = 'JP_TAX_SWOT_INFO'
		and	hoi2.organization_id(+) = hou.organization_id
		and	hoi2.org_information_context(+) = 'JP_ITAX_WITHHELD_INFO';

Line: 169

		p_sqlstr := 'select 1 from dual where :payroll_action_id < 0';

Line: 172

'select	distinct per.person_id
from	per_all_people_f	per,
	pay_payroll_actions	ppa
where	ppa.payroll_action_id = :payroll_action_id
and  ppa.business_group_id + 0 = per.business_group_id
order by per.person_id';

Line: 197

		select	asg.assignment_id
		from	per_all_assignments_f	asg,
			per_periods_of_service	pds
		where	pds.person_id
			between p_start_person_id and p_end_person_id
		and	pds.business_group_id + 0 = g_business_group_id
		and	g_effective_date
			between pds.date_start and nvl(pds.final_process_date, g_effective_date)
		and	asg.period_of_service_id = pds.period_of_service_id
		and     asg.primary_flag         = 'Y' /*Added by JSAJJA, as per Bug 8435426*/
		and	g_effective_date
			between asg.effective_start_date and asg.effective_end_date
		and	asg.payroll_id + 0 = g_payroll_id;

Line: 226

				select	pay_assignment_actions_s.nextval
				into	l_assignment_action_id
				from	dual;

Line: 258

	select	assignment_id
	into	l_assignment_id
	from	pay_assignment_actions
	where	assignment_action_id = p_assignment_action_id;

Line: 300

      pay_jp_def_api.update_assact(
        p_validate              => false,
        p_action_information_id => l_action_information_id,
        p_object_version_number => l_object_version_number,
        p_transaction_status    => 'N');