[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DECODE(p_info_number,
3,poei_information3,
5,poei_information5,
12,poei_information12)
FROM per_position_extra_info
WHERE information_type = p_info_type
AND position_id = p_position_id;
SELECT decode(p_info_number,
3,rei_information3,
4,rei_information4,
5,rei_information5,
6,rei_information6)
FROM ghr_pa_request_extra_info
WHERE information_type = 'GHR_US_PD_GEN_EMP'
AND pa_request_id = p_pa_req_id;
SELECT description
FROM GHR_PAY_PLANS
WHERE pay_plan = p_lookup_cd;
SELECT
DECODE(flex_seg.SEGMENT_NUM,
1, ppd.SEGMENT1, 2,ppd.SEGMENT2, 3, ppd.SEGMENT3,
4,ppd.SEGMENT4, 5,ppd.SEGMENT5,6,ppd.SEGMENT6,
7, ppd.SEGMENT7,
8,ppd.SEGMENT8, 9,ppd.SEGMENT9,10,ppd.SEGMENT10,
11, ppd.SEGMENT11,
12,ppd.SEGMENT12, 13,ppd.SEGMENT13,14,ppd.SEGMENT14, 15, ppd.SEGMENT15,
16,ppd.SEGMENT16, 17,ppd.SEGMENT17,18,ppd.SEGMENT18, 19, ppd.SEGMENT19,
20,ppd.SEGMENT20, 21,ppd.SEGMENT21,22,ppd.SEGMENT22,
23, ppd.SEGMENT23,
24,ppd.SEGMENT24, 25,ppd.SEGMENT25,26,ppd.SEGMENT26, 27, ppd.SEGMENT27,
28,ppd.SEGMENT28, 29,ppd.SEGMENT29,30,ppd.SEGMENT30)
FROM
PER_POSITION_DEFINITIONS PPD,
FND_ID_FLEX_STRUCTURES_TL flex_struct ,
FND_ID_FLEX_SEGMENTS flex_seg,
PER_POSITIONS pos
WHERE pos.POSITION_ID = p_position_id
AND ppd.POSITION_DEFINITION_ID = pos.POSITION_DEFINITION_ID
AND ppd.enabled_FLAG = 'Y'
AND NVL(ppd.START_DATE_ACTIVE,sysdate) <= sysdate
AND (ppd.END_DATE_ACTIVE IS NULL
OR ppd.END_DATE_ACTIVE > sysdate)
AND flex_struct.ID_FLEX_NUM = PPD.ID_FLEX_NUM
AND flex_struct.ID_FLEX_STRUCTURE_NAME = p_structure
AND flex_struct.LANGUAGE = 'US'
AND flex_seg.ID_FLEX_NUM = flex_struct.ID_FLEX_NUM
AND flex_seg.ID_FLEX_CODE = flex_struct.ID_FLEX_CODE
AND flex_seg.SEGMENT_NAME = p_segment;