DBA Data[Home] [Help]

APPS.XLA_SEG_RULES_PKG dependencies on XLA_AAD_LINE_DEFN_ASSGNS

Line 724: FROM xla_aad_line_defn_assgns a

720: AND amb_context_code = p_amb_context_code
721: AND segment_rule_type_code = p_segment_rule_type_code
722: AND segment_rule_code = p_segment_rule_code
723: AND exists (SELECT 'x'
724: FROM xla_aad_line_defn_assgns a
725: ,xla_prod_acct_headers h
726: WHERE h.application_id = a.application_id
727: AND h.amb_context_code = a.amb_context_code
728: AND h.product_rule_type_code = a.product_rule_type_code

Line 851: ,xla_aad_line_defn_assgns xal

847: , xpa.product_rule_code
848: , xpa.locking_status_flag
849: , xpa.validation_status_code
850: FROM xla_line_defn_adr_assgns xld
851: ,xla_aad_line_defn_assgns xal
852: ,xla_prod_acct_headers xpa
853: WHERE xpa.application_id = xal.application_id
854: AND xpa.amb_context_code = xal.amb_context_code
855: AND xpa.product_rule_type_code = xal.product_rule_type_code

Line 876: ,xla_aad_line_defn_assgns xal

872: SELECT distinct xal.event_class_code
873: , xal.product_rule_type_code
874: , xal.product_rule_code
875: FROM xla_line_defn_adr_assgns xad
876: ,xla_aad_line_defn_assgns xal
877: ,xla_prod_acct_headers xpa
878: WHERE xpa.application_id = xal.application_id
879: AND xpa.amb_context_code = xal.amb_context_code
880: AND xpa.event_class_code = xal.event_class_code