APPS.XLA_EVENT_CLASSES_PKG dependencies on XLA_PROD_ACCT_HEADERS

Line 92: FROM xla_prod_acct_headers

88:
89: CURSOR check_prod_rules
90: IS
91: SELECT 'x'
92: FROM xla_prod_acct_headers
93: WHERE application_id = p_application_id
94: AND entity_code = p_entity_code
95: AND event_class_code = p_event_class_code;
96:

Line 381: FROM xla_prod_acct_headers xpa

377: CURSOR c_locked_aads IS
378: SELECT xpa.entity_code, xpa.event_class_code, xpa.event_type_code,
379: xpa.product_rule_type_code, xpa.product_rule_code,
380: xpa.amb_context_code, xpa.locking_status_flag
381: FROM xla_prod_acct_headers xpa
382: WHERE xpa.application_id = p_application_id
383: AND xpa.event_class_code = p_event_class_code
384: AND (xpa.validation_status_code NOT IN ('E', 'Y', 'N') OR
385: xpa.locking_status_flag = 'Y');

Line 433: UPDATE xla_prod_acct_headers xpa

429: WHERE xld.application_id = p_application_id
430: AND xld.event_class_code = p_event_class_code
431: AND xld.validation_status_code <> 'N';
432:
433: UPDATE xla_prod_acct_headers xpa
434: SET validation_status_code = 'N'
435: WHERE xpa.application_id = p_application_id
436: AND xpa.event_class_code = p_event_class_code
437: AND xpa.validation_status_code <> 'N';

Line 449: FROM xla_prod_acct_headers xpa

445: ,xpr.product_rule_code) IN
446: (SELECT xpa.amb_context_code
447: ,xpa.product_rule_type_code
448: ,xpa.product_rule_code
449: FROM xla_prod_acct_headers xpa
450: WHERE xpa.application_id = p_application_id
451: AND xpa.event_class_code = p_event_class_code);
452:
453: l_return := TRUE;

Line 506: FROM xla_prod_acct_headers s

502:
503: CURSOR c_frozen_assignment_exist
504: IS
505: SELECT 'x'
506: FROM xla_prod_acct_headers s
507: WHERE application_id = p_application_id
508: AND event_class_code = p_event_class_code
509: AND locking_status_flag = 'Y';
510: BEGIN