[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT seg.flex_value_Set_id
FROM
fnd_id_flex_segments seg
, fnd_id_Flexs fl
WHERE
fl.id_flex_code = p_flex_code
AND
seg.id_flex_code= fl.id_flex_code AND
-- ***** Start new code for bug 2669059 **************
seg.application_id = fl.application_id AND
-- ***** End new code for bug 2669059 **************
seg.id_flex_num = p_id_flex_num;
SELECT rule_mode
FROM pay_legislation_rules
WHERE legislation_code = p_legislation_code
AND rule_type = 'S';
insert into gaz_value_set ( vset_id, name, where_clause )
values ( vset_rec.flex_value_set_id, r_valueset.name, r_valueset.table_info.where_clause );
SELECT seg.application_column_name
FROM
fnd_id_flex_segments seg
, fnd_id_flex_structures s
, fnd_id_Flexs fl
, pay_legislation_rules lr
WHERE
-- ***** Start commented code for bug 2678547 **************
-- fl.id_flex_name = 'Soft Coded KeyFlexfield' AND
-- ***** End commented code for bug 2678547 **************
-- ***** Start new code for bug 2678547 **************
fl.id_flex_code = 'SCL' AND
-- ***** End new code for bug 2678547 **************
fl.application_id = 800 AND
s.id_flex_code = fl.id_flex_code AND
s.application_id = fl.application_id AND
s.id_flex_num = seg.id_flex_num AND
s.id_flex_structure_code = 'GRES_AND_OTHER_DATA' AND
lr.legislation_code = 'US' AND
lr.rule_type = 'S' AND
seg.id_flex_num = lr.rule_mode AND
seg.application_id = s.application_id AND
seg.id_flex_code = fl.id_flex_code AND
seg.display_flag = 'Y'
ORDER BY seg.segment_num;
select seg.application_column_name
from
fnd_id_flex_segments seg,
fnd_id_flex_structures s,
fnd_id_Flexs fl
where
-- ***** Start commented code for bug 2678547 **************
-- fl.id_flex_name = 'People Group Flexfield' and
-- ***** End commented code for bug 2678547 **************
-- ***** Start new code for bug 2678547 **************
fl.id_flex_code = 'GRP' and
-- ***** End new code for bug 2678547 **************
fl.application_id = 801 and
s.id_flex_code = fl.id_flex_code and
s.application_id = fl.application_id and
s.id_flex_num = seg.id_flex_num and
seg.id_flex_num = p_id_flex_num and
seg.application_id = s.application_id and
seg.id_flex_code = fl.id_flex_code and
seg.display_flag = 'Y'
order by seg.segment_num;
select seg.application_column_name
from
fnd_id_flex_segments seg
, fnd_id_flex_structures s
, fnd_id_Flexs fl
where
-- ***** Start commented code for bug 2678547 **************
-- fl.id_flex_name = 'Grade Flexfield' and
-- ***** End commented code for bug 2678547 **************
-- ***** Start new code for bug 2678547 **************
fl.id_flex_code = 'GRD' and
-- ***** End new code for bug 2678547 **************
fl.application_id = 800 and
s.id_flex_code = fl.id_flex_code and
s.application_id = fl.application_id and
s.id_flex_num = seg.id_flex_num and
seg.id_flex_num = p_id_flex_num and
seg.application_id = s.application_id and
seg.id_flex_code = fl.id_flex_code and
seg.display_flag = 'Y'
order by seg.segment_num;
SELECT COUNT( seg.display_flag)
, ifs.concatenated_segment_delimiter
, lr.rule_mode
FROM
fnd_id_flex_segments seg
, fnd_id_flex_structures ifs
, pay_legislation_rules lr
WHERE
lr.legislation_code = p_legislation_code AND
lr.rule_type = 'S' AND
ifs.id_flex_num = lr.rule_mode AND
-- ***** Start new code for bug 2669059 **************
ifs.application_id = 800 AND
-- ***** End new code for bug 2669059 **************
seg.id_flex_num = ifs.id_flex_num AND
-- ***** Start new code for bug 2669059 **************
seg.application_id = ifs.application_id AND
-- ***** End new code for bug 2669059 **************
seg.display_flag = 'Y'
GROUP BY
ifs.concatenated_segment_delimiter
, lr.rule_mode;
select
COUNT(seg.display_flag)
, ifs.concatenated_segment_delimiter
, ifs.id_flex_num
from
fnd_id_flex_segments seg
, fnd_id_flex_structures ifs
, fnd_id_Flexs fl
where
-- ***** Start commented code for bug 2678547 **************
-- fl.id_flex_name = 'People Group Flexfield' AND
-- ***** End commented code for bug 2678547 **************
-- ***** Start new code for bug 2678547 **************
fl.id_flex_code = 'GRP' AND
-- ***** End new code for bug 2678547 **************
fl.application_id = 801 AND
ifs.id_flex_code = fl.id_Flex_code AND
ifs.application_id = fl.application_id AND
ifs.id_flex_num =
(
--***** Start new code for Bug 5089488**************
select hoi.ORG_INFORMATION5
from hr_organization_units hou,
hr_organization_information hoi,
hr_organization_information hoi2
where hou.business_group_id = p_business_group_id
and hou.organization_id = hoi.organization_id
and hoi.organization_id = hoi2.organization_id
and hoi.org_information_context = 'Business Group Information'
and sysdate between hou.Date_from and nvl(hou.date_to,sysdate)
and hoi2.org_information1='HR_BG' and hoi2.org_information2='Y'
--***** end new code for Bug 5089488**************
) AND
seg.id_flex_num = ifs.id_flex_num AND
seg.application_id = ifs.application_id AND
-- Bug 2926733
seg.id_flex_code = ifs.id_flex_code AND
seg.display_flag = 'Y'
group by
ifs.concatenated_segment_delimiter
, ifs.id_flex_num;
select
COUNT(seg.display_flag),
ifs.concatenated_segment_delimiter,
ifs.id_flex_num
from
fnd_id_flex_segments seg,
fnd_id_flex_structures ifs,
fnd_id_Flexs fl
where
-- ***** Start commented code for bug 2678547 **************
-- fl.id_flex_name = 'Grade Flexfield' and
-- ***** End commented code for bug 2678547 **************
-- ***** Start new code for bug 2678547 **************
fl.id_flex_code = 'GRD' and
-- ***** End new code for bug 2678547 **************
fl.application_id = 800 and
ifs.id_flex_code = fl.id_Flex_code and
ifs.application_id = fl.application_id and
ifs.id_flex_num =
(
--***** start new code for Bug 5089488**************
select hoi.ORG_INFORMATION4
from hr_organization_units hou,
hr_organization_information hoi,
hr_organization_information hoi2
where hou.business_group_id = p_business_group_id
and hou.organization_id = hoi.organization_id
and hoi.organization_id = hoi2.organization_id
and hoi.org_information_context = 'Business Group Information'
and sysdate between hou.Date_from and nvl(hou.date_to,sysdate)
and hoi2.org_information1='HR_BG' and hoi2.org_information2='Y'
--***** end new code for Bug 5089488**************
) and
seg.id_flex_num = ifs.id_flex_num and
seg.application_id = ifs.application_id and
-- Bug 2926733
seg.id_flex_code = ifs.id_flex_code AND
seg.display_flag = 'Y'
group by
ifs.concatenated_segment_delimiter,
ifs.id_flex_num;
SELECT
DECODE ( p_sequence,
-- Bug 2926733
--1, SUBSTR( concatenated_segments, 0, INSTR ( concatenated_segments, p_delimiter, 1, 1 )-1),
1, SUBSTR( concatenated_segments, 0,DECODE(INSTR ( concatenated_segments,p_delimiter,1,1),0,LENGTH(concatenated_segments),
INSTR ( concatenated_segments, p_delimiter, 1,1)-1)),
p_max_sequence, SUBSTR( concatenated_segments, INSTR( concatenated_segments, p_delimiter, 1, (p_sequence-1))+1),
SUBSTR( concatenated_segments, (INSTR( concatenated_segments, p_delimiter, 1, (p_sequence-1))+1),
( INSTR( concatenated_segments, p_delimiter, 1, p_sequence)
-(INSTR( concatenated_segments, p_delimiter, 1, (p_sequence-1))+1)))) meaning
FROM hr_soft_coding_keyflex
WHERE id_flex_num = p_id_flex_num
AND DECODE ( SUBSTR( p_type, 5 ),
'SEGMENT1', segment1,
'SEGMENT2', segment2,
'SEGMENT3', segment3,
'SEGMENT4', segment4,
'SEGMENT5', segment5,
'SEGMENT6', segment6,
'SEGMENT7', segment7,
'SEGMENT8', segment8,
'SEGMENT9', segment9,
'SEGMENT10', segment10,
'SEGMENT11', segment11,
'SEGMENT12', segment12,
'SEGMENT13', segment13,
'SEGMENT14', segment14,
'SEGMENT15', segment15,
'SEGMENT16', segment16,
'SEGMENT17', segment17,
'SEGMENT18', segment18,
'SEGMENT19', segment19,
'SEGMENT20', segment20,
'SEGMENT21', segment21,
'SEGMENT22', segment22,
'SEGMENT23', segment23,
'SEGMENT24', segment24,
'SEGMENT25', segment25,
'SEGMENT26', segment26,
'SEGMENT27', segment27,
'SEGMENT28', segment28,
'SEGMENT29', segment29,
'SEGMENT30', segment30, -1 ) = p_value;
SELECT
DECODE ( p_sequence,
-- Bug 2926733
-- 1, SUBSTR( group_name, 0, INSTR ( group_name, p_delimiter, 1, 1 )-1),
1, SUBSTR( group_name, 0,DECODE(INSTR ( group_name,p_delimiter,1,1),0,LENGTH(group_name),
INSTR ( group_name, p_delimiter, 1,1)-1)),
p_max_sequence, SUBSTR( group_name, INSTR( group_name, p_delimiter, 1, (p_sequence-1))+1),
SUBSTR( group_name, (INSTR( group_name, p_delimiter, 1, (p_sequence-1))+1),
( INSTR( group_name, p_delimiter, 1, p_sequence)
-(INSTR( group_name, p_delimiter, 1, (p_sequence-1))+1)))) meaning
FROM pay_people_groups
WHERE id_flex_num = p_id_flex_num
AND DECODE ( SUBSTR( p_type, 8 ),
'SEGMENT1', segment1,
'SEGMENT2', segment2,
'SEGMENT3', segment3,
'SEGMENT4', segment4,
'SEGMENT5', segment5,
'SEGMENT6', segment6,
'SEGMENT7', segment7,
'SEGMENT8', segment8,
'SEGMENT9', segment9,
'SEGMENT10', segment10,
'SEGMENT11', segment11,
'SEGMENT12', segment12,
'SEGMENT13', segment13,
'SEGMENT14', segment14,
'SEGMENT15', segment15,
'SEGMENT16', segment16,
'SEGMENT17', segment17,
'SEGMENT18', segment18,
'SEGMENT19', segment19,
'SEGMENT20', segment20,
'SEGMENT21', segment21,
'SEGMENT22', segment22,
'SEGMENT23', segment23,
'SEGMENT24', segment24,
'SEGMENT25', segment25,
'SEGMENT26', segment26,
'SEGMENT27', segment27,
'SEGMENT28', segment28,
'SEGMENT29', segment29,
'SEGMENT30', segment30, -1 ) = p_value;
SELECT
DECODE ( p_sequence,
-- Bug 2926733
--1, SUBSTR( g.name, 0, INSTR ( g.name, p_delimiter, 1, 1 )-1),
1, SUBSTR( g.name, 0,DECODE(INSTR ( g.name,p_delimiter,1,1),0,LENGTH(g.name),
INSTR ( g.name, p_delimiter, 1,1)-1)),
p_max_sequence, SUBSTR( g.name, INSTR( g.name, p_delimiter, 1, (p_sequence-1))+1),
SUBSTR( g.name, (INSTR( g.name, p_delimiter, 1, (p_sequence-1))+1),
( INSTR( g.name, p_delimiter, 1, p_sequence)
-(INSTR( g.name, p_delimiter, 1, (p_sequence-1))+1)))) meaning
FROM per_grades_vl g
, per_grade_definitions gd
WHERE gd.id_flex_num = p_id_flex_num
AND gd.grade_definition_id = g.grade_definition_id
AND DECODE ( SUBSTR( p_type, 7 ),
'SEGMENT1', gd.segment1,
'SEGMENT2', gd.segment2,
'SEGMENT3', gd.segment3,
'SEGMENT4', gd.segment4,
'SEGMENT5', gd.segment5,
'SEGMENT6', gd.segment6,
'SEGMENT7', gd.segment7,
'SEGMENT8', gd.segment8,
'SEGMENT9', gd.segment9,
'SEGMENT10', gd.segment10,
'SEGMENT11', gd.segment11,
'SEGMENT12', gd.segment12,
'SEGMENT13', gd.segment13,
'SEGMENT14', gd.segment14,
'SEGMENT15', gd.segment15,
'SEGMENT16', gd.segment16,
'SEGMENT17', gd.segment17,
'SEGMENT18', gd.segment18,
'SEGMENT19', gd.segment19,
'SEGMENT20', gd.segment20,
'SEGMENT21', gd.segment21,
'SEGMENT22', gd.segment22,
'SEGMENT23', gd.segment23,
'SEGMENT24', gd.segment24,
'SEGMENT25', gd.segment25,
'SEGMENT26', gd.segment26,
'SEGMENT27', gd.segment27,
'SEGMENT28', gd.segment28,
'SEGMENT29', gd.segment29,
'SEGMENT30', gd.segment30, -1 ) = p_value;
SELECT
tl.form_left_prompt meaning
FROM
fnd_id_flex_segments_tl tl
, fnd_id_flex_segments seg
, fnd_id_flex_structures s
, fnd_id_Flexs fl
WHERE
-- ***** Start commented code for bug 2678547 **************
-- fl.id_flex_name = 'People Group Flexfield' and
-- ***** End commented code for bug 2678547 **************
-- ***** Start new code for bug 2678547 **************
fl.id_flex_code = 'GRP' and
-- ***** End new code for bug 2678547 **************
fl.application_id = 801 AND
s.id_flex_code = fl.id_flex_code AND
s.application_id = fl.application_id and
s.id_flex_num = seg.id_flex_num AND
seg.id_flex_code = fl.id_flex_code AND
seg.application_id = fl.application_id AND
seg.id_flex_num =
(
--***** start new code for Bug 5089488**************
select hoi.ORG_INFORMATION5
from hr_organization_units hou,
hr_organization_information hoi,
hr_organization_information hoi2
where hou.business_group_id = p_business_group_id
and hou.organization_id = hoi.organization_id
and hoi.organization_id = hoi2.organization_id
and hoi.org_information_context = 'Business Group Information'
and sysdate between hou.Date_from and nvl(hou.date_to,sysdate)
and hoi2.org_information1='HR_BG' and hoi2.org_information2='Y'
--***** end new code for Bug 5089488**************
)
and
seg.display_flag = 'Y' and
seg.application_column_name = SUBSTR(p_type, 8) and
tl.application_id = seg.application_id and
tl.id_flex_num = seg.id_flex_num and
tl.id_flex_code = seg.id_flex_code and
tl.language = USERENV('LANG') and
tl.application_column_name = seg.application_column_name;
select
tl.form_left_prompt meaning
from
fnd_id_flex_segments_tl tl
, fnd_id_flex_segments seg
, fnd_id_flex_structures s
, fnd_id_Flexs fl
where
-- ***** Start commented code for bug 2678547 **************
-- fl.id_flex_name = 'Grade Flexfield' and
-- ***** End commented code for bug 2678547 **************
-- ***** Start new code for bug 2678547 **************
fl.id_flex_code = 'GRD' and
-- ***** End new code for bug 2678547 **************
fl.application_id = 800 and
s.id_flex_code = fl.id_flex_code and
s.application_id = fl.application_id and
s.id_flex_num = seg.id_flex_num and
seg.id_flex_code = fl.id_flex_code and
seg.application_id = fl.application_id and
seg.id_flex_num =
(
--***** start new code for Bug 5089488**************
select hoi.ORG_INFORMATION4
from hr_organization_units hou,
hr_organization_information hoi,
hr_organization_information hoi2
where hou.business_group_id = p_business_group_id
and hou.organization_id = hoi.organization_id
and hoi.organization_id = hoi2.organization_id
and hoi.org_information_context = 'Business Group Information'
and sysdate between hou.Date_from and nvl(hou.date_to,sysdate)
and hoi2.org_information1='HR_BG' and hoi2.org_information2='Y'
--***** end new code for Bug 5089488**************
) and
seg.display_flag = 'Y' and
seg.application_column_name = SUBSTR(p_type, 7) and
tl.application_id = seg.application_id and
tl.id_flex_num = seg.id_flex_num and
tl.id_flex_code = seg.id_flex_code and
tl.language = USERENV('LANG') and
tl.application_column_name = seg.application_column_name;
select tl.form_left_prompt meaning
from
fnd_id_flex_segments_tl tl
, fnd_id_flex_segments seg
, fnd_id_flex_structures s
, fnd_id_Flexs fl
, pay_legislation_rules lr
where
lr.legislation_code = 'US' and
lr.rule_type = 'S' and
-- ***** Start commented code for bug 2678547 **************
-- fl.id_flex_name = 'Soft Coded KeyFlexfield' and
-- ***** End commented code for bug 2678547 **************
-- ***** Start new code for bug 2678547 **************
fl.id_flex_code = 'SCL' and
-- ***** End new code for bug 2678547 **************
fl.application_id = 800 and
s.id_flex_code = fl.id_flex_code and
s.application_id = fl.application_id and
s.id_flex_num = seg.id_flex_num and
seg.id_flex_code = fl.id_flex_code and
seg.application_id = fl.application_id and
seg.id_flex_num = lr.rule_mode and
seg.display_flag = 'Y' and
seg.application_column_name = SUBSTR(p_type,5) and
tl.application_id = seg.application_id and
tl.id_flex_num = seg.id_flex_num and
tl.id_flex_code = seg.id_flex_code and
tl.language = USERENV('LANG') and
tl.application_column_name = seg.application_column_name;
select 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 scl
WHERE scl.soft_coding_keyflex_id = p_flex_id;
select 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 pay_people_groups grp
WHERE grp.people_group_id = p_flex_id;
select gd.SEGMENT1,gd.SEGMENT2,gd.SEGMENT3,gd.SEGMENT4,gd.SEGMENT5,gd.SEGMENT6,gd.SEGMENT7,gd.SEGMENT8,gd.SEGMENT9,gd.SEGMENT10,
gd.SEGMENT11,gd.SEGMENT12,gd.SEGMENT13,gd.SEGMENT14,gd.SEGMENT15,gd.SEGMENT16,gd.SEGMENT17,gd.SEGMENT18,gd.SEGMENT19,gd.SEGMENT20,
gd.SEGMENT21,gd.SEGMENT22,gd.SEGMENT23,gd.SEGMENT24,gd.SEGMENT25,gd.SEGMENT26,gd.SEGMENT27,gd.SEGMENT28,gd.SEGMENT29,gd.SEGMENT30
FROM per_grades g,per_grade_definitions gd
WHERE g.grade_id = p_flex_id
AND gd.grade_definition_id = g.grade_definition_id;
SELECT '1' FROM hxc_resource_rules
WHERE eligibility_criteria_type = p_eligibility_criteria_type
and eligibility_criteria_id = p_eligibility_criteria_id;