The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
NAME
INTO SOB_NAME
FROM
GL_SETS_OF_BOOKS
WHERE SET_OF_BOOKS_ID = P_SOB_ID;
SELECT
MEANING
INTO ACTIVITY_MEANING
FROM
OE_LOOKUPS
WHERE LOOKUP_TYPE = 'AUTHORIZED_ACTION'
AND LOOKUP_CODE = P_ACTIVITY;
SELECT
ORDER_NUMBER
INTO L_ENTITY_VALUE
FROM
OE_ORDER_HEADERS
WHERE HEADER_ID = OBJECT_ID;
SELECT
SUBSTRB(PARTY.PARTY_NAME
,1
,50)
INTO L_ENTITY_VALUE
FROM
HZ_PARTIES PARTY,
HZ_CUST_ACCOUNTS CUST_ACCT
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND CUST_ACCT.CUST_ACCOUNT_ID = OBJECT_ID;
SELECT
DESCRIPTION
INTO L_ENTITY_VALUE
FROM
MTL_SYSTEM_ITEMS_VL
WHERE INVENTORY_ITEM_ID = OBJECT_ID
AND NVL(ORGANIZATION_ID
,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'
,MO_GLOBAL.GET_CURRENT_ORG_ID)
,0);
SELECT
SUBSTR((LOC.ADDRESS1 || ', ' || LOC.CITY || ' ' || LOC.STATE)
,1
,30)
INTO L_ENTITY_VALUE
FROM
HZ_CUST_SITE_USES_ALL SU,
HZ_PARTY_SITES PARTY_SITE,
HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
HZ_LOCATIONS LOC,
HZ_CUST_ACCT_SITES_ALL ACCT_SITE
WHERE SU.SITE_USE_ID = OBJECT_ID
AND SU.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
AND SU.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID
AND NVL(ACCT_SITE.ORG_ID
,-99) = NVL(LOC_ASSIGN.ORG_ID
,-99);
SELECT
ORDER_NUMBER
INTO L_ENTITY_VALUE
FROM
OE_ORDER_HEADERS
WHERE HEADER_ID = OBJECT_ID2;
SELECT
SUBSTRB(PARTY.PARTY_NAME
,1
,50)
INTO L_ENTITY_VALUE
FROM
HZ_PARTIES PARTY,
HZ_CUST_ACCOUNTS CUST_ACCT
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND CUST_ACCT.CUST_ACCOUNT_ID = OBJECT_ID2;
SELECT
DESCRIPTION
INTO L_ENTITY_VALUE
FROM
MTL_SYSTEM_ITEMS_VL
WHERE INVENTORY_ITEM_ID = OBJECT_ID2
AND NVL(ORGANIZATION_ID
,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'
,MO_GLOBAL.GET_CURRENT_ORG_ID)
,0);
SELECT
SUBSTR((LOC.ADDRESS1 || ', ' || LOC.CITY || ' ' || LOC.STATE)
,1
,30)
INTO L_ENTITY_VALUE
FROM
HZ_CUST_SITE_USES_ALL SU,
HZ_PARTY_SITES PARTY_SITE,
HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
HZ_LOCATIONS LOC,
HZ_CUST_ACCT_SITES_ALL ACCT_SITE
WHERE SU.SITE_USE_ID = OBJECT_ID2
AND SU.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
AND SU.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID
AND NVL(ACCT_SITE.ORG_ID
,-99) = NVL(LOC_ASSIGN.ORG_ID
,-99);