[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
DECODE(P_ADDR_CHOICE
,'ADDRESS1'
,SUBSTR(L.ADDRESS_LINE_1
,1
,35)
,'LOCATION'
,LOCATION_CODE
,'REP_ENTITY'
,R.ENTITY_NAME
,SUBSTR(L.ADDRESS_LINE_1
,1
,35)),
DECODE(P_ADDR_CHOICE
,'ADDRESS1'
,SUBSTR(L.ADDRESS_LINE_2
,1
,35)
,'LOCATION'
,SUBSTR(L.ADDRESS_LINE_1
,1
,35)
,'REP_ENTITY'
,SUBSTR(L.ADDRESS_LINE_1
,1
,35)
,SUBSTR(L.ADDRESS_LINE_2
,1
,35)),
DECODE(P_ADDR_CHOICE
,'ADDRESS1'
,SUBSTR(L.ADDRESS_LINE_3
,1
,35)
,'LOCATION'
,SUBSTR(L.ADDRESS_LINE_2
,1
,35)
,'REP_ENTITY'
,SUBSTR(L.ADDRESS_LINE_2
,1
,35)
,SUBSTR(L.ADDRESS_LINE_3
,1
,35)),
DECODE(P_ADDR_CHOICE
,'ADDRESS1'
,NULL
,'LOCATION'
,SUBSTR(L.ADDRESS_LINE_3
,1
,35)
,'REP_ENTITY'
,SUBSTR(L.ADDRESS_LINE_3
,1
,35)
,SUBSTR(L.ADDRESS_LINE_3
,1
,35)),
SUBSTR(L.TOWN_OR_CITY
,1
,30),
SUBSTR(NVL(L.REGION_3
,L.REGION_2)
,1
,30),
SUBSTR(L.POSTAL_CODE
,1
,20),
L.LOCATION_ID,
TO_CHAR(P_RETURN_BY_DATE
,'fmMonth DD, YYYY'),
APL.DISPLAYED_FIELD
INTO FROM_ADDRESS_LINE1,FROM_ADDRESS_LINE2,FROM_ADDRESS_LINE3,FROM_ADDRESS_LINE4,FROM_CITY,FROM_STATE,FROM_ZIP,LOCATION_ID,DISP_RETURN_DATE,FROM_ATTENTION_LINE
FROM
HR_LOCATIONS L,
AP_REPORTING_ENTITIES R,
AP_LOOKUP_CODES APL
WHERE L.LOCATION_ID = R.LOCATION_ID
AND R.TAX_ENTITY_ID = P_TAX_ENTITY_ID
AND APL.LOOKUP_CODE = P_ATTENTION_LINE
AND APL.LOOKUP_TYPE = 'ATTENTION';
SELECT
FND.APPLICATION_COLUMN_NAME,
GL.CHART_OF_ACCOUNTS_ID
INTO APPLICATION_COLUMN_NAME,CHART_OF_ACCOUNTS_ID
FROM
FND_SEGMENT_ATTRIBUTE_VALUES FND,
GL_SETS_OF_BOOKS GL
WHERE SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'
AND FND.ATTRIBUTE_VALUE = 'Y'
AND FND.ID_FLEX_NUM = GL.CHART_OF_ACCOUNTS_ID
AND GL.SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID
AND ID_FLEX_CODE = 'GL#';