APPS.XLA_LINE_TYPES_PKG dependencies on XLA_PROD_ACCT_HEADERS

Line 765: ,xla_prod_acct_headers h

761: AND accounting_line_type_code = p_accounting_line_type_code
762: AND accounting_line_code = p_accounting_line_code
763: AND exists (SELECT 'x'
764: FROM xla_aad_line_defn_assgns a
765: ,xla_prod_acct_headers h
766: WHERE h.application_id = a.application_id
767: AND h.amb_context_code = a.amb_context_code
768: AND h.product_rule_type_code = a.product_rule_type_code
769: AND h.product_rule_code = a.product_rule_code

Line 1366: ,xla_prod_acct_headers xpa

1362: , xpa.locking_status_flag
1363: , xpa.validation_status_code
1364: FROM xla_line_defn_jlt_assgns xjl
1365: ,xla_aad_line_defn_assgns xal
1366: ,xla_prod_acct_headers xpa
1367: WHERE xpa.application_id = xal.application_id
1368: AND xpa.amb_context_code = xal.amb_context_code
1369: AND xpa.product_rule_type_code = xal.product_rule_type_code
1370: AND xpa.product_rule_code = xal.product_rule_code

Line 1392: ,xla_prod_acct_headers xpa

1388: , xal.product_rule_type_code
1389: , xal.product_rule_code
1390: FROM xla_line_defn_jlt_assgns xjl
1391: ,xla_aad_line_defn_assgns xal
1392: ,xla_prod_acct_headers xpa
1393: ,xla_product_rules_b xpr
1394: WHERE xpr.application_id = xpa.application_id
1395: AND xpr.amb_context_code = xpa.amb_context_code
1396: AND xpr.product_rule_type_code = xpa.product_rule_type_code

Line 1504: UPDATE xla_prod_acct_headers xpa

1500: AND (compile_status_code <> 'N' OR
1501: updated_flag <> 'Y');
1502:
1503: FORALL i IN 1..l_event_class_codes.LAST
1504: UPDATE xla_prod_acct_headers xpa
1505: SET validation_status_code = 'N'
1506: , last_update_date = sysdate
1507: , last_updated_by = xla_environment_pkg.g_usr_id
1508: , last_update_login = xla_environment_pkg.g_login_id