APPS.PYJPEXC SQL Statements

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

Line: 56

	select	ppa_owner.time_period_id,
		ppa_user.time_period_id
	into	l_owner_time_period_id,
		l_user_time_period_id
	from	pay_payroll_actions	ppa_user,
		pay_payroll_actions	ppa_owner
	where	ppa_owner.payroll_action_id = p_owner_payroll_action_id
	and	ppa_user.payroll_action_id = p_user_payroll_action_id;

Line: 97

	select	ptp.end_date
	into	p_expiry_information
	from	pay_payroll_actions	ppa,
		per_time_periods	ptp
	where	ppa.payroll_action_id = p_owner_payroll_action_id
	and	ptp.time_period_id = ppa.time_period_id;

Line: 132

	select	least(max(asg.effective_end_date), ptp_owner.end_date)
	into	p_expiry_information
	from	per_all_assignments_f	asg,
		per_time_periods	ptp_owner,
		pay_payroll_actions	ppa_owner,
		pay_assignment_actions	paa_owner
	where	paa_owner.assignment_action_id = p_owner_assignment_action_id
	and	ppa_owner.payroll_action_id = p_owner_payroll_action_id
	and	ptp_owner.time_period_id = ppa_owner.time_period_id
	and	asg.assignment_id = paa_owner.assignment_id
	and	asg.effective_end_date >= p_owner_effective_date
	and	asg.effective_start_date <= ptp_owner.end_date
	and	asg.payroll_id + 0 = ppa_owner.payroll_id
	group by ptp_owner.end_date;

Line: 148

	select	ppa_owner.time_period_id,
		ppa_user.time_period_id
	into	l_owner_time_period_id,
		l_user_time_period_id
	from	per_time_periods	ptp_user,
		pay_payroll_actions	ppa_user,
		per_time_periods	ptp_owner,
		pay_payroll_actions	ppa_owner
	where	ppa_owner.payroll_action_id = p_owner_payroll_action_id
	and	ptp_owner.time_period_id = ppa_owner.time_period_id
	and	ppa_user.payroll_action_id = p_user_payroll_action_id
	and	ptp_user.time_period_id = ppa_user.time_period_id;

Line: 555

		select	fnd_date.canonical_to_date(org_information11)
		from	hr_organization_information
		where	organization_id = p_business_group_id
		and	org_information_context = 'Business Group Information';

Line: 605

		select	business_group_id
		into	l_business_group_id
		from	pay_payroll_actions
		where	payroll_action_id = p_payroll_action_id;