DBA Data[Home] [Help]

APPS.PA_PROJ_TSK_UTILS SQL Statements

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

Line: 18

	select project_id
	from pa_tasks
	where task_id = x_task_id;
Line: 63

		select 1
		from sys.dual
		where exists (select event_num
		from pa_events
			where project_id = x_proj_id
			and (x_task_id is null or
			     task_id = x_task_id));
Line: 135

                SELECT 1
                FROM    sys.dual
                WHERE   EXISTS (SELECT NULL
                        FROM    pa_expenditure_items_all i
                        WHERE   i.project_id = x_project_id)
                OR  EXISTS
                       (SELECT NULL
                        FROM    pa_ei_denorm e
                        WHERE   e.project_id = x_project_id);
Line: 146

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   PA_EXPENDITURE_ITEMS_all
                        WHERE  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
                                START WITH TASK_ID = x_TASK_ID))
                or exists      (SELECT NULL
                        FROM    PA_EI_DENORM
                        WHERE   TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
                                START WITH TASK_ID = x_TASK_ID));
Line: 163

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   PA_EXPENDITURE_ITEMS_all
                        WHERE  TASK_ID = x_TASK_ID)
                or exists    (SELECT NULL
                        FROM   PA_EI_DENORM
                        WHERE  TASK_ID = x_TASK_ID);
Line: 173

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   PA_EXPENDITURE_ITEMS_all
                        WHERE  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                WHERE  TASK_ID = x_TASK_ID));
Line: 183

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   PA_EXPENDITURE_ITEMS_all
                        WHERE  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
				WHERE TASK_ID = x_TASK_ID));
Line: 267

                SELECT 1
                FROM    sys.dual
                WHERE   EXISTS (SELECT NULL
                        FROM po_distributions_all
                        WHERE  project_id = x_project_id
                        AND    nvl(encumbered_flag,'N') = 'Y');    -- Bug 6153950: added encumbered_flag
Line: 275

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   po_distributions_all
                        where  project_id = x_proj_id
                        AND    nvl(encumbered_flag,'N') = 'Y'      -- Bug 6153950: added encumbered_flag
                        AND  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
                                START WITH TASK_ID = x_TASK_ID));
Line: 288

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   po_distributions_all
                        where  project_id = x_proj_id
                        AND  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                WHERE  TASK_ID = x_TASK_ID));
Line: 303

		SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   po_distributions_all
                        where  project_id = x_proj_id
                        AND  TASK_ID = x_TASK_ID);
Line: 391

                SELECT 1
                FROM    sys.dual
                WHERE   EXISTS (SELECT NULL
                        FROM po_req_distributions_all
                        WHERE  project_id = x_project_id
                        AND    nvl(encumbered_flag,'N') = 'Y');    -- Bug 6153950: added encumbered_flag
Line: 399

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   po_req_distributions_all
                        where  project_id = x_proj_id
                        AND    nvl(encumbered_flag,'N') = 'Y'      -- Bug 6153950: added encumbered_flag
                        AND  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
                                START WITH TASK_ID = x_TASK_ID));
Line: 412

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   po_req_distributions_all
                        where  project_id = x_proj_id
                        AND  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                WHERE  TASK_ID = x_TASK_ID));
Line: 427

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   po_req_distributions_all
                        where  project_id = x_proj_id
                        AND  TASK_ID = x_TASK_ID);
Line: 514

                SELECT 1
                FROM    sys.dual
                WHERE   EXISTS (SELECT NULL
                        FROM ap_invoices_all
                        WHERE  project_id = x_project_id);
Line: 521

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   ap_invoices_all
                        where  project_id = x_proj_id
                        AND  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
                                START WITH TASK_ID = x_TASK_ID));
Line: 533

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   ap_invoices_all
                        where  project_id = x_proj_id
                        AND  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                WHERE  TASK_ID = x_TASK_ID));
Line: 548

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   ap_invoices_all
                        where  project_id = x_proj_id
                        AND  TASK_ID = x_task_id);
Line: 637

                SELECT 1
                FROM    sys.dual
                WHERE   EXISTS (SELECT NULL
                        FROM ap_invoice_distributions_all
                        WHERE  project_id = x_project_id
                        AND    nvl(encumbered_flag,'N') = 'Y');      -- Bug 6153950: added encumbered_flag
