The following lines contain the word 'select', 'insert', 'update' or 'delete':
select project_id
from pa_tasks
where task_id = x_task_id;
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));
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);
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));
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);
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));
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));
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
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));
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));
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);
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
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));
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));
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);
SELECT 1
FROM sys.dual
WHERE EXISTS (SELECT NULL
FROM ap_invoices_all
WHERE project_id = x_project_id);
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));
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));
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);
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
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));
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));
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);
SELECT 1
FROM sys.dual
WHERE EXISTS (SELECT NULL
FROM pa_project_fundings
WHERE project_id = x_project_id);
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);
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
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);
select 1
from sys.dual
where exists (SELECT NULL
FROM pa_cust_rev_dist_lines rdl
where rdl.project_id = x_project_id);
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);
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 );
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 );
SELECT 1
FROM sys.dual
WHERE EXISTS (SELECT NULL
FROM pa_draft_invoice_items
WHERE project_id = x_project_id);
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));
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));
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);
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));
SELECT 1
FROM sys.dual
where exists (SELECT NULL
FROM pa_draft_invoice_details_all
where CC_TAX_TASK_ID = x_TASK_ID);
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));
SELECT 1
FROM sys.dual
where exists (SELECT NULL
FROM pa_project_customers
where receiver_task_id = X_TASK_ID);
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));
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);
SELECT 1
FROM sys.dual
WHERE EXISTS (SELECT NULL
FROM pa_draft_revenue_items
WHERE project_id = x_project_id);
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));
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));
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);
SELECT 1
FROM sys.dual
WHERE EXISTS (SELECT NULL
FROM pa_commitment_txns
WHERE project_id = x_project_id);
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));
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));
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);
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);
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));
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));
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);
SELECT 1
FROM sys.dual
WHERE EXISTS (SELECT NULL
FROM pa_project_asset_assignments
WHERE project_id = x_project_id);
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 */
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));
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));
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);
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);
SELECT 1
FROM sys.dual
where exists (SELECT NULL
FROM PA_JOB_BILL_RATE_OVERRIDES
WHERE TASK_ID = x_task_ID);
SELECT 1
FROM sys.dual
where exists (SELECT NULL
FROM pa_ind_rate_schedules
WHERE project_id = x_project_id);
SELECT 1
FROM sys.dual
where exists (SELECT NULL
FROM pa_ind_rate_schedules
WHERE TASK_ID = x_task_ID);
SELECT 1
FROM sys.dual
where exists (SELECT NULL
FROM PA_EMP_BILL_RATE_OVERRIDES
WHERE project_id = x_project_id);
SELECT 1
FROM sys.dual
where exists (SELECT NULL
FROM PA_EMP_BILL_RATE_OVERRIDES
WHERE TASK_ID = x_task_ID);
SELECT 1
FROM sys.dual
where exists (SELECT NULL
FROM PA_LABOR_MULTIPLIERS
WHERE project_id = x_project_id);
SELECT 1
FROM sys.dual
where exists (SELECT NULL
FROM PA_LABOR_MULTIPLIERS
WHERE TASK_ID = x_task_id);
SELECT 1
FROM sys.dual
where exists (SELECT NULL
FROM PA_TRANSACTION_CONTROLS
WHERE project_id = x_project_id);
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);
SELECT 1
FROM sys.dual
where exists (SELECT NULL
FROM PA_NL_BILL_RATE_OVERRIDES
WHERE project_id = x_project_id);
SELECT 1
FROM sys.dual
where exists (SELECT NULL
FROM PA_NL_BILL_RATE_OVERRIDES
WHERE TASK_ID = x_task_ID);
SELECT 1
FROM sys.dual
where exists (SELECT NULL
FROM PA_JOB_BILL_TITLE_OVERRIDES
WHERE project_id = x_project_id);
SELECT 1
FROM sys.dual
where exists (SELECT NULL
FROM PA_JOB_BILL_TITLE_OVERRIDES
WHERE TASK_ID = x_task_ID);
SELECT 1
FROM sys.dual
where exists (SELECT NULL
FROM PA_JOB_ASSIGNMENT_OVERRIDES
WHERE project_id = x_project_id);
SELECT 1
FROM sys.dual
where exists (SELECT NULL
FROM PA_JOB_ASSIGNMENT_OVERRIDES
WHERE TASK_ID = x_task_id);
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');
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);
select trunc(creation_date) into l_task_cdate
from pa_tasks
where task_id = x_task_id;
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;
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;
SELECT 1
FROM sys.dual
WHERE EXISTS (SELECT NULL
FROM cs_estimate_details
WHERE project_id = x_project_id
UNION
SELECT NULL
FROM CSF_DEBRIEF_LINES
WHERE project_id = x_project_id
UNION
SELECT NULL
FROM CSD_REPAIRS
WHERE project_id = x_project_id
);
SELECT 1
FROM sys.dual
where exists (SELECT NULL
FROM cs_estimate_details
where project_id = x_proj_id
AND project_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 NULL
FROM CSF_DEBRIEF_LINES
where project_id = x_proj_id
AND PROJECT_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 NULL
FROM CSD_REPAIRS
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)
);
SELECT 1
FROM sys.dual
where exists (SELECT NULL
FROM cs_estimate_details
where project_id = x_proj_id
AND project_TASK_ID = x_TASK_ID
UNION
SELECT NULL
FROM CSF_DEBRIEF_LINES
where project_id = x_proj_id
AND PROJECT_TASK_ID = x_TASK_ID
UNION
SELECT NULL
FROM CSD_REPAIRS
where project_id = x_proj_id
AND TASK_ID = x_TASK_ID
);