APPS.PAY_JP_DEF_ARCHIVE SQL Statements

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

Line: 29

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

		select	'Y'
		from	pay_jp_def_pact_v
		where	payroll_action_id = p_payroll_action_id;

Line: 87

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

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

Line: 160

'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: 185

		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	g_effective_date
			between asg.effective_start_date and asg.effective_end_date
		and	asg.payroll_id + 0 = g_payroll_id;

Line: 213

				select	pay_assignment_actions_s.nextval
				into	l_assignment_action_id
				from	dual;

Line: 244

	select	assignment_id
	into	l_assignment_id
	from	pay_assignment_actions
	where	assignment_action_id = p_assignment_action_id;