APPS.PA_CLIENT_EXTN_BUDGET_WF SQL Statements

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

Line: 88

	SELECT	pt.enable_budget_wf_flag
	FROM		pa_projects p, pa_project_types pt
	WHERE		p.project_id = p_project_id
	AND		p.project_type = pt.project_type;

Line: 95

	SELECT	b.enable_wf_flag
	FROM 		pa_budget_types b
	WHERE		b.budget_type_code = p_budget_type_code;

Line: 101

	SELECT	pl.enable_wf_flag
	FROM 		pa_fin_plan_types_b pl
	WHERE	pl.fin_plan_type_id = 	p_fin_plan_type_id;

Line: 313

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

Line: 326

SELECT	name
FROM 	hr_organization_units
WHERE	  organization_id = p_carrying_out_organization_id;

Line: 332

SELECT	project_type_class_code
FROM	pa_project_types
WHERE  	project_type = p_project_type;

Line: 338

SELECT 	user_name
FROM	fnd_user
WHERE 	user_id = p_starter_user_id;

Line: 344

SELECT	e.first_name||' '||e.last_name
FROM	fnd_user f, per_all_people_f e
WHERE 	f.user_id = p_starter_user_id
AND		f.employee_id = e.person_id
AND     e.effective_start_date = (SELECT MIN(pap.effective_start_date)               --Bug 5102146.
                                  FROM   per_all_people_f pap
                                  WHERE  pap.person_id = e.person_id
                                  AND    pap.effective_end_date >= TRUNC(SYSDATE));

Line: 355

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
        ,version_name
        ,budget_type_code
        ,fin_plan_type_id
        ,version_type
FROM 	pa_budget_versions
WHERE	budget_version_id = p_draft_version_id
AND 	budget_status_code = 'S';

Line: 375

SELECT	name
,	description
FROM	pa_resource_lists
WHERE 	resource_list_id = p_resource_list_id;

Line: 382

SELECT	budget_type
FROM	pa_budget_types
WHERE	  budget_type_code = p_budget_type_code;

Line: 388

SELECT sysdate
FROM 	dual;

Line: 393

SELECT name, plan_class_code --Bug 6691634
FROM   pa_fin_plan_types_vl fpt
WHERE  fpt.fin_plan_type_id  = l_fin_plan_type_id;

Line: 400

SELECT l1.meaning
       , l2.meaning
FROM   pa_proj_fp_options fo
       , pa_lookups l1
       , pa_lookups l2
WHERE  fo.fin_plan_version_id = p_draft_version_id
AND    l1.lookup_code = decode(l_version_type, 'COST', fo.cost_fin_plan_level_code
                                 ,'REVENUE', fo.revenue_fin_plan_level_code
                                   ,'ALL', fo.all_fin_plan_level_code, NULL)
AND    l1.lookup_type = 'BUDGET ENTRY LEVEL'
AND    l2.lookup_code = decode(l_version_type, 'COST', fo.cost_time_phased_code
                                 ,'REVENUE', fo.revenue_time_phased_code
                                   ,'ALL', fo.all_time_phased_code, NULL)
AND    l2.lookup_type = 'BUDGET TIME PHASED TYPE';

Line: 417

SELECT budget_entry_method
FROM   pa_budget_entry_methods m
WHERE  m.budget_entry_method_code = l_budget_entry_method_code;

Line: 423

SELECT MEANING
FROM PA_LOOKUPS
WHERE LOOKUP_CODE = l_budget_change_reason_code
AND LOOKUP_TYPE = 'BUDGET CHANGE REASON'; -- Bug #14623649

Line: 651

       SELECT pa_workflow_itemkey_s.nextval
       INTO itemkey
       from dual;

Line: 1026

PROCEDURE Select_Budget_Approver
(p_item_type			IN   	VARCHAR2
, p_item_key  			IN   	VARCHAR2
, p_project_id			IN      NUMBER
, p_budget_type_code		IN      VARCHAR2
, p_workflow_started_by_id  	IN      NUMBER
, p_fin_plan_type_id            IN      NUMBER     default NULL
, p_version_type                IN      VARCHAR2   default NULL
, p_draft_version_id            IN      NUMBER     default NULL
, p_budget_baseliner_id		OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
 )
 --
IS

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

Line: 1047

SELECT  employee_id
FROM    fnd_user
WHERE   user_id = p_workflow_started_by_id;

Line: 1052

SELECT  supervisor_id
FROM    per_assignments_f
WHERE    person_id = l_employee_id
AND assignment_type in ('C','E')  -- Bug#2911451 + FP.M for 'C'
AND primary_flag = 'Y'     -- Bug#2911451
AND TRUNC(sysdate) BETWEEN EFFECTIVE_START_DATE
AND NVL(EFFECTIVE_END_DATE, sysdate);

Line: 1097

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

Line: 1101

END Select_Budget_Approver;