The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
INTO l_CC_txn_Exists
FROM dual
WHERE EXISTS (
SELECT 'CC TXNS'
FROM igc_cc_acct_lines igc
,pa_projects_all pp
WHERE igc.project_id IS NOT NULL
AND igc.project_id = pp.project_id
AND pp.project_id = p_project_id
AND igc.task_id IN ( SELECT task.task_id
FROM pa_tasks task
WHERE task.project_id = pp.project_id
CONNECT BY PRIOR task.TASK_ID = task.PARENT_TASK_ID
START WITH task.TASK_ID = p_task_id
)
);
SELECT 'Y'
INTO l_CC_txn_Exists
FROM dual
WHERE EXISTS (
SELECT 'CC TXNS'
FROM igc_cc_acct_lines igc
,pa_projects_all pp
WHERE igc.project_id IS NOT NULL
AND igc.project_id = pp.project_id
AND pp.project_id = p_project_id
);
SELECT work_type_id
FROM pa_work_types_v w
WHERE w.name = x_work_type_name ;
select DECODE(nvl(pp.assign_precedes_task,'N')
,'Y',decode(ppasgn.work_type_id, NULL,
decode(t.work_type_id,NULL,pp.work_type_id,t.work_type_id),ppasgn.work_type_id),
'N', decode(t.work_type_id,NULL,
decode(ppasgn.work_type_id,NULL,pp.work_type_id,ppasgn.work_type_id)
,t.work_type_id)
) work_type_id
FROM pa_projects_all pp
,pa_project_assignments ppasgn
,pa_tasks t
WHERE pp.project_id = p_project_id
AND t.task_id = p_task_id
AND t.project_id = pp.project_id
AND ppasgn.assignment_id = p_assignment_id
AND ( pp.project_id = ppasgn.project_id
OR ( ppasgn.project_id is null
and rownum = 1
)
);
select Decode(t.work_type_id,NULL,pp.work_type_id,t.work_type_id) work_type_id
FROM pa_projects_all pp
,pa_tasks t
WHERE pp.project_id = p_project_id
AND t.task_id = p_task_id
AND t.project_id = pp.project_id ;
pa_utils4.G_WorkTypeNameRecTab.Delete;
SELECT name
INTO l_work_type_name
FROM pa_work_types_tl
WHERE work_type_id = p_work_type_id
and language = userenv('LANG');
pa_utils4.G_AssignNameRecTab.delete;
select meaning
into l_assignment_name
from pa_lookups
where lookup_type = 'PA_EXP_ASSGN_ENTRY'
and lookup_code = 'UNSCHEDULED';
SELECT assignment_name
INTO l_assignment_name
FROM pa_project_assignments
WHERE assignment_id = p_assignment_id;
pa_utils4.G_AssignIdRecTab.delete;
pa_utils4.G_TpAmtTypeRecTab.Delete;
SELECT tp_amt_type_code
INTO l_tp_amt_code
FROM pa_work_types_b
WHERE work_type_id = p_work_type_id
AND trunc(sysdate) between start_date_active
and nvl(end_date_active,sysdate);
SELECT nvl(fnd_profile.value_specific('PA_EN_NEW_WORK_TYPE_PROCESS'),'N')
INTO l_enabled_flag
FROM dual;
SELECT nvl(fnd_profile.value_specific('PA_TRXN_BILLABLE_WORK_TYPE'),'N')
INTO l_enabled_flag
FROM dual;
SELECT BILLABLE_CAPITALIZABLE_FLAG
FROM pa_work_types_b -- bug 4668816 changed from pa_work_types_v to pa_work_types_b
WHERE work_type_id = p_work_type_id
AND trunc(sysdate) between start_date_active and
nvl(end_date_active,sysdate);
SELECT billable_flag
INTO l_billable_flag
FROM pa_expenditure_items_all ei
WHERE ei.expenditure_item_id=orig_eid;
SELECT bill_hold_flag
INTO l_bill_hold_flag
FROM pa_expenditure_items_all ei
WHERE ei.expenditure_item_id=orig_eid;
SELECT 'X'
FROM sys.dual
WHERE EXISTS ( SELECT 'x'
FROM pa_org_labor_sch_rule a
WHERE (a.cost_rate_sch_id = p_bill_rate_sch_id
OR
a.FORECAST_COST_RATE_SCH_ID = p_bill_rate_sch_id
)
) ;
SELECT 'X'
FROM sys.dual
WHERE EXISTS ( SELECT 'y'
FROM pa_compensation_details_all b
WHERE b.rate_schedule_id = p_bill_rate_sch_id
) ;
SELECT TO_NUMBER(p_reference1)
INTO l_return_number
FROM dual;
SELECT SET_OF_BOOKS_ID
,ORG_ID
,nvl(BOOK_TYPE_CODE,'X')
,BUSINESS_GROUP_ID
INTO PA_UTILS4.G_imp_sob_id
,PA_UTILS4.G_imp_org_id
,PA_UTILS4.G_imp_book_type_code
,PA_UTILS4.G_imp_bus_group
FROM pa_implementations;
SELECT BUSINESS_GROUP_ID
INTO l_business_grp_id
FROM HR_ALL_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = p_organization_id;
select unit_of_measure
into l_uom
from pa_expenditure_types
where expenditure_type = p_expenditure_type ;
select l.meaning
into l_uom_m
from pa_lookups l
where lookup_type = 'UNIT'
and lookup_code = p_unit_of_measure ;
select l.meaning
into l_uom_m
from pa_lookups l,
pa_expenditure_types et
where lookup_type = 'UNIT'
and lookup_code = et.unit_of_measure
and et.expenditure_type = p_expenditure_type ;
select P.FULL_NAME,NVL(P.EMPLOYEE_NUMBER,P.NPW_NUMBER)
into G_full_name, G_employee_number
from PER_PEOPLE_F P
WHERE P.PERSON_ID = p_incurred_by_person_id
AND TRUNC(p_EXPENDITURE_ENDING_DATE) BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE ;
select resource_code
into l_resource_code
from bom_resources
where resource_id = p_wip_resource_id ;
Select Concatenated_Segments
into l_inventory_item
from Mtl_System_Items_Kfv
where Inventory_Item_Id = p_inventory_item_id
and rownum = 1 ;
select chk.check_number
into l_inv_payment_id
from ap_checks chk,
ap_invoice_payments pay
where pay.check_id = chk.check_id
and pay.invoice_payment_id = to_number(NVL2(LTRIM(p_inv_payment_id,'0123456789'), NULL, p_inv_payment_id));
select nvl(glsla.sla_ledger_cash_basis_flag,'N')
into l_ledger_cash_basis_flag
from gl_ledgers glsla,
pa_implementations imp
where glsla.ledger_id = imp.set_of_books_id;
SELECT 'Y'
INTO l_pa_implemented
FROM pa_implementations_all
WHERE org_id = p_org_id;