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 894: -- , fnd_id_flex_structures s

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

Line 928: , fnd_id_flex_structures s

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

Line 980: -- , fnd_id_flex_structures s

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

Line 1016: , fnd_id_flex_structures s

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

Line 1066: -- , fnd_id_flex_structures s

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

Line 1097: , fnd_id_flex_structures s

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