APPS.HXC_RESOURCE_RULES_UTILS dependencies on FND_ID_FLEX_STRUCTURES

Line 104: -- , fnd_id_flex_structures s

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
108: -- fl.id_flex_name = 'Soft Coded KeyFlexfield'

Line 130: , fnd_id_flex_structures s

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
134: -- ***** Start commented code for bug 2678547 **************

Line 166: -- , fnd_id_flex_structures s

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'
170: -- AND

Line 186: fnd_id_flex_structures s,

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 **************
190: -- fl.id_flex_name = 'People Group Flexfield' and

Line 216: -- , fnd_id_flex_structures s

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'
220: -- AND

Line 237: , fnd_id_flex_structures s

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 **************
241: -- fl.id_flex_name = 'Grade Flexfield' and

Line 372: , fnd_id_flex_structures ifs

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
376: lr.rule_type = 'S' AND

Line 404: -- , fnd_id_flex_structures ifs

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'
408: -- AND

Line 434: , fnd_id_flex_structures ifs

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 **************
438: -- fl.id_flex_name = 'People Group Flexfield' AND

Line 484: -- , fnd_id_flex_structures ifs

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'
488: -- AND

Line 514: fnd_id_flex_structures ifs,

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 **************
518: -- fl.id_flex_name = 'Grade Flexfield' and

Line 901: -- , fnd_id_flex_structures s

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'
905: -- AND

Line 935: , fnd_id_flex_structures s

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 **************
939: -- fl.id_flex_name = 'People Group Flexfield' and

Line 987: -- , fnd_id_flex_structures s

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'
991: -- AND

Line 1023: , fnd_id_flex_structures s

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 **************
1027: -- fl.id_flex_name = 'Grade Flexfield' and

Line 1073: -- , fnd_id_flex_structures s

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
1077: -- lr.legislation_code = 'US' AND

Line 1104: , fnd_id_flex_structures s

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
1108: lr.legislation_code = 'US' and