APPS.OKC_OUTCOME_INIT_PVT SQL Statements

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

Line: 54

	SELECT opval.profile_option_value profile_value
	FROM   fnd_profile_options op,
	       fnd_profile_option_values opval
	WHERE  op.profile_option_id = opval.profile_option_id
	AND    op.application_id    = opval.application_id
	AND    op.profile_option_name = 'OKC_S_RECIPIENT';

Line: 63

	SELECT opval.profile_option_value profile_value
	FROM   fnd_profile_options op,
	       fnd_profile_option_values opval
	WHERE  op.profile_option_id = opval.profile_option_id
	AND    op.application_id    = opval.application_id
	AND    op.profile_option_name = 'OKC_E_RECIPIENT';

Line: 73

	SELECT f.user_name success_user
	FROM   jtf_rs_resource_extns r,
	       okc_outcomes_v  o,
	       fnd_user f
        WHERE  f.user_id = r.user_id
	AND    o.success_resource_id = r.resource_id
	AND    r.category = 'EMPLOYEE'
	AND    o.id = x;

Line: 85

	SELECT f.user_name failure_user
	FROM   jtf_rs_resource_extns r,
	       okc_outcomes_v  o,
	       fnd_user f
        WHERE  f.user_id = r.user_id
	AND    o.failure_resource_id = r.resource_id
	AND    r.category = 'EMPLOYEE'
	AND    o.id = x;

Line: 349

   SELECT NAME
   FROM OKC_PROCESS_DEFS_V
   WHERE PROCEDURE_NAME = l_procedure_name
   AND PACKAGE_NAME = l_package_name;

Line: 607

   SELECT NAME
   FROM OKC_PROCESS_DEFS_V
   WHERE WF_NAME=l_wf_name
   AND WF_PROCESS_NAME = l_wf_process_name;

Line: 663

	--Select the sequence number into l_item_key
	select okc_wf_outcome_s1.nextval into l_item_key from dual;