APPS.HXC_RESOURCE_RULES_UTILS dependencies on PAY_LEGISLATION_RULES

Line 37: FROM pay_legislation_rules

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;

Line 106: -- , pay_legislation_rules lr

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

Line 132: , pay_legislation_rules lr

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 **************

Line 373: , pay_legislation_rules lr

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

Line 1075: -- , pay_legislation_rules lr

1071: -- fnd_id_flex_segments_tl tl
1072: -- , fnd_id_flex_segments seg
1073: -- , fnd_id_flex_structures s
1074: -- , fnd_id_Flexs fl
1075: -- , pay_legislation_rules lr
1076: -- WHERE
1077: -- lr.legislation_code = 'US' AND
1078: -- lr.rule_type = 'S'
1079: -- AND

Line 1106: , pay_legislation_rules lr

1102: fnd_id_flex_segments_tl tl
1103: , fnd_id_flex_segments seg
1104: , fnd_id_flex_structures s
1105: , fnd_id_Flexs fl
1106: , pay_legislation_rules lr
1107: where
1108: lr.legislation_code = 'US' and
1109: lr.rule_type = 'S' and
1110: