DBA Data[Home] [Help]

APPS.XLA_ANALYTICAL_HDRS_PKG dependencies on XLA_LINE_DEFN_AC_ASSGNS

Line 106: FROM xla_line_defn_ac_assgns xld

102: , xpa.product_rule_type_code
103: , xpa.product_rule_code
104: , xpa.locking_status_flag
105: , xpa.validation_status_code
106: FROM xla_line_defn_ac_assgns xld
107: ,xla_aad_line_defn_assgns xal
108: ,xla_prod_acct_headers xpa
109: WHERE xpa.application_id = xal.application_id
110: AND xpa.amb_context_code = xal.amb_context_code

Line 167: ,xla_line_defn_ac_assgns xac

163: SELECT xpa.application_id, xpa.event_class_code,
164: xpa.product_rule_type_code, xpa.product_rule_code
165: FROM xla_prod_acct_headers xpa
166: ,xla_aad_line_defn_assgns xal
167: ,xla_line_defn_ac_assgns xac
168: WHERE xpa.application_id = xal.application_id
169: AND xpa.amb_context_code = xal.amb_context_code
170: AND xpa.product_rule_type_code = xal.product_rule_type_code
171: AND xpa.product_rule_code = xal.product_rule_code

Line 289: FROM xla_line_defn_ac_assgns xac

285: WHERE xld.amb_context_code = p_amb_context_code
286: AND xld.validation_status_code <> 'N'
287: AND EXISTS
288: (SELECT 'X'
289: FROM xla_line_defn_ac_assgns xac
290: WHERE xac.amb_context_code = p_amb_context_code
291: AND xac.analytical_criterion_type_code = p_anal_criterion_type_code
292: AND xac.analytical_criterion_code = p_analytical_criterion_code
293: AND xac.application_id = xld.application_id