DBA Data[Home] [Help]

APPS.PAY_BACKPAY_SETS_PKG SQL Statements

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

Line: 20

			select	null
			into	l_null
			from	sys.dual
			where	not exists (
				select 	null
				from	pay_backpay_sets s
				where	s.business_group_id + 0	= P_BUS_GRP_ID
				and	s.backpay_set_name	= P_SET_NAME
				and	s.backpay_set_id	<> P_SET_ID);
Line: 40

			select	null
			into	l_null
			from	sys.dual
			where	not exists (
				select 	null
				from	pay_backpay_sets s
				where	s.business_group_id + 0	= P_BUS_GRP_ID
				and	s.backpay_set_name	= P_SET_NAME);