APPS.XLA_PRODUCT_RULES_F_PKG dependencies on XLA_PRODUCT_RULES_B

Line 89: FROM xla_product_rules_b

85: IS
86:
87: CURSOR c IS
88: SELECT rowid
89: FROM xla_product_rules_b
90: WHERE application_id = x_application_id
91: AND amb_context_code = x_amb_context_code
92: AND product_rule_type_code = x_product_rule_type_code
93: AND product_rule_code = x_product_rule_code

Line 108: INSERT INTO xla_product_rules_b

104: p_module => l_log_module,
105: p_level => C_LEVEL_PROCEDURE);
106: END IF;
107:
108: INSERT INTO xla_product_rules_b
109: (creation_date
110: ,created_by
111: ,enabled_flag
112: ,request_id

Line 234: FROM xla_product_rules_b

230: ,transaction_coa_id
231: ,accounting_coa_id
232: ,product_rule_hash_id
233: ,compile_status_code
234: FROM xla_product_rules_b
235: WHERE application_id = x_application_id
236: AND amb_context_code = x_amb_context_code
237: AND product_rule_type_code = x_product_rule_type_code
238: AND product_rule_code = x_product_rule_code

Line 367: UPDATE xla_product_rules_b

363: p_module => l_log_module,
364: p_level => C_LEVEL_PROCEDURE);
365: END IF;
366:
367: UPDATE xla_product_rules_b
368: SET
369: last_update_date = x_last_update_date
370: ,enabled_flag = x_enabled_flag
371: ,request_id = x_request_id

Line 451: DELETE FROM xla_product_rules_b

447: IF (SQL%NOTFOUND) THEN
448: RAISE NO_DATA_FOUND;
449: END IF;
450:
451: DELETE FROM xla_product_rules_b
452: WHERE application_id = x_application_id
453: AND amb_context_code = x_amb_context_code
454: AND product_rule_type_code = x_product_rule_type_code
455: AND product_rule_code = x_product_rule_code;

Line 496: FROM xla_product_rules_b b

492:
493: DELETE FROM xla_product_rules_tl T
494: WHERE NOT EXISTS
495: (SELECT NULL
496: FROM xla_product_rules_b b
497: WHERE b.application_id = t.application_id
498: AND b.amb_context_code = t.amb_context_code
499: AND b.product_rule_type_code = t.product_rule_type_code
500: AND b.product_rule_code = t.product_rule_code);