APPS.PAY_JP_EXTRA_BANK_RULES SQL Statements

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

Line: 51

			select
				segment9 /* account name */
			into
				l_in_account_name
			from
				pay_external_accounts
			where
				external_account_id = p_external_account_id;

Line: 66

	procedure chk_account_name_update
	(
		p_external_account_id   in number,
		p_external_account_id_o in number
	) is
	begin
		--
		if nvl(p_external_account_id, hr_api.g_number) <> nvl(p_external_account_id_o, hr_api.g_number) then
			--
			chk_account_name(p_external_account_id);

Line: 79

	end chk_account_name_update;

Line: 104

	procedure chk_swot_account_name_update
	(
    p_org_information_context in varchar2,
		p_org_information17       in varchar2,
		p_org_information17_o     in varchar2
	) is
	begin
		--
		if nvl(p_org_information17, hr_api.g_varchar2) <> nvl(p_org_information17_o, hr_api.g_varchar2) then
			--
			chk_swot_account_name(p_org_information_context, p_org_information17);

Line: 118

	end chk_swot_account_name_update;