APPS.PA_CLIENT_EXTN_PROJECT_WF SQL Statements

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

Line: 31

PROCEDURE Select_Project_Approver
 (p_project_id                  IN NUMBER
  , p_workflow_started_by_id    IN NUMBER
  , p_project_approver_id               OUT NOCOPY NUMBER  --File.Sql.39 bug 4440895
)
--
IS
/*
   You can use this procedure to add any additional rules to determine
   who can approve a project. This procedure is being used by the
   Workflow APIs and determine who the approver for a project
   should be. By default this procedure fetches the supervisor of the
   person who initiated the workflow as the approver.
*/
--
l_employee_id NUMBER;

Line: 49

SELECT  employee_id
FROM    fnd_user
WHERE   user_id = p_workflow_started_by_id;

Line: 54

SELECT supervisor_id
FROM    per_assignments_f
WHERE    person_id = l_employee_id
/*AND   Assignment_type ='E'                          -- Added this condition for bug 2911451*/ --Commented by avaithia Bug # 3448680
AND Assignment_type IN ('E','C')           --Included 'C' also in Assignment_type Bug # 3448680
AND   Primary_flag ='Y'                             -- Added this condition for bug 2911451
AND TRUNC(sysdate) BETWEEN EFFECTIVE_START_DATE
AND NVL(EFFECTIVE_END_DATE, sysdate);

Line: 90

       WF_CORE.CONTEXT('PA_CLIENT_EXTN_PROJECT_WF ','SELECT_PROJECT_APPROVER');

Line: 93

END Select_Project_Approver;

Line: 151

SELECT  pm_project_reference
,       segment1
,       name
,       description
,       project_type
,       pm_product_code
,       carrying_out_organization_id
,       project_status_code
,       template_flag -- Bug 6875403
FROM    pa_projects
WHERE   project_id = l_project_id;

Line: 165

SELECT  name
FROM    hr_organization_units
WHERE   organization_id = l_carrying_out_organization_id;

Line: 171

SELECT  project_type_class_code
FROM    pa_project_types
WHERE   project_type = l_project_type;

Line: 177

SELECT  user_name
FROM    fnd_user
WHERE   user_id = l_starter_user_id;

Line: 188

SELECT  e.first_name||' '||e.last_name
FROM    fnd_user f, pa_employees e
WHERE   f.user_id = l_starter_user_id
AND     f.employee_id = e.person_id;

Line: 196

SELECT  e.first_name||' '||e.last_name
FROM    fnd_user f, per_all_people_f e
WHERE   f.user_id = l_starter_user_id
AND     f.employee_id = e.person_id
and     e.effective_end_date = ( SELECT
                                        MAX(papf.effective_end_date)
                                 FROM   per_all_people_f papf
                                 WHERE  papf.person_id = e.person_id);

Line: 212

SELECT project_status_name
        , wf_success_status_code
        , wf_failure_status_code
FROM   pa_project_statuses
WHERE  project_status_code = l_project_status_code;

Line: 221

SELECT project_status_name
FROM   pa_project_statuses
WHERE  project_status_code = l_wf_success_status_code;

Line: 228

SELECT project_status_name
FROM   pa_project_statuses
WHERE  project_status_code = l_wf_failure_status_code;

Line: 236

SELECT sysdate
FROM    sys.dual;

Line: 242

 	 SELECT change_comment FROM (
 	         SELECT change_comment
 	         FROM pa_obj_status_changes
 	         WHERE object_type = 'PA_PROJECTS'
 	         AND object_id = l_project_id
 	         AND new_project_status_code =
 	                 (SELECT project_status_code
 	                  FROM pa_projects_all
 	                  WHERE project_id = l_project_id)
 	         ORDER BY obj_status_change_id DESC
 	 )
 	 WHERE rownum = 1;

Line: 312

SELECT pa_workflow_itemkey_s.nextval
INTO itemkey
from dual;