APPS.GMS_CLIENT_EXTN_BUDGET_WF SQL Statements

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

Line: 86

	SELECT	budget_wf_enabled_flag
	FROM	gms_awards
	WHERE	award_id = p_award_id;

Line: 197

SELECT award_number
     , award_short_name
  FROM gms_awards   -- gms_awards_v -- Bug 4004577
 WHERE award_id	= p_award_id;

Line: 209

SELECT 'x'
FROM   gms_budget_versions
WHERE project_id 		= p_project_id
AND   award_id			= p_award_id
AND   budget_type_code 		= p_budget_type_code
AND   budget_status_code	= 'B';

Line: 219

SELECT 	pm_project_reference
,	segment1
,	name
,	description
,	project_type
,	pm_product_code
,	carrying_out_organization_id
FROM	pa_projects
WHERE   project_id = p_project_id;

Line: 232

SELECT	name
FROM 	hr_organization_units
WHERE	  organization_id = p_carrying_out_organization_id;

Line: 238

SELECT	project_type_class_code
FROM	pa_project_types
WHERE  	project_type = p_project_type;

Line: 244

SELECT 	user_name
FROM	fnd_user
WHERE 	user_id = p_starter_user_id;

Line: 250

SELECT  p.first_name||' '||p.last_name
FROM    fnd_user f, per_people_f p      /*Bug 5122724 */
where p.effective_start_date = (select
min(pp.effective_start_date) from per_all_people_f pp where pp.person_id =
p.person_id and pp.effective_end_date >=trunc(sysdate)) and
((p.employee_number is not null) or (p.npw_number is not null))
and f.user_id = p_starter_user_id
and f.employee_id = p.person_id;

Line: 259

SELECT	e.first_name||' '||e.last_name
FROM	fnd_user f, per_all_people_f e  --pa_employees e  Commented for Bug5067575, SQLId:16329634
WHERE 	f.user_id = p_starter_user_id
AND	f.employee_id = e.person_id
AND	rownum=1;  -- Added for Bug5067575, SQLId:16329634 */

Line: 269

SELECT	pm_budget_reference
,	description
,	change_reason_code
,	budget_entry_method_code
,	pm_product_code
,	labor_quantity
,	raw_cost
,	burdened_cost
,	revenue
,	resource_list_id
,	budget_version_id
,	version_name
FROM 	gms_budget_versions
WHERE	project_id = p_project_id
AND	award_id = p_award_id
AND	budget_type_code = p_budget_type_code
--AND 	budget_status_code = 'S'; -- Modified on 20-May-2000

Line: 291

SELECT	name
,	description
FROM	pa_resource_lists
WHERE 	resource_list_id = p_resource_list_id;

Line: 298

SELECT	budget_type
FROM	pa_budget_types
WHERE	budget_type_code = p_budget_type_code;

Line: 304

SELECT	user_id, user_name
FROM 	gms_notifications_v
WHERE	award_id = p_award_id
AND 	event_type = 'BUDGET_BASELINE';

Line: 312

SELECT sysdate
FROM 	sys.dual;

Line: 587

       SELECT gms_workflow_itemkey_s.nextval
       INTO ItemKey
       from dual;

Line: 936

  SELECT award_number
        ,award_short_name
    FROM gms_awards  -- gms_awards_v -- Bug 4004577
   WHERE award_id = p_award_id;

Line: 947

SELECT 'x'
FROM   gms_budget_versions
WHERE project_id 		= p_project_id
AND   award_id			= p_award_id
AND   budget_type_code 		= p_budget_type_code
AND   budget_status_code	= 'B';

Line: 957

SELECT 	pm_project_reference
,	segment1
,	name
,	description
,	project_type
,	pm_product_code
,	carrying_out_organization_id
FROM	pa_projects
WHERE   project_id = p_project_id;

Line: 970

SELECT	name
FROM 	hr_organization_units
WHERE	  organization_id = p_carrying_out_organization_id;

Line: 976

SELECT	project_type_class_code
FROM	pa_project_types
WHERE  	project_type = p_project_type;

Line: 982

SELECT 	user_name
FROM	fnd_user
WHERE 	user_id = p_starter_user_id;

Line: 988

SELECT  p.first_name||' '||p.last_name /* Bug 5122724 */
FROM    fnd_user f, per_people_f p
where p.effective_start_date = (select
min(pp.effective_start_date) from per_all_people_f pp where pp.person_id =
p.person_id and pp.effective_end_date >=trunc(sysdate)) and
((p.employee_number is not null) or (p.npw_number is not null))
and f.user_id = p_starter_user_id
and f.employee_id = p.person_id;

Line: 997

SELECT	e.first_name||' '||e.last_name
FROM	fnd_user f, per_all_people_f e  --pa_employees e  Commented for Bug5067575, SQLId:16329634
WHERE 	f.user_id = p_starter_user_id
AND	f.employee_id = e.person_id
AND	rownum=1;   -- Added for Bug5067575, SQLId:16329634 */

Line: 1007

SELECT	pm_budget_reference
,	description
,	change_reason_code
,	budget_entry_method_code
,	pm_product_code
,	labor_quantity
,	raw_cost
,	burdened_cost
,	revenue
,	resource_list_id
,	budget_version_id
,	version_name
FROM 	gms_budget_versions
WHERE	project_id = p_project_id
AND	award_id = p_award_id
AND	budget_type_code = p_budget_type_code
--AND 	budget_status_code = 'S'; -- Modified on 20-May-2000

Line: 1029

SELECT	name
,	description
FROM	pa_resource_lists
WHERE 	resource_list_id = p_resource_list_id;

Line: 1036

SELECT	budget_type
FROM	pa_budget_types
WHERE	budget_type_code = p_budget_type_code;

Line: 1042

SELECT	user_id, user_name
FROM 	gms_notifications_v
WHERE	award_id = p_award_id
AND 	event_type = 'BUDGET_BASELINE';

Line: 1050

SELECT sysdate
FROM 	sys.dual;

Line: 1336

       SELECT gms_workflow_itemkey_s.nextval
       INTO ItemKey
       from dual;

Line: 1635

PROCEDURE Select_Budget_Approver
(p_item_type			IN VARCHAR2
, p_item_key  			IN VARCHAR2
, p_project_id			IN NUMBER
, p_award_id 			IN NUMBER
, p_budget_type_code		IN VARCHAR2
, p_workflow_started_by_id  	IN NUMBER
, p_budget_baseliner_id		OUT NOCOPY NUMBER
 )
 --
IS

--
-- Define Your Local Variables Here
--
l_employee_id NUMBER;

Line: 1666

	SELECT	employee_id
	INTO	l_employee_id
	FROM	fnd_user
	WHERE	user_id = p_workflow_started_by_id;

Line: 1674

	SELECT 	person_id
	INTO 	p_budget_baseliner_id
	FROM 	gms_personnel
	WHERE	award_id = p_award_id
   	AND 	award_role = 'AM' -- (AM => Award Manager)
   	AND 	sysdate BETWEEN START_DATE_ACTIVE
   	AND 	NVL(END_DATE_ACTIVE, sysdate);

Line: 1700

  	WF_CORE.CONTEXT('GMS_CLIENT_EXTN_BUDGET_WF','SELECT_BUDGET_APPROVER',
p_item_type, p_item_key);

Line: 1704

END Select_Budget_Approver;