Line: 645

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   ap_invoice_distributions_all
                        where  project_id = x_proj_id
                        AND    nvl(encumbered_flag,'N') = 'Y'        -- Bug 6153950: added encumbered_flag
                        AND  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
                                START WITH TASK_ID = x_TASK_ID));
Line: 658

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   ap_invoice_distributions_all
                        where  project_id = x_proj_id
                        AND  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                WHERE  TASK_ID = x_TASK_ID));
Line: 673

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   ap_invoice_distributions_all
                        where  project_id = x_proj_id
                        AND  TASK_ID = x_TASK_ID);
Line: 754

                SELECT 1
                FROM    sys.dual
                WHERE   EXISTS (SELECT NULL
                        FROM pa_project_fundings
                        WHERE  project_id = x_project_id);
Line: 761

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM  pa_project_fundings
                        where  project_id = x_proj_id
                        AND  TASK_ID = x_task_id);
Line: 832

                select 1
                from sys.dual
                where exists (SELECT NULL
                FROM PA_EXPENDITURE_ITEMS_all PAI,
                     PA_COST_DISTRIBUTION_LINES_all PCD
                WHERE PAI.PROJECT_ID = x_PROJECT_ID
                AND PAI.EXPENDITURE_ITEM_ID = PCD.EXPENDITURE_ITEM_ID); -- Bug 3461664
Line: 842

                select 1
                from sys.dual
                where exists (SELECT  NULL
                        FROM    PA_EXPENDITURE_ITEMS_all PAI,
                                PA_COST_DISTRIBUTION_LINES_all PCD
                        WHERE   PAI.EXPENDITURE_ITEM_ID
                                = PCD.EXPENDITURE_ITEM_ID
                        AND PAI.TASK_ID = x_TASK_ID);
Line: 907

                select 1
                from sys.dual
                where exists (SELECT  NULL
                              FROM     pa_cust_rev_dist_lines rdl
                              where    rdl.project_id = x_project_id);
Line: 914

                select 1
                from sys.dual
                where exists (SELECT  NULL
                      from pa_cust_rev_dist_lines rdl
                      ,    pa_expenditure_items i
                      where i.expenditure_item_id = rdl.expenditure_item_id
                      and i.task_id = x_task_Id);
Line: 983

                select 1
                from sys.dual
                where exists (SELECT  NULL
                        FROM  pa_cust_event_rev_dist_lines
                        where   PROJECT_ID = x_PROJECT_ID
                        AND nvl(x_event_num, event_num) = event_num );
Line: 991

                select 1
                from sys.dual
                where exists (SELECT  NULL
                        FROM  pa_cust_event_rev_dist_lines
                        where project_id = x_proj_id
                        AND TASK_ID = x_TASK_ID
                        AND nvl(x_event_num, event_num) = event_num );
Line: 1071

                SELECT 1
                FROM    sys.dual
                WHERE   EXISTS (SELECT NULL
                        FROM pa_draft_invoice_items
                        WHERE  project_id = x_project_id);
Line: 1078

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   pa_draft_invoice_items
                        where  project_id = x_proj_id
                        AND  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                CONNECT BY PRIOR PARENT_TASK_ID = TASK_ID /* Bug 6511941 */
                                START WITH TASK_ID = x_TASK_ID));
Line: 1090

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   pa_draft_invoice_items
                        where  project_id = x_proj_id
                        AND  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                WHERE  TASK_ID = x_TASK_ID));
Line: 1105

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   pa_draft_invoice_items
                        where  project_id = x_proj_id
                        AND  TASK_ID = x_TASK_ID);
Line: 1182

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   pa_draft_invoice_details_all
                        where  CC_TAX_TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                CONNECT BY PRIOR PARENT_TASK_ID = TASK_ID /* Bug 6511941 */
                                START WITH TASK_ID = x_TASK_ID));
Line: 1195

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   pa_draft_invoice_details_all
                        where  CC_TAX_TASK_ID = x_TASK_ID);
Line: 1253

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   pa_project_customers
                        where  receiver_task_id IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
                                START WITH TASK_ID = X_TASK_ID));
Line: 1266

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   pa_project_customers
                        where  receiver_task_id = X_TASK_ID);
