APPS.PAY_JP_CREATE_CMA_PKG SQL Statements

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

Line: 29

procedure insert_session(p_effective_date in date)
is
begin
	insert into fnd_sessions(
		session_id,
		effective_date)
	values(	userenv('sessionid'),
		p_effective_date);

Line: 38

end insert_session;

Line: 42

procedure delete_session
is
begin
	delete
	from	fnd_sessions
	where	session_id = userenv('sessionid');

Line: 49

end delete_session;

Line: 133

	-- 1. When element entry exists and one of input values to be transfered needs to be updated.
	-- 2. When element entry does not exist and p_create_entry_if_not_exist is set to 'Y'.
	--
--	if (l_ee_rec.element_entry_id is not null)
--	or (p_create_entry_if_not_exist = 'Y') then

	--
	-- Derive Non-resident flag as of Upload Date
	--
	l_non_res_date := pay_jp_balance_pkg.get_entry_value_date(
				p_input_value_id	=> g_non_res_date_iv_id,
				p_assignment_id		=> p_assignment_id,
				p_effective_date	=> p_upload_date);

Line: 231

				-- If element does not exist, "Insert" mode.
				-- Also output all entry values to be transfered.
				--
				l_change_type	:= 'I';

Line: 396

	insert_session(l_payment_date);

Line: 427

	select	to_number(global_value)
	into	g_non_taxable_limit_1mth
	from	ff_globals_f
	where
	---- bug 4029525 ----
	--	l_effective_date
		l_payment_date
	---------------------
			between effective_start_date and effective_end_date
	and		global_name = c_non_taxable_GlbVal_name;

Line: 478

	-- When no batch lines are created, delete batch header and set message as errbuf.
	--
	if pay_jp_bee_utility_pkg.g_num_of_outs = 0 then
		hr_utility.trace('BEE Header deleted');

Line: 483

		pay_batch_element_entry_api.delete_batch_header(
			p_validate		=> false,
			p_batch_id		=> l_batch_id,
			p_object_version_number	=> l_batch_ovn);

Line: 502

	delete_session;