The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT customer_id
FROM pa_customers_v
WHERE upper(substr(customer_name,1,50)) = upper(substr(p_customer_name,1,50)) and status = 'A'; -- Bug 8314123
SELECT customer_id
INTO x_customer_id
FROM pa_customers_v
WHERE upper(substr(customer_name,1,50)) = upper(substr(p_customer_name,1,50)) -- Bug 8314123
and status = 'A';
SELECT customer_id
INTO x_customer_id
FROM pa_customers_v
WHERE customer_id = p_customer_id;
SELECT customer_id
FROM pa_customers_v
WHERE upper(customer_number) = upper(p_customer_number) and status = 'A';
SELECT customer_id
INTO x_customer_id
FROM pa_customers_v
WHERE upper(customer_number) = upper(p_customer_number)
and status = 'A';
SELECT customer_id
INTO x_customer_id
FROM pa_customers_v
WHERE customer_id = p_customer_id;
SELECT address_id
FROM pa_customer_sites_v
WHERE upper(address1) = upper(p_bill_site_name) AND
customer_id = p_customer_id AND
site_use_code = 'BILL_TO';
SELECT address_id
INTO x_bill_to_address_id
FROM pa_customer_sites_v
WHERE upper(address1) = upper(p_bill_site_name) AND
customer_id = p_customer_id AND
site_use_code = 'BILL_TO';
SELECT address_id
INTO x_bill_to_address_id
FROM pa_customer_sites_v
WHERE address_id = p_bill_to_address_id AND
customer_id = p_customer_id AND
site_use_code = 'BILL_TO';
SELECT address_id
FROM pa_customer_sites_v
WHERE upper(address1) = upper(p_work_site_name) AND
customer_id = p_customer_id AND
site_use_code = 'SHIP_TO';
SELECT address_id
INTO x_ship_to_address_id
FROM pa_customer_sites_v
WHERE upper(address1) = upper(p_work_site_name) AND
customer_id = p_customer_id AND
site_use_code = 'SHIP_TO';
SELECT address_id
INTO x_ship_to_address_id
FROM pa_customer_sites_v
WHERE address_id = p_ship_to_address_id AND
customer_id = p_customer_id AND
site_use_code = 'SHIP_TO';
SELECT contact_id
FROM pa_customer_contact_names_v
WHERE upper(rtrim(contact_name)) = upper(rtrim(p_contact_name)) AND -- Bug 4015644
customer_id = p_customer_id /* AND
usage_code = decode(p_project_contact_type_code, 'BILLING', 'BILL_TO',
'SHIPPING', 'SHIP_TO', usage_code) */
AND (address_id is null OR nvl(p_address_id, address_id)= address_id ); -- Added for Bug 2964227
SELECT contact_id
INTO x_contact_id
FROM pa_customer_contact_names_v
WHERE upper(rtrim(contact_name)) = upper(rtrim(p_contact_name)) AND -- Bug 4015644
customer_id = p_customer_id AND
usage_code = decode(p_project_contact_type_code, 'BILLING', 'BILL_TO',
'SHIPPING', 'SHIP_TO', usage_code)
AND (address_id is null OR nvl(p_address_id, address_id)= address_id ); -- Added for Bug 2964227
SELECT distinct acct_role.cust_account_role_id contact_id
INTO x_contact_id
FROM hz_cust_account_roles acct_role
,hz_role_responsibility role_resp
WHERE
acct_role.cust_account_role_id = role_resp.cust_account_role_id
and acct_role.role_type = 'CONTACT'
and nvl(acct_role.current_role_state, 'A') = 'A'
and acct_role.cust_account_role_id = p_contact_id
AND acct_role.cust_account_id = p_customer_id
AND role_resp.responsibility_type = decode(p_project_contact_type_code, 'BILLING', 'BILL_TO',
'SHIPPING', 'SHIP_TO',role_resp.responsibility_type)
AND (acct_role.cust_acct_site_id is null OR nvl(p_address_id,acct_role.cust_acct_site_id)=acct_role.cust_acct_site_id );
SELECT lookup_code
FROM pa_lookups
WHERE upper(meaning) = upper(p_project_contact_type_name) AND
lookup_type = 'PROJECT CONTACT TYPE' AND
trunc(sysdate) between start_date_active and nvl(end_date_active, trunc(sysdate));
SELECT lookup_code
INTO x_project_contact_type_code
FROM pa_lookups
WHERE upper(meaning) = upper(p_project_contact_type_name) AND
lookup_type = 'PROJECT CONTACT TYPE' AND
trunc(sysdate) between start_date_active and nvl(end_date_active, trunc(sysdate));
SELECT lookup_code
INTO x_project_contact_type_code
FROM pa_lookups
WHERE lookup_code = p_project_contact_type_code AND
lookup_type = 'PROJECT CONTACT TYPE' AND
trunc(sysdate) between start_date_active and nvl(end_date_active, trunc(sysdate));
SELECT 'x'
FROM pa_project_customers
WHERE project_id = p_project_id AND
customer_id = p_customer_id;
SELECT 'x'
FROM pa_project_contacts
WHERE project_id = c_project_id AND
customer_id = c_customer_id AND
contact_id = c_contact_id AND
project_contact_type_code = c_project_contact_type_code;
SELECT sum(customer_bill_split)
FROM pa_project_customers
WHERE project_id = c_project_id AND
customer_id <> c_customer_id;
SELECT cc_prvdr_flag
FROM pa_project_types
WHERE project_type =
(SELECT project_type
FROM pa_projects_all
WHERE project_id = c_project_id);
SELECT count(customer_id) count, sum(customer_bill_split) sum
FROM pa_project_customers
WHERE project_id = c_project_id
GROUP BY project_id;
SELECT '1'
FROM pa_project_customers
WHERE project_id = c_project_id AND
customer_id = c_customer_id;
if p_action = 'INSERT' then
if l_recinfo.count > 0 then
x_return_status := FND_API.G_RET_STS_ERROR;
elsif p_action = 'UPDATE' then
if l_recinfo.count > 1 then
x_return_status := FND_API.G_RET_STS_ERROR;
SELECT '1'
FROM
/* Commented for Bug 2499051
pa_projects a,
*/
pa_project_types b
WHERE b.project_type_class_code = 'CONTRACT' AND
b.project_type =
(SELECT project_type
FROM pa_projects_all
WHERE project_id = c_project_id) AND
(b.cc_prvdr_flag = 'N' OR b.cc_prvdr_flag is NULL);
SELECT '1'
FROM pa_implementations_all
WHERE customer_id = c_customer_id;
SELECT '1'
FROM pa_implementations
WHERE cc_ic_billing_prvdr_flag = 'Y';
SELECT project_currency_code, multi_currency_billing_flag
FROM pa_projects_all
WHERE project_id = c_project_id;
select pt.cc_prvdr_flag
into l_cc_prvdr_flag
FROM pa_project_types pt
, pa_projects p
WHERE p.project_type = pt.project_type
AND p.project_id = p_project_id
AND p.org_id = pt.org_id;
PROCEDURE CHECK_UPDATE_CONTRIB_ALLOWED
( p_project_id IN NUMBER
,p_customer_id IN NUMBER
,p_customer_bill_split IN NUMBER
,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS
c1_exists VARCHAR2(1) := NULL;
SELECT 'x'
FROM sys.dual
WHERE exists
(SELECT null
FROM pa_draft_revenues r
WHERE r.project_id = c_project_id) OR
exists
(SELECT null
FROM pa_draft_invoices i
WHERE i.project_id = c_project_id);
SELECT 'x'
FROM pa_agreements_all a, pa_project_fundings f
WHERE a.customer_id+0 = c_customer_id AND
a.agreement_id = f.agreement_id AND
f.project_id = c_project_id AND
f.budget_type_code = 'BASELINE';*/
SELECT 'x'
FROM pa_agreements_all a,
pa_summary_project_fundings f
WHERE a.customer_id = c_customer_id
AND a.agreement_id = f.agreement_id
AND f.project_id = c_project_id
AND ( f.total_unbaselined_amount <>0
OR f.total_baselined_amount <> 0);
SELECT customer_bill_split
FROM pa_project_customers
WHERE project_id = c_project_id AND
customer_id = c_customer_id;
END CHECK_UPDATE_CONTRIB_ALLOWED;
PROCEDURE CHECK_DELETE_CUSTOMER_ALLOWED
( p_project_id IN NUMBER
,p_customer_id IN NUMBER
,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS
c_exists VARCHAR2(1);
SELECT 'x'
FROM pa_agreements_all a, pa_project_fundings f
WHERE a.customer_id+0 = c_customer_id AND
a.agreement_id = f.agreement_id AND
f.project_id = c_project_id;
END CHECK_DELETE_CUSTOMER_ALLOWED;
SELECT org_id
INTO x_org_id
FROM pa_implementations;
SELECT customer_id
INTO x_customer_id
FROM pa_customers_v
WHERE upper(customer_number) = upper(p_customer_number) and
upper(substr(customer_name,1,50)) = upper(substr(p_customer_name,1,50)) -- Bug 8314123
and status = 'A';
SELECT sum(customer_bill_split)
FROM pa_project_customers
WHERE project_id = c_project_id;
SELECT
HZ_C.cust_account_id ,
HZ_P.party_name ,
HZ_P.party_number,
'Y'
FROM
pa_project_customers proj_cust,
hz_cust_accounts HZ_C,
HZ_PARTIES HZ_P
WHERE
proj_cust.project_id = p_project_id
AND proj_cust.customer_id = hz_c.cust_account_id
AND hz_c.party_id = hz_p.party_id
ORDER BY
proj_cust.customer_bill_split desc,
hz_p.party_name,
HZ_P.party_number ;