Line: 1326

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   pa_projects_all          -- Modified pa_projects to pa_projects_all for bug#3512486
                        where  project_id = (select project_id from pa_tasks where task_id=X_TASK_ID)
			  and CC_TAX_TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
                                START WITH TASK_ID = X_TASK_ID));
Line: 1341

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   pa_projects_all
                        where  project_id = x_proj_id
			  and CC_TAX_TASK_ID = x_task_id);
Line: 1411

                SELECT 1
                FROM    sys.dual
                WHERE   EXISTS (SELECT NULL
                        FROM pa_draft_revenue_items
                        WHERE  project_id = x_project_id);
Line: 1418

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   pa_draft_revenue_items
                        where  project_id = x_proj_id
                        AND  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                CONNECT BY PRIOR PARENT_TASK_ID = TASK_ID /* Bug 6511941 */
                                START WITH TASK_ID = x_TASK_ID));
Line: 1430

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   pa_draft_revenue_items
                        where  project_id = x_proj_id
                        AND  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                WHERE  TASK_ID = x_TASK_ID));
Line: 1445

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   pa_draft_revenue_items
                        where  project_id = x_proj_id
                        AND  TASK_ID =x_task_id);
Line: 1533

                SELECT 1
                FROM    sys.dual
                WHERE   EXISTS (SELECT NULL
                        FROM pa_commitment_txns
                        WHERE  project_id = x_project_id);
Line: 1540

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM pa_commitment_txns
                        where  project_id = x_proj_id
                        AND  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
                                START WITH TASK_ID = x_TASK_ID));
Line: 1553

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM pa_commitment_txns
                        where  project_id = x_proj_id
                        AND  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                WHERE  TASK_ID = x_TASK_ID));
Line: 1568

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM pa_commitment_txns
                        where  project_id = x_proj_id
                        AND  TASK_ID = x_TASK_ID);
Line: 1655

                SELECT 1
                FROM    sys.dual
                WHERE   EXISTS (SELECT NULL
                        FROM  pa_comp_rule_ot_defaults_all -- Bug 4680097:  pa_compensation_rule_sets
                        WHERE  project_id = x_project_id)
                UNION
                SELECT 1
                FROM    sys.dual
                WHERE   EXISTS (SELECT NULL
                        FROM pa_org_labor_sch_rule
                        WHERE  overtime_project_id = x_project_id);
Line: 1668

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM pa_comp_rule_ot_defaults_all -- Bug 4680097:  pa_compensation_rule_sets
                        where  project_id = x_proj_id
                        AND  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
                                START WITH TASK_ID = x_TASK_ID))
                UNION
                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM pa_org_labor_sch_rule
                        where  overtime_project_id = x_proj_id
                        AND  overtime_TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
                                START WITH TASK_ID = x_TASK_ID));
Line: 1691

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM pa_compensation_rule_sets
                        where  project_id = x_proj_id
                        AND  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                WHERE  TASK_ID = x_TASK_ID));
Line: 1706

                 SELECT 1
                 FROM   sys.dual
                 WHERE
                   exists (SELECT NULL
                             FROM   pa_comp_rule_ot_defaults_all
                             where  project_id = x_proj_id
                               AND  TASK_ID = x_task_id)
                  or exists (SELECT NULL
                             FROM   pa_org_labor_sch_rule
                             where  overtime_project_id = x_proj_id
                               AND  overtime_TASK_ID = x_task_id);
Line: 1803

                SELECT 1
                FROM    sys.dual
                WHERE   EXISTS (SELECT NULL
                        FROM pa_project_asset_assignments
                        WHERE  project_id = x_project_id);
Line: 1811

         select 1 from pa_tasks
         where task_id = x_task_id
         and wbs_level > 1
         and exists (select null from pa_project_asset_assignments
                     where task_id = x_task_id
		     and project_asset_id <> 0); /* Added for bug 6245714 */
Line: 1821

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM pa_project_asset_assignments
                        where  project_id = x_proj_id
                        AND  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
                                START WITH TASK_ID = x_TASK_ID));
Line: 1835

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM pa_project_asset_assignments
                        where  project_id = x_proj_id
                        AND  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                WHERE  TASK_ID = x_TASK_ID));
Line: 1850

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM pa_project_asset_assignments
                        where  project_id = x_proj_id
                        AND  TASK_ID = x_task_id);
