eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_RESOURCE_RULES_UTILS dependencies on FND_ID_FLEXS

Line 9: l_id_flex_code fnd_id_flexs.id_flex_code%TYPE;

5:
6: PROCEDURE get_value_set_sql ( p_flex_Field_name varchar2
7: , p_legislation_code varchar2 ) IS
8:
9: l_id_flex_code fnd_id_flexs.id_flex_code%TYPE;
10: l_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
11: l_flex_seg varchar2(9);
12: l_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
13:

Line 22: , fnd_id_Flexs fl

18: , p_id_flex_num number ) IS
19: SELECT seg.flex_value_Set_id
20: FROM
21: fnd_id_flex_segments seg
22: , fnd_id_Flexs fl
23: WHERE
24: fl.id_flex_code = p_flex_code
25: AND
26: seg.id_flex_code= fl.id_flex_code AND

Line 105: -- , fnd_id_Flexs fl

101: -- SELECT seg.application_column_name
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

Line 131: , fnd_id_Flexs fl

127: SELECT seg.application_column_name
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

Line 167: -- , fnd_id_Flexs fl

163: -- SELECT seg.application_column_name
164: -- FROM
165: -- fnd_id_flex_segments seg
166: -- , fnd_id_flex_structures s
167: -- , fnd_id_Flexs fl
168: -- WHERE
169: -- fl.id_flex_name = 'People Group Flexfield'
170: -- AND
171: -- s.id_flex_code = fl.id_flex_code AND

Line 187: fnd_id_Flexs fl

183: select seg.application_column_name
184: from
185: fnd_id_flex_segments seg,
186: fnd_id_flex_structures s,
187: fnd_id_Flexs fl
188: where
189: -- ***** Start commented code for bug 2678547 **************
190: -- fl.id_flex_name = 'People Group Flexfield' and
191: -- ***** End commented code for bug 2678547 **************

Line 217: -- , fnd_id_Flexs fl

213: -- SELECT seg.application_column_name
214: -- FROM
215: -- fnd_id_flex_segments seg
216: -- , fnd_id_flex_structures s
217: -- , fnd_id_Flexs fl
218: -- WHERE
219: -- fl.id_flex_name = 'Grade Flexfield'
220: -- AND
221: -- s.id_flex_code = fl.id_flex_code AND

Line 238: , fnd_id_Flexs fl

234: select seg.application_column_name
235: from
236: fnd_id_flex_segments seg
237: , fnd_id_flex_structures s
238: , fnd_id_Flexs fl
239: where
240: -- ***** Start commented code for bug 2678547 **************
241: -- fl.id_flex_name = 'Grade Flexfield' and
242: -- ***** End commented code for bug 2678547 **************

Line 405: -- , fnd_id_Flexs fl

401: -- , ifs.id_flex_num
402: -- FROM
403: -- fnd_id_flex_segments seg
404: -- , fnd_id_flex_structures ifs
405: -- , fnd_id_Flexs fl
406: -- WHERE
407: -- fl.id_flex_name = 'People Group Flexfield'
408: -- AND
409: -- ifs.id_flex_code = fl.id_Flex_code AND

Line 435: , fnd_id_Flexs fl

431: , ifs.id_flex_num
432: from
433: fnd_id_flex_segments seg
434: , fnd_id_flex_structures ifs
435: , fnd_id_Flexs fl
436: where
437: -- ***** Start commented code for bug 2678547 **************
438: -- fl.id_flex_name = 'People Group Flexfield' AND
439: -- ***** End commented code for bug 2678547 **************

Line 485: -- , fnd_id_Flexs fl

481: -- , ifs.id_flex_num
482: -- FROM
483: -- fnd_id_flex_segments seg
484: -- , fnd_id_flex_structures ifs
485: -- , fnd_id_Flexs fl
486: -- WHERE
487: -- fl.id_flex_name = 'Grade Flexfield'
488: -- AND
489: -- ifs.id_flex_code = fl.id_Flex_code AND

Line 515: fnd_id_Flexs fl

511: ifs.id_flex_num
512: from
513: fnd_id_flex_segments seg,
514: fnd_id_flex_structures ifs,
515: fnd_id_Flexs fl
516: where
517: -- ***** Start commented code for bug 2678547 **************
518: -- fl.id_flex_name = 'Grade Flexfield' and
519: -- ***** End commented code for bug 2678547 **************

Line 895: -- , fnd_id_Flexs fl

891: -- FROM
892: -- fnd_id_flex_segments_tl tl
893: -- , fnd_id_flex_segments seg
894: -- , fnd_id_flex_structures s
895: -- , fnd_id_Flexs fl
896: -- WHERE
897: -- fl.id_flex_name = 'People Group Flexfield'
898: -- AND
899: -- s.id_flex_code = fl.id_flex_code AND

Line 929: , fnd_id_Flexs fl

925: FROM
926: fnd_id_flex_segments_tl tl
927: , fnd_id_flex_segments seg
928: , fnd_id_flex_structures s
929: , fnd_id_Flexs fl
930: WHERE
931: -- ***** Start commented code for bug 2678547 **************
932: -- fl.id_flex_name = 'People Group Flexfield' and
933: -- ***** End commented code for bug 2678547 **************

Line 981: -- , fnd_id_Flexs fl

977: -- FROM
978: -- fnd_id_flex_segments_tl tl
979: -- , fnd_id_flex_segments seg
980: -- , fnd_id_flex_structures s
981: -- , fnd_id_Flexs fl
982: -- WHERE
983: -- fl.id_flex_name = 'Grade Flexfield'
984: -- AND
985: -- s.id_flex_code = fl.id_flex_code AND

Line 1017: , fnd_id_Flexs fl

1013: from
1014: fnd_id_flex_segments_tl tl
1015: , fnd_id_flex_segments seg
1016: , fnd_id_flex_structures s
1017: , fnd_id_Flexs fl
1018: where
1019: -- ***** Start commented code for bug 2678547 **************
1020: -- fl.id_flex_name = 'Grade Flexfield' and
1021: -- ***** End commented code for bug 2678547 **************

Line 1067: -- , fnd_id_Flexs fl

1063: -- FROM
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'

Line 1098: , fnd_id_Flexs fl

1094: from
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