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 902: -- , fnd_id_Flexs fl

898: -- FROM
899: -- fnd_id_flex_segments_tl tl
900: -- , fnd_id_flex_segments seg
901: -- , fnd_id_flex_structures s
902: -- , fnd_id_Flexs fl
903: -- WHERE
904: -- fl.id_flex_name = 'People Group Flexfield'
905: -- AND
906: -- s.id_flex_code = fl.id_flex_code AND

Line 936: , fnd_id_Flexs fl

932: FROM
933: fnd_id_flex_segments_tl tl
934: , fnd_id_flex_segments seg
935: , fnd_id_flex_structures s
936: , fnd_id_Flexs fl
937: WHERE
938: -- ***** Start commented code for bug 2678547 **************
939: -- fl.id_flex_name = 'People Group Flexfield' and
940: -- ***** End commented code for bug 2678547 **************

Line 988: -- , fnd_id_Flexs fl

984: -- FROM
985: -- fnd_id_flex_segments_tl tl
986: -- , fnd_id_flex_segments seg
987: -- , fnd_id_flex_structures s
988: -- , fnd_id_Flexs fl
989: -- WHERE
990: -- fl.id_flex_name = 'Grade Flexfield'
991: -- AND
992: -- s.id_flex_code = fl.id_flex_code AND

Line 1024: , fnd_id_Flexs fl

1020: from
1021: fnd_id_flex_segments_tl tl
1022: , fnd_id_flex_segments seg
1023: , fnd_id_flex_structures s
1024: , fnd_id_Flexs fl
1025: where
1026: -- ***** Start commented code for bug 2678547 **************
1027: -- fl.id_flex_name = 'Grade Flexfield' and
1028: -- ***** End commented code for bug 2678547 **************

Line 1074: -- , fnd_id_Flexs fl

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

Line 1105: , fnd_id_Flexs fl

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