APPS.XLA_CMP_ADR_PKG dependencies on XLA_SEG_RULES_TL

Line 1392: FROM xla_seg_rules_tl

1388: -- Retrieve ADR Name
1389: --
1390: SELECT NAME
1391: INTO l_adr_name
1392: FROM xla_seg_rules_tl
1393: WHERE application_id = p_value_segment_rule_appl_id
1394: AND amb_context_code = p_amb_context_code
1395: AND segment_rule_type_code = p_value_segment_rule_type_code
1396: AND segment_rule_code = p_value_segment_rule_code

Line 2169: , xla_seg_rules_tl xsrt

2165: , REPLACE(xsrt.name , '''','''''')
2166: FROM xla_aad_line_defn_assgns xald
2167: , xla_line_defn_adr_assgns xlda
2168: , xla_seg_rules_b xsrb
2169: , xla_seg_rules_tl xsrt
2170: , xla_prod_acct_headers xpah
2171: , xla_line_definitions_b xld
2172: WHERE xpah.application_id = p_application_id
2173: AND xpah.amb_context_code = p_amb_context_code

Line 2231: , xla_seg_rules_tl xsrt

2227: FROM xla_prod_acct_headers xpah
2228: , xla_aad_line_defn_assgns xald
2229: , xla_mpa_jlt_adr_assgns xmja
2230: , xla_seg_rules_b xsrb
2231: , xla_seg_rules_tl xsrt
2232: , xla_line_definitions_b xld
2233: WHERE xpah.application_id = p_application_id
2234: AND xpah.amb_context_code = p_amb_context_code
2235: AND xpah.product_rule_type_code = p_product_rule_type_code

Line 2926: , xla_seg_rules_tl xsrt

2922: ,xsrb.transaction_coa_id
2923: ,xsrb.accounting_coa_id
2924: ,REPLACE(xsrt.name , '''','''''')
2925: FROM xla_seg_rules_b xsrb
2926: , xla_seg_rules_tl xsrt
2927: WHERE xsrb.application_id = cp_application_id
2928: AND xsrb.segment_rule_code = cp_segment_rule_code
2929: AND xsrb.segment_rule_type_code = cp_segment_rule_type_code
2930: AND xsrb.amb_context_code = cp_amb_context_code