APPS.XLA_SOURCES_PKG dependencies on XLA_SEG_RULES_B

Line 96: FROM xla_seg_rules_b a

92: --
93: CURSOR c_seg_rules
94: IS
95: SELECT a.application_id, a.amb_context_code, a.segment_rule_type_code, a.segment_rule_code
96: FROM xla_seg_rules_b a
97: WHERE exists (SELECT 'x'
98: FROM xla_seg_rule_details sd
99: WHERE ((value_source_application_id = p_der_application_id
100: AND value_source_type_code = p_der_source_type_code

Line 446: FROM xla_seg_rules_b a

442:
443: CURSOR c_seg_rules
444: IS
445: SELECT a.application_id, a.amb_context_code, a.segment_rule_type_code, a.segment_rule_code
446: FROM xla_seg_rules_b a
447: WHERE exists (SELECT 'x'
448: FROM xla_seg_rule_details sd
449: WHERE ((value_source_application_id = p_der_application_id
450: AND value_source_type_code = p_der_source_type_code

Line 2477: FROM xla_seg_rules_b a

2473:
2474: CURSOR c_seg_rules
2475: IS
2476: SELECT a.application_id, a.amb_context_code, a.segment_rule_type_code, a.segment_rule_code
2477: FROM xla_seg_rules_b a
2478: WHERE exists (SELECT 'x'
2479: FROM xla_seg_rule_details sd
2480: WHERE ((value_source_application_id = p_application_id
2481: AND value_source_type_code = p_source_type_code

Line 3417: FROM xla_seg_rules_b a

3413: --
3414: CURSOR c_seg_rules
3415: IS
3416: SELECT a.application_id, a.amb_context_code, a.segment_rule_type_code, a.segment_rule_code
3417: FROM xla_seg_rules_b a
3418: WHERE exists (SELECT 'x'
3419: FROM xla_seg_rule_details sd
3420: WHERE ((value_source_application_id = p_application_id
3421: AND value_source_type_code = p_source_type_code