APPS.XLA_ENTITY_TYPES_PKG dependencies on XLA_PROD_ACCT_HEADERS

Line 177: FROM xla_prod_acct_headers xpa

173: CURSOR c_locked_aads IS
174: SELECT xpa.entity_code, xpa.event_class_code, xpa.event_type_code,
175: xpa.product_rule_type_code, xpa.product_rule_code,
176: xpa.amb_context_code, xpa.locking_status_flag
177: FROM xla_prod_acct_headers xpa
178: WHERE xpa.application_id = p_application_id
179: AND xpa.entity_code = p_entity_code
180: AND (xpa.validation_status_code NOT IN ('E', 'Y', 'N') OR
181: xpa.locking_status_flag = 'Y');

Line 231: UPDATE xla_prod_acct_headers xpa

227: FROM xla_event_classes_b
228: WHERE entity_code = p_entity_code)
229: AND xld.validation_status_code <> 'N';
230:
231: UPDATE xla_prod_acct_headers xpa
232: SET validation_status_code = 'N'
233: WHERE xpa.application_id = p_application_id
234: AND xpa.entity_code = p_entity_code
235: AND xpa.validation_status_code <> 'N';

Line 247: FROM xla_prod_acct_headers xpa

243: ,xpr.product_rule_code) IN
244: (SELECT xpa.amb_context_code
245: ,xpa.product_rule_type_code
246: ,xpa.product_rule_code
247: FROM xla_prod_acct_headers xpa
248: WHERE xpa.application_id = p_application_id
249: AND xpa.entity_code = p_entity_code);
250:
251: l_return := TRUE;