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_FLEX_SEGMENTS

Line 10: l_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

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:
14: r_valueset fnd_vset.valueset_r;

Line 21: fnd_id_flex_segments seg

17: CURSOR csr_get_scl_vset_id ( p_flex_code varchar2
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

Line 41: l_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

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;
42:
43: BEGIN
44:
45: OPEN csr_get_id_flex_num;

Line 103: -- fnd_id_flex_segments seg

99:
100: -- CURSOR csr_scl_get_seq IS
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

Line 129: fnd_id_flex_segments seg

125:
126: CURSOR csr_scl_get_seq IS
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

Line 165: -- fnd_id_flex_segments seg

161:
162: -- CURSOR csr_people_get_seq IS
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'

Line 185: fnd_id_flex_segments seg,

181:
182: CURSOR csr_people_get_seq IS
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 **************

Line 215: -- fnd_id_flex_segments seg

211:
212: -- CURSOR csr_grade_get_seq IS
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'

Line 236: fnd_id_flex_segments seg

232:
233: CURSOR csr_grade_get_seq IS
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 **************

Line 371: fnd_id_flex_segments seg

367: SELECT COUNT( seg.display_flag)
368: , ifs.concatenated_segment_delimiter
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

Line 403: -- fnd_id_flex_segments seg

399: -- COUNT(seg.display_flag)
400: -- , ifs.concatenated_segment_delimiter
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'

Line 433: fnd_id_flex_segments seg

429: COUNT(seg.display_flag)
430: , ifs.concatenated_segment_delimiter
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 **************

Line 483: -- fnd_id_flex_segments seg

479: -- COUNT(seg.display_flag)
480: -- , ifs.concatenated_segment_delimiter
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'

Line 513: fnd_id_flex_segments seg,

509: COUNT(seg.display_flag),
510: ifs.concatenated_segment_delimiter,
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 **************

Line 899: -- fnd_id_flex_segments_tl tl

895: -- CURSOR csr_get_people_tl IS
896: -- SELECT
897: -- tl.form_left_prompt meaning
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

Line 900: -- , fnd_id_flex_segments seg

896: -- SELECT
897: -- tl.form_left_prompt meaning
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'

Line 933: fnd_id_flex_segments_tl tl

929: CURSOR csr_get_people_tl IS
930: SELECT
931: tl.form_left_prompt meaning
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

Line 934: , fnd_id_flex_segments seg

930: SELECT
931: tl.form_left_prompt meaning
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 **************

Line 985: -- fnd_id_flex_segments_tl tl

981: -- CURSOR csr_get_grade_tl IS
982: -- SELECT
983: -- tl.form_left_prompt meaning
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

Line 986: -- , fnd_id_flex_segments seg

982: -- SELECT
983: -- tl.form_left_prompt meaning
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'

Line 1021: fnd_id_flex_segments_tl tl

1017: CURSOR csr_get_grade_tl IS
1018: select
1019: tl.form_left_prompt meaning
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

Line 1022: , fnd_id_flex_segments seg

1018: select
1019: tl.form_left_prompt meaning
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 **************

Line 1071: -- fnd_id_flex_segments_tl tl

1067:
1068: -- CURSOR csr_get_scl_tl IS
1069: -- SELECT tl.form_left_prompt meaning
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

Line 1072: -- , fnd_id_flex_segments seg

1068: -- CURSOR csr_get_scl_tl IS
1069: -- SELECT tl.form_left_prompt meaning
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

Line 1102: fnd_id_flex_segments_tl tl

1098:
1099: CURSOR csr_get_scl_tl IS
1100: select tl.form_left_prompt meaning
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

Line 1103: , fnd_id_flex_segments seg

1099: CURSOR csr_get_scl_tl IS
1100: select tl.form_left_prompt meaning
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