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 892: -- fnd_id_flex_segments_tl tl

888: -- CURSOR csr_get_people_tl IS
889: -- SELECT
890: -- tl.form_left_prompt meaning
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

Line 893: -- , fnd_id_flex_segments seg

889: -- SELECT
890: -- tl.form_left_prompt meaning
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'

Line 926: fnd_id_flex_segments_tl tl

922: CURSOR csr_get_people_tl IS
923: SELECT
924: tl.form_left_prompt meaning
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

Line 927: , fnd_id_flex_segments seg

923: SELECT
924: tl.form_left_prompt meaning
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 **************

Line 978: -- fnd_id_flex_segments_tl tl

974: -- CURSOR csr_get_grade_tl IS
975: -- SELECT
976: -- tl.form_left_prompt meaning
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

Line 979: -- , fnd_id_flex_segments seg

975: -- SELECT
976: -- tl.form_left_prompt meaning
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'

Line 1014: fnd_id_flex_segments_tl tl

1010: CURSOR csr_get_grade_tl IS
1011: select
1012: tl.form_left_prompt meaning
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

Line 1015: , fnd_id_flex_segments seg

1011: select
1012: tl.form_left_prompt meaning
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 **************

Line 1064: -- fnd_id_flex_segments_tl tl

1060:
1061: -- CURSOR csr_get_scl_tl IS
1062: -- SELECT tl.form_left_prompt meaning
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

Line 1065: -- , fnd_id_flex_segments seg

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

Line 1095: fnd_id_flex_segments_tl tl

1091:
1092: CURSOR csr_get_scl_tl IS
1093: select tl.form_left_prompt meaning
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

Line 1096: , fnd_id_flex_segments seg

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