[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
FND_API.g_attr_tbl.DELETE;
FND_API.g_attr_tbl(I).name := 'dw_update_advice';
SELECT NAME
INTO l_accounting_rule
FROM OE_RA_RULES_V
WHERE RULE_ID = p_accounting_rule_id;
SELECT MEANING
INTO l_calculate_price_flag
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_calculate_price_flag
AND LOOKUP_TYPE = l_lookup_type;
SELECT NAME ||' : '||revision
INTO l_agreement
FROM OE_AGREEMENTS_VL
WHERE AGREEMENT_ID = p_agreement_id;
SELECT USER_CONVERSION_TYPE
INTO l_conversion_type
FROM OE_GL_DAILY_CONVERSION_TYPES_V
WHERE CONVERSION_TYPE = p_conversion_type_code;
SELECT NAME
INTO l_deliver_to_contact
FROM OE_CONTACTS_V
WHERE CONTACT_ID = p_deliver_to_contact_id;
SELECT ORGANIZATION_NAME
INTO l_inventory_org
FROM ORG_ORGANIZATION_DEFINITIONS
WHERE ORGANIZATION_ID = p_inventory_org_id;
SELECT L.NAME
, L.LOCATION_CODE
, L.ADDRESS_LINE_1
, L.ADDRESS_LINE_2
, L.ADDRESS_LINE_3
, L.ADDRESS_LINE_4
, L.TOWN_OR_CITY
, L.STATE
, L.POSTAL_CODE
, L.COUNTRY
INTO x_deliver_to_org
, x_deliver_to_location
, x_deliver_to_address1
, x_deliver_to_address2
, x_deliver_to_address3
, x_deliver_to_address4
, x_deliver_to_city
, x_deliver_to_state
, x_deliver_to_postal_code
, x_deliver_to_country
FROM OE_DELIVER_TO_ORGS_V L
WHERE L.ORGANIZATION_ID = p_deliver_to_org_id;
SELECT MEANING
INTO l_fob_point
FROM OE_AR_LOOKUPS_V
WHERE LOOKUP_CODE = p_fob_point_code
AND LOOKUP_TYPE = l_lookup_type;
SELECT MEANING
INTO l_freight_terms
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_freight_terms_code
AND LOOKUP_TYPE = l_lookup_type;
SELECT NAME
INTO l_intermed_ship_to_contact
FROM OE_CONTACTS_V
WHERE CONTACT_ID = p_intermed_ship_to_contact_id;
SELECT L.NAME
, L.LOCATION_CODE
, L.ADDRESS_LINE_1
, L.ADDRESS_LINE_2
, L.ADDRESS_LINE_3
, L.ADDRESS_LINE_4
, L.TOWN_OR_CITY
, L.STATE
, L.POSTAL_CODE
, L.COUNTRY
INTO x_intermed_ship_to_org
, x_intermed_ship_to_location
, x_intermed_ship_to_address1
, x_intermed_ship_to_address2
, x_intermed_ship_to_address3
, x_intermed_ship_to_address4
, x_intermed_ship_to_city
, x_intermed_ship_to_state
, x_intermed_ship_to_postal_code
, x_intermed_ship_to_country
FROM OE_SHIP_TO_ORGS_V L
WHERE L.ORGANIZATION_ID = p_intermed_ship_to_org_id;
SELECT NAME
INTO l_invoice_to_contact
FROM OE_CONTACTS_V
WHERE CONTACT_ID = p_invoice_to_contact_id;
SELECT L.NAME
, L.LOCATION_CODE
, L.ADDRESS_LINE_1
, L.ADDRESS_LINE_2
, L.ADDRESS_LINE_3
, L.ADDRESS_LINE_4
, L.TOWN_OR_CITY
, L.STATE
, L.POSTAL_CODE
, L.COUNTRY
INTO x_invoice_to_org
, x_invoice_to_location
, x_invoice_to_address1
, x_invoice_to_address2
, x_invoice_to_address3
, x_invoice_to_address4
, x_invoice_to_city
, x_invoice_to_state
, x_invoice_to_postal_code
, x_invoice_to_country
FROM OE_INVOICE_TO_ORGS_V L
WHERE L.ORGANIZATION_ID = p_invoice_to_org_id;
SELECT NAME
INTO l_invoicing_rule
FROM OE_RA_RULES_V
WHERE RULE_ID = p_invoicing_rule_id;
SELECT NAME
INTO l_order_source
FROM OE_ORDER_SOURCES
WHERE ORDER_SOURCE_ID = p_order_source_id;
SELECT NAME
INTO l_order_type
FROM OE_ORDER_TYPES_v
WHERE ORDER_TYPE_ID = p_order_type_id;
SELECT NAME
INTO l_payment_term
FROM OE_RA_TERMS_V
WHERE TERM_ID = p_payment_term_id;
SELECT NAME
INTO l_price_list
FROM qp_list_headers_vl
WHERE list_header_id = p_price_list_id and
list_type_code in ('PRL', 'AGR');
SELECT NAME
INTO l_new_modifier_list
FROM qp_list_headers_vl
WHERE list_header_id = p_new_modifier_list_id ;
SELECT MEANING
INTO l_demand_class
FROM OE_FND_COMMON_LOOKUPS_V
WHERE LOOKUP_CODE = p_demand_class_code
AND LOOKUP_TYPE = l_lookup_type;
SELECT MEANING
INTO l_shipment_priority
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_shipment_priority_code
AND LOOKUP_TYPE = l_lookup_type;
SELECT L.Organization_code
, L.LOCATION_CODE
, L.ADDRESS_LINE_1
, L.ADDRESS_LINE_2
, L.ADDRESS_LINE_3
, DECODE(L.TOWN_OR_CITY,NULL,NULL,L.TOWN_OR_CITY||', ')||
DECODE(L.REGION_1, NULL, NULL, L.REGION_1 || ', ')||
DECODE(L.REGION_2, NULL, NULL, L.REGION_2 || ', ')||
DECODE(L.REGION_3, NULL, NULL, L.REGION_3 || ', ')||
DECODE(L.POSTAL_CODE, NULL, NULL, L.POSTAL_CODE || ', ')||
DECODE(L.COUNTRY, NULL, NULL, L.COUNTRY)
INTO x_ship_from_org
, x_ship_from_location
, x_ship_from_address1
, x_ship_from_address2
, x_ship_from_address3
, x_ship_from_address4
FROM OE_SHIP_FROM_ORGS_V L
WHERE L.ORGANIZATION_ID = p_ship_from_org_id;
SELECT NAME
INTO l_ship_to_contact
FROM OE_CONTACTS_V
WHERE CONTACT_ID = p_ship_to_contact_id;
SELECT L.NAME
, L.LOCATION_CODE
, L.ADDRESS_LINE_1
, L.ADDRESS_LINE_2
, L.ADDRESS_LINE_3
, L.ADDRESS_LINE_4
, L.TOWN_OR_CITY
, L.STATE
, L.POSTAL_CODE
, L.COUNTRY
INTO x_ship_to_org
, x_ship_to_location
, x_ship_to_address1
, x_ship_to_address2
, x_ship_to_address3
, x_ship_to_address4
, x_ship_to_city
, x_ship_to_state
, x_ship_to_postal_code
, x_ship_to_country
FROM OE_SHIP_TO_ORGS_V L
WHERE L.ORGANIZATION_ID = p_ship_to_org_id;
SELECT NAME
INTO l_sold_to_contact
FROM OE_CONTACTS_V
WHERE CONTACT_ID = p_sold_to_contact_id;
oe_debug_pub.add( 'DOING SELECT FOR CUSTOMER_NUMBER' ) ;
SELECT O.NAME
, O.CUSTOMER_NUMBER
INTO x_org
, x_customer_number
FROM OE_SOLD_TO_ORGS_V O
WHERE O.ORGANIZATION_ID = p_sold_to_org_id;
oe_debug_pub.add( 'DOING SELECT FOR CUSTOMER_NUMBER' ) ;
SELECT P.PARTY_NAME
, C.ACCOUNT_NUMBER
, C.ACCOUNT_NAME
, P.PARTY_NUMBER
INTO x_org
, x_customer_number
, x_account_description
, x_registry_id
FROM HZ_CUST_ACCOUNTS C
, HZ_PARTIES P
WHERE C.CUST_ACCOUNT_ID = p_sold_to_org_id
AND C.PARTY_ID =P.PARTY_ID;
SELECT MEANING
INTO l_tax_exempt
FROM FND_LOOKUPS
WHERE LOOKUP_CODE = p_tax_exempt_flag
AND LOOKUP_TYPE = l_lookup_type;
SELECT MEANING
INTO l_tax_exempt_reason
FROM FND_LOOKUPS
WHERE LOOKUP_CODE = p_tax_exempt_reason_code
AND LOOKUP_TYPE = l_lookup_type;
SELECT MEANING
INTO l_tax_point
FROM OE_AR_LOOKUPS_V
WHERE LOOKUP_CODE = p_tax_point_code
AND LOOKUP_TYPE = l_lookup_type;
select name
from oe_sales_credit_types
where sales_credit_type_id = p_sales_credit_type_id;
select name
from ra_salesreps
where salesrep_id = p_salesrep_id;
SELECT DESCRIPTION
INTO l_inventory_item
FROM MTL_SYSTEM_ITEMS
WHERE INVENTORY_ITEM_ID = p_inventory_item_id
AND ORGANIZATION_ID = l_validation_org_id;
SELECT NAME
INTO l_line_type
FROM OE_LINE_TYPES_V
WHERE LINE_TYPE_ID = p_line_type_id;
SELECT MEANING
INTO l_source_type
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_source_type_code
AND LOOKUP_TYPE = l_lookup_type;
SELECT MEANING
INTO l_order_date_type
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_order_date_type_code
AND LOOKUP_TYPE = l_lookup_type;
SELECT MEANING
INTO l_return_reason
FROM OE_AR_LOOKUPS_V
WHERE LOOKUP_CODE = p_return_reason_code
AND LOOKUP_TYPE = l_lookup_type;
SELECT /* MOAC_SQL_CHANGE */ H.order_number,
l.line_number,
l.shipment_number,
l.option_number,
l.component_number
INTO x_ref_order_number,
x_ref_line_number,
x_ref_shipment_number,
x_ref_option_number,
x_ref_component_number
FROM oe_order_headers_all h,
oe_order_lines l
WHERE l.line_id=p_reference_line_id
and h.header_id=l.header_id;
select /* MOAC_SQL_CHANGE */ rct.trx_number,
rctl.line_number
into x_ref_invoice_number,
x_ref_invoice_line_number
from ra_customer_trx rct,
ra_customer_trx_lines_all rctl
where rctl.customer_trx_line_id = p_reference_cust_trx_line_id
and rctl.customer_trx_id = rct.customer_trx_id;
select /* MOAC_SQL_CHANGE */ rct.trx_number
into l_credit_invoice_number
from ra_customer_trx rct,
ra_customer_trx_lines_all rctl
where rctl.customer_trx_line_id = p_credit_invoice_line_id
and rctl.customer_trx_id = rct.customer_trx_id;
SELECT MEANING
INTO l_payment_type
FROM oe_lookups
WHERE lookup_type=l_lookup_type and lookup_code=p_payment_type_code;
SELECT NAME
INTO l_payment_type
FROM oe_payment_types_vl
WHERE payment_type_code = p_payment_type_code;
SELECT MEANING
INTO l_payment_type
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_payment_type_code
AND LOOKUP_TYPE = l_lookup_type;
select description into l_credit_card
from iby_creditcard_issuers_v
where CARD_ISSUER_CODE = p_credit_card_code
and rownum = 1;
SELECT trx_number
INTO l_commitment
FROM RA_CUSTOMER_TRX
WHERE customer_trx_id = p_commitment_id;
SELECT meaning
INTO l_ship_method
FROM oe_ship_methods_v
WHERE lookup_code = p_ship_method_code;
SELECT DECODE(TAX_TYPE,'TAX_GROUP','Y',NULL)
INTO l_tax_group
FROM ar_vat_tax
WHERE tax_code = p_tax_code
AND ROWNUM = 1;
SELECT distinct MEANING
INTO l_flow_status
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_flow_status_code
AND (LOOKUP_TYPE = l_lookup_type1
OR LOOKUP_TYPE = l_lookup_type2);
SELECT DESCRIPTION
INTO l_freight_carrier
FROM ORG_FREIGHT
WHERE FREIGHT_CODE = p_freight_carrier_code
AND ORGANIZATION_ID = nvl(l_ship_from_org_id,ORGANIZATION_ID);
SELECT MEANING
INTO l_sales_channel
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_sales_channel_code
AND LOOKUP_TYPE = l_lookup_type;
SELECT /* MOAC_SQL_CHANGE */ P.PARTY_NAME
INTO x_ship_to_customer_name
FROM HZ_CUST_SITE_USES_all site,
HZ_CUST_ACCT_SITES cas,
HZ_CUST_ACCOUNTS cust,
HZ_PARTIES p
WHERE site.cust_acct_site_id=cas.cust_acct_site_id
AND cust.cust_account_id=cas.cust_account_id
AND cust.party_id = p.party_id
AND site.site_use_code=l_site_use_code
AND site.site_use_id=p_ship_to_org_id;
SELECT /* MOAC_SQL_CHANGE */ P.PARTY_NAME
INTO x_invoice_to_customer_name
FROM HZ_CUST_SITE_USES_ALL site,
HZ_CUST_ACCT_SITES cas,
HZ_CUST_ACCOUNTS cust,
HZ_PARTIES p
WHERE site.cust_acct_site_id=cas.cust_acct_site_id
AND cust.cust_account_id=cas.cust_account_id
AND cust.party_id = p.party_id
AND site.site_use_code=l_site_use_code
AND site.site_use_id=p_invoice_to_org_id;
SELECT concatenated_segments
,concatenated_segments
INTO x_ordered_item
,x_inventory_item
FROM mtl_system_items_vl
WHERE inventory_item_id = p_inventory_item_id
AND organization_id = p_organization_id;
SELECT citems.customer_item_number
,sitems.concatenated_segments
INTO x_ordered_item
,x_inventory_item
FROM mtl_customer_items citems
,mtl_customer_item_xrefs cxref
,mtl_system_items_vl sitems
WHERE citems.customer_item_id = cxref.customer_item_id
AND cxref.inventory_item_id = sitems.inventory_item_id
AND sitems.inventory_item_id = p_inventory_item_id
AND sitems.organization_id = p_organization_id
AND citems.customer_item_id = p_ordered_item_id
AND citems.customer_id = p_sold_to_org_id;
SELECT category_concat_segs
,category_concat_segs
INTO x_ordered_item
,x_inventory_item
FROM mtl_categories_v
WHERE category_id = p_inventory_item_id;
SELECT items.cross_reference
,sitems.concatenated_segments
INTO x_ordered_item
,x_inventory_item
FROM mtl_cross_reference_types types
, mtl_cross_references items
, mtl_system_items_vl sitems
WHERE types.cross_reference_type = items.cross_reference_type
AND items.inventory_item_id = sitems.inventory_item_id
AND sitems.organization_id = p_organization_id
AND sitems.inventory_item_id = p_inventory_item_id
AND items.cross_reference_type = p_item_identifier_type
AND items.cross_reference = p_ordered_item;
Select meaning
Into x_Item_Identifier
From oe_lookups
Where lookup_type = l_lookup_type
And lookup_code = p_Item_Identifier_type;
Select meaning
Into x_Item_Relationship_Type_dsp
From mfg_lookups
Where lookup_type = l_lookup_type
And lookup_code = p_Item_Relationship_Type;
SELECT MEANING
INTO l_user_status
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_user_status_code
AND LOOKUP_TYPE = l_lookup_type;
SELECT MEANING
INTO l_Transaction_Phase
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_Transaction_Phase_code
AND LOOKUP_TYPE = l_lookup_type;
SELECT /* MOAC_SQL_CHANGE */
SITE.LOCATION
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, nvl(LOC.STATE,LOC.PROVINCE) -- 3603600
, LOC.POSTAL_CODE
, LOC.COUNTRY
INTO
x_sold_to_location
, x_sold_to_location_address1
, x_sold_to_location_address2
, x_sold_to_location_address3
, x_sold_to_location_address4
, x_sold_to_location_city
, x_sold_to_location_state
, x_sold_to_location_postal
, x_sold_to_location_country
FROM
HZ_CUST_SITE_USES_All SITE,
HZ_PARTY_SITES PARTY_SITE,
HZ_LOCATIONS LOC,
HZ_CUST_ACCT_SITES ACCT_SITE
WHERE
SITE.SITE_USE_CODE = 'SOLD_TO'
AND SITE.SITE_USE_ID = p_sold_to_site_use_id
AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
SELECT SUBSTRB(CONTACT_PARTY.PARTY_NAME,1,70) CONTACT_NAME,
DECODE(arl.meaning,NULL, NULL, ' '||arl.meaning) Phone_Type,
DECODE(CONTACT.phone_country_code, NULL, NULL,
CONTACT.phone_country_code || '- ') ||
DECODE(CONTACT.phone_area_code, NULL, NULL, CONTACT.phone_area_code || '-')||
DECODE(CONTACT.phone_number, NULL, NULL, CONTACT.phone_number ) phone,
REL_PARTY.email_address
INTO x_contact_name,
x_phone_line_type,
x_phone_number,
x_email_address
FROM HZ_CONTACT_POINTS CONTACT,
HZ_PARTIES CONTACT_PARTY,
HZ_CUST_ACCOUNT_ROLES ACCT_ROLES,
HZ_CUST_ACCOUNTS CUST_ACCT,
HZ_RELATIONSHIPS PARTY_REL,
HZ_PARTIES REL_PARTY,
AR_LOOKUPS ARL
WHERE CONTACT.owner_table_name(+) = 'HZ_PARTIES'
AND CONTACT.PRIMARY_FLAG (+) = 'Y'
AND CONTACT.contact_point_type (+) = 'PHONE'
AND ACCT_ROLES.PARTY_ID = CONTACT.owner_table_id(+)
AND ACCT_ROLES.cust_account_role_id = p_contact_id
AND PARTY_REL.PARTY_ID = ACCT_ROLES.PARTY_ID
AND PARTY_REL.PARTY_ID = REL_PARTY.PARTY_ID
AND PARTY_REL.SUBJECT_ID = CONTACT_PARTY.PARTY_ID
AND PARTY_REL.OBJECT_ID = CUST_ACCT.PARTY_ID
AND ACCT_ROLES.CUST_ACCOUNT_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND CONTACT.status(+) = 'A'
AND ACCT_ROLES.STATUS = 'A'
AND ARL.lookup_type (+) = 'PHONE_LINE_TYPE'
AND ARL.lookup_code(+) = CONTACT.phone_line_type;
SELECT MEANING
INTO l_payment_collection_event
FROM OE_LOOKUPS
WHERE LOOKUP_CODE = p_payment_collection_event
AND LOOKUP_TYPE = l_lookup_type;
SELECT NAME
INTO l_receipt_method
FROM AR_RECEIPT_METHODS
WHERE receipt_method_id = p_receipt_method;
Select group_name into l_sales_group_name
From jtf_rs_groups_vl
Where Group_id=p_sales_group_id;
SELECT NAME
INTO l_end_customer_contact
FROM OE_CONTACTS_V
WHERE CONTACT_ID = p_end_customer_contact_id;
oe_debug_pub.add( 'DOING SELECT FOR END_CUSTOMER_NUMBER' ) ;
SELECT O.NAME
, O.CUSTOMER_NUMBER
INTO x_end_customer_name
, x_end_customer_number
FROM OE_SOLD_TO_ORGS_V O
WHERE O.ORGANIZATION_ID = p_end_customer_id;
SELECT /* MOAC_SQL_CHANGE */
loc.address1
,loc.address2
,loc.address3
,loc.address4
,site_use.location
,loc.city
,nvl(loc.state,loc.province) -- 3603600
,loc.postal_code
,loc.country
INTO
x_end_customer_address1
,x_end_customer_address2
,x_end_customer_address3
,x_end_customer_address4
,x_end_customer_location
,x_end_customer_city
,x_end_customer_state
,x_end_customer_postal_code
,x_end_customer_country
FROM
hz_locations loc,
hz_party_sites site,
hz_cust_site_uses_all site_use,
hz_cust_acct_sites acct_site
WHERE
site_use.site_use_id= p_end_customer_site_use_id
and site_use.cust_acct_site_id=acct_site.cust_acct_site_id
and acct_site.party_site_id=site.party_site_id
and site.location_id=loc.location_id;
SELECT meaning
INTO l_ib_owner_dsp
FROM OE_LOOKUPS
WHERE lookup_code= p_ib_owner and
(lookup_type=l_lookup_type1 or lookup_type=l_lookup_type2);
SELECT meaning
INTO l_ib_current_location_dsp
FROM OE_LOOKUPS
WHERE lookup_code= p_ib_current_location and
(lookup_type=l_lookup_type1 or lookup_type=l_lookup_type2);
SELECT meaning
INTO l_ib_installed_at_location_dsp
FROM OE_LOOKUPS
WHERE lookup_code= p_ib_installed_at_location and
(lookup_type=l_lookup_type1 or lookup_type=l_lookup_type2);
SELECT unit_of_measure
INTO l_charge_periodicity_dsp
FROM mtl_units_of_measure_vl
WHERE uom_class=l_profile_value
and uom_code=p_charge_periodicity_code;
SELECT service_item_flag
INTO l_temp
FROM MTL_SYSTEM_ITEMS_B
WHERE inventory_item_id = p_inventory_item_id
AND organization_id = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
Select description
INTO l_service_period_dsp
FROM mtl_item_uoms_view
WHERE uom_code =p_service_period
and inventory_item_id = p_inventory_item_id
and organization_id = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
Select meaning
INTO l_service_reference_type
FROM oe_lookups
WHERE lookup_code=p_service_Reference_type_code
and lookup_type = 'SERVICE_REFERENCE_TYPE_CODE';
SELECT meaning
INTO l_change_reason
FROM OE_LOOKUPS
WHERE lookup_code= p_change_reason_code
and (lookup_type=l_lookup_type1 or lookup_type=l_lookup_type2);
SELECT contingency_name, description, expiration_event_code
INTO x_contingency_name, x_contingency_description, l_expiration_event_code
FROM AR_DEFERRAL_REASONS
WHERE contingency_id = p_contingency_id;
SELECT MEANING
INTO x_expiration_event_attribute
FROM AR_LOOKUPS
WHERE lookup_type='AR_EXPIRATION_EVENTS'
AND lookup_code = l_expiration_event_code;
SELECT MEANING
INTO l_revrec_event
FROM AR_LOOKUPS
WHERE lookup_type='AR_REVREC_EVENTS'
AND lookup_code = p_revrec_event_code;
SELECT user_name
INTO l_accepted_by_dsp
FROM FND_USER
WHERE user_id=p_accepted_by;
SELECT Profile_number
INTO l_billing_profile
from oks_billing_profiles_v
where Id = p_service_bill_profile_id;
SELECT MEANING
INTO l_Billing_Option FROM OE_LOOKUPS
WHERE lookup_type='OM_BILLING_OPTION_FOR_SERVICES'
and LOOKUP_CODE = p_service_bill_option_code;
select name
into l_Subscription_Template
from oks_coverage_templts_v
where item_type = 'SUBSCRIPTION'
and id = p_service_subs_template_id ;
select name
into l_Coverage_Template
from oks_coverage_templts_v
where item_type = 'SERVICE'
and id = p_service_cov_template_id ;
SELECT unit_of_measure_tl description
Into l_service_period
FROM OKX_UNITS_OF_MEASURE_V
WHERE uom_code = p_service_period;