Line: 1928

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   PA_JOB_BILL_RATE_OVERRIDES
                        WHERE  project_id = x_project_id
                        and task_id is null);
Line: 1936

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   PA_JOB_BILL_RATE_OVERRIDES
                        WHERE  TASK_ID = x_task_ID);
Line: 1997

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   pa_ind_rate_schedules
                        WHERE  project_id = x_project_id);
Line: 2004

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   pa_ind_rate_schedules
                        WHERE  TASK_ID = x_task_ID);
Line: 2067

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   PA_EMP_BILL_RATE_OVERRIDES
                        WHERE  project_id = x_project_id);
Line: 2075

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   PA_EMP_BILL_RATE_OVERRIDES
                        WHERE  TASK_ID = x_task_ID);
Line: 2136

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   PA_LABOR_MULTIPLIERS
                        WHERE  project_id = x_project_id);
Line: 2143

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   PA_LABOR_MULTIPLIERS
                        WHERE  TASK_ID = x_task_id);
Line: 2207

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   PA_TRANSACTION_CONTROLS
                        WHERE  project_id = x_project_id);
Line: 2214

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   PA_TRANSACTION_CONTROLS
                        WHERE  TASK_ID = x_task_ID
			AND    PROJECT_ID = task_project_id);
Line: 2284

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   PA_NL_BILL_RATE_OVERRIDES
                        WHERE  project_id = x_project_id);
Line: 2291

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   PA_NL_BILL_RATE_OVERRIDES
                        WHERE  TASK_ID = x_task_ID);
Line: 2351

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   PA_JOB_BILL_TITLE_OVERRIDES
                        WHERE  project_id = x_project_id);
Line: 2358

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   PA_JOB_BILL_TITLE_OVERRIDES
                        WHERE  TASK_ID = x_task_ID);
Line: 2420

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   PA_JOB_ASSIGNMENT_OVERRIDES
                        WHERE  project_id = x_project_id);
Line: 2427

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   PA_JOB_ASSIGNMENT_OVERRIDES
                        WHERE  TASK_ID = x_task_id);
Line: 2476

	select 1 into x_exist
	from dual
	where EXISTS (select * from ap_expense_report_lines_all a, ap_expense_report_headers_all b
		  		  where a.task_id = x_task_id
				    and a.REPORT_HEADER_ID = b.REPORT_HEADER_ID
					and b.source <> 'Oracle Project Accounting');
Line: 2485

        SELECT 1 into x_exist
        FROM DUAL
        WHERE EXISTS (SELECT * FROM AP_EXPENSE_REPORT_LINES_ALL A, AP_EXPENSE_REPORT_HEADERS_ALL B
                                  WHERE A.TASK_ID = x_task_id
                                    AND A.REPORT_HEADER_ID = B.REPORT_HEADER_ID
                                    AND B.SOURCE <> 'Oracle Project Accounting'
                                    AND B.VOUCHNO = 0);
Line: 2497

  select trunc(creation_date) into l_task_cdate
    from pa_tasks
   where task_id =  x_task_id;
Line: 2502

       SELECT 1
         INTO x_exist
         FROM AP_EXPENSE_REPORT_LINES_ALL A,
              AP_EXPENSE_REPORT_HEADERS_ALL B
        WHERE A.TASK_ID = x_task_id
          AND A.REPORT_HEADER_ID = B.REPORT_HEADER_ID
	  AND A.CREATION_DATE >= l_task_cdate
          AND B.CREATION_DATE >= l_task_cdate
          AND B.SOURCE <> 'Oracle Project Accounting'
          AND B.VOUCHNO = 0
          AND rownum = 1;
Line: 2515

       SELECT 1
         INTO x_exist
         FROM AP_EXPENSE_REPORT_LINES_ALL A
        WHERE A.TASK_ID IS NOT NULL
	  AND A.TASK_ID = x_task_id
	  AND A.CREATION_DATE >= l_task_cdate
	  AND EXISTS ( SELECT 1 FROM AP_EXPENSE_REPORT_HEADERS_ALL B
              WHERE A.REPORT_HEADER_ID = B.REPORT_HEADER_ID
                AND B.CREATION_DATE >= l_task_cdate
                AND B.SOURCE <> 'Oracle Project Accounting'
                AND B.VOUCHNO = 0)
          AND rownum = 1;