APPS.XLA_SEG_RULES_PKG dependencies on XLA_PROD_ACCT_HEADERS

Line 725: ,xla_prod_acct_headers h

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
729: AND h.product_rule_code = a.product_rule_code

Line 852: ,xla_prod_acct_headers xpa

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
856: AND xpa.product_rule_code = xal.product_rule_code

Line 877: ,xla_prod_acct_headers xpa

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
881: AND xpa.event_type_code = xal.event_type_code

Line 984: UPDATE xla_prod_acct_headers xpa

980: AND (compile_status_code <> 'N' OR
981: updated_flag <> 'Y');
982:
983: FORALL i IN 1..l_event_class_codes.LAST
984: UPDATE xla_prod_acct_headers xpa
985: SET validation_status_code = 'N'
986: , last_update_date = sysdate
987: , last_updated_by = xla_environment_pkg.g_usr_id
988: , last_update_login = xla_environment_pkg.g_login_id