[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select a.plan_id
from csc_cust_plans a,
csc_plan_headers_b b
where a.party_id = p_Party_id
and a.plan_id = b.plan_id
and nvl(b.end_user_type, 'Y') = nvl(p_end_user_type, nvl(b.end_user_type, 'Y') )
and a.cust_account_id is null
and a.plan_status_code in ('APPLIED', 'ENABLED', 'TRANSFERED')
and trunc(sysdate) between trunc(nvl(b.start_date_active, sysdate))
and trunc(nvl(b.end_date_active, sysdate))
UNION
select a.plan_id
from csc_cust_plans a,
csc_plan_headers_b b
where a.party_id = p_party_id
and a.plan_id = b.plan_id
and nvl(b.end_user_type, 'Y') = nvl(p_end_user_type, nvl(b.end_user_type, 'Y') )
and a.cust_account_id = p_cust_account_id
and a.plan_status_code in ('APPLIED', 'ENABLED', 'TRANSFERED')
and trunc(sysdate) between trunc(nvl(b.start_date_active, sysdate))
and trunc(nvl(b.end_date_active, sysdate));
SELECT och.id Condition_id
FROM csc_plan_lines cpl,okc_condition_headers_v och
WHERE cpl.condition_id = och.id
AND cpl.plan_id = c_plan_id;
X_Condition_ID_TBL.DELETE;
SELECT element_name
FROM okc_action_attributes_v
WHERE acn_id = p_Action_id;