33: FUNCTION get_scl_flex_num RETURN NUMBER IS
34:
35: CURSOR csr_get_id_flex_num IS
36: SELECT rule_mode
37: FROM pay_legislation_rules
38: WHERE legislation_code = p_legislation_code
39: AND rule_type = 'S';
40:
41: l_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
102: -- FROM
103: -- fnd_id_flex_segments seg
104: -- , fnd_id_flex_structures s
105: -- , fnd_id_Flexs fl
106: -- , pay_legislation_rules lr
107: -- WHERE
108: -- fl.id_flex_name = 'Soft Coded KeyFlexfield'
109: -- AND
110: -- s.id_flex_code = fl.id_flex_code AND
128: FROM
129: fnd_id_flex_segments seg
130: , fnd_id_flex_structures s
131: , fnd_id_Flexs fl
132: , pay_legislation_rules lr
133: WHERE
134: -- ***** Start commented code for bug 2678547 **************
135: -- fl.id_flex_name = 'Soft Coded KeyFlexfield' AND
136: -- ***** End commented code for bug 2678547 **************
369: , lr.rule_mode
370: FROM
371: fnd_id_flex_segments seg
372: , fnd_id_flex_structures ifs
373: , pay_legislation_rules lr
374: WHERE
375: lr.legislation_code = p_legislation_code AND
376: lr.rule_type = 'S' AND
377: ifs.id_flex_num = lr.rule_mode AND
1064: -- fnd_id_flex_segments_tl tl
1065: -- , fnd_id_flex_segments seg
1066: -- , fnd_id_flex_structures s
1067: -- , fnd_id_Flexs fl
1068: -- , pay_legislation_rules lr
1069: -- WHERE
1070: -- lr.legislation_code = 'US' AND
1071: -- lr.rule_type = 'S'
1072: -- AND
1095: fnd_id_flex_segments_tl tl
1096: , fnd_id_flex_segments seg
1097: , fnd_id_flex_structures s
1098: , fnd_id_Flexs fl
1099: , pay_legislation_rules lr
1100: where
1101: lr.legislation_code = 'US' and
1102: lr.rule_type = 'S' and
1103: