[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select plr.rule_mode id_flex_num
from pay_legislation_rules plr,
per_business_groups pbg
where pbg.business_group_id = p_business_group_id
and plr.legislation_code = pbg.legislation_code
and plr.rule_type = 'S'
and exists
(select 1
from fnd_segment_attribute_values fsav
where fsav.id_flex_num = plr.rule_mode
and fsav.application_id = 800
and fsav.id_flex_code = 'SCL'
and fsav.segment_attribute_type = 'ASSIGNMENT'
and fsav.attribute_value = 'Y')
and exists
(select 1
from pay_legislation_rules plr2
where plr2.legislation_code = pbg.legislation_code
and plr2.rule_type = 'SDL'
and plr2.rule_mode = 'A') ;
select scl.soft_coding_keyflex_id,
scl.concatenated_segments
from hr_soft_coding_keyflex scl
where scl.id_flex_num = l_id_flex_num
and scl.enabled_flag = 'Y'
and (scl.segment1 = p_segment1
or (scl.segment1 is null
and p_segment1 is null))
and (scl.segment2 = p_segment2
or (scl.segment2 is null
and p_segment2 is null))
and (scl.segment3 = p_segment3
or (scl.segment3 is null
and p_segment3 is null))
and (scl.segment4 = p_segment4
or (scl.segment4 is null
and p_segment4 is null))
and (scl.segment5 = p_segment5
or (scl.segment5 is null
and p_segment5 is null))
and (scl.segment6 = p_segment6
or (scl.segment6 is null
and p_segment6 is null))
and (scl.segment7 = p_segment7
or (scl.segment7 is null
and p_segment7 is null))
and (scl.segment8 = p_segment8
or (scl.segment8 is null
and p_segment8 is null))
and (scl.segment9 = p_segment9
or (scl.segment9 is null
and p_segment9 is null))
and (scl.segment10 = p_segment10
or (scl.segment10 is null
and p_segment10 is null))
and (scl.segment11 = p_segment11
or (scl.segment11 is null
and p_segment11 is null))
and (scl.segment12 = p_segment12
or (scl.segment12 is null
and p_segment12 is null))
and (scl.segment13 = p_segment13
or (scl.segment13 is null
and p_segment13 is null))
and (scl.segment14 = p_segment14
or (scl.segment14 is null
and p_segment14 is null))
and (scl.segment15 = p_segment15
or (scl.segment15 is null
and p_segment15 is null))
and (scl.segment16 = p_segment16
or (scl.segment16 is null
and p_segment16 is null))
and (scl.segment17 = p_segment17
or (scl.segment17 is null
and p_segment17 is null))
and (scl.segment18 = p_segment18
or (scl.segment18 is null
and p_segment18 is null))
and (scl.segment19 = p_segment19
or (scl.segment19 is null
and p_segment19 is null))
and (scl.segment20 = p_segment20
or (scl.segment20 is null
and p_segment20 is null))
and (scl.segment21 = p_segment21
or (scl.segment21 is null
and p_segment21 is null))
and (scl.segment22 = p_segment22
or (scl.segment22 is null
and p_segment22 is null))
and (scl.segment23 = p_segment23
or (scl.segment23 is null
and p_segment23 is null))
and (scl.segment24 = p_segment24
or (scl.segment24 is null
and p_segment24 is null))
and (scl.segment25 = p_segment25
or (scl.segment25 is null
and p_segment25 is null))
and (scl.segment26 = p_segment26
or (scl.segment26 is null
and p_segment26 is null))
and (scl.segment27 = p_segment27
or (scl.segment27 is null
and p_segment27 is null))
and (scl.segment28 = p_segment28
or (scl.segment28 is null
and p_segment28 is null))
and (scl.segment29 = p_segment29
or (scl.segment29 is null
and p_segment29 is null))
and (scl.segment30 = p_segment30
or (scl.segment30 is null
and p_segment30 is null));
select
soft_coding_keyflex_id,
concatenated_segments,
request_id,
program_application_id,
program_id,
program_update_date,
id_flex_num,
summary_flag,
enabled_flag,
start_date_active,
end_date_active,
segment1,
segment2,
segment3,
segment4,
segment5,
segment6,
segment7,
segment8,
segment9,
segment10,
segment11,
segment12,
segment13,
segment14,
segment15,
segment16,
segment17,
segment18,
segment19,
segment20,
segment21,
segment22,
segment23,
segment24,
segment25,
segment26,
segment27,
segment28,
segment29,
segment30
from hr_soft_coding_keyflex
where soft_coding_keyflex_id = p_soft_coding_keyflex_id;
p_program_update_date in date,
p_id_flex_num in number,
p_summary_flag in varchar2,
p_enabled_flag in varchar2,
p_start_date_active in date,
p_end_date_active in date,
p_segment1 in varchar2,
p_segment2 in varchar2,
p_segment3 in varchar2,
p_segment4 in varchar2,
p_segment5 in varchar2,
p_segment6 in varchar2,
p_segment7 in varchar2,
p_segment8 in varchar2,
p_segment9 in varchar2,
p_segment10 in varchar2,
p_segment11 in varchar2,
p_segment12 in varchar2,
p_segment13 in varchar2,
p_segment14 in varchar2,
p_segment15 in varchar2,
p_segment16 in varchar2,
p_segment17 in varchar2,
p_segment18 in varchar2,
p_segment19 in varchar2,
p_segment20 in varchar2,
p_segment21 in varchar2,
p_segment22 in varchar2,
p_segment23 in varchar2,
p_segment24 in varchar2,
p_segment25 in varchar2,
p_segment26 in varchar2,
p_segment27 in varchar2,
p_segment28 in varchar2,
p_segment29 in varchar2,
p_segment30 in varchar2
)
Return g_rec_type is
--
l_rec g_rec_type;
l_rec.program_update_date := p_program_update_date;