APPS.XLA_PRODUCT_RULES_PKG dependencies on XLA_CONDITIONS

Line 324: FROM xla_conditions c, xla_desc_priorities d

320:
321: CURSOR c_desc_condition_sources
322: IS
323: SELECT c.source_type_code source_type_code, c.source_code source_code
324: FROM xla_conditions c, xla_desc_priorities d
325: WHERE c.description_prio_id = d.description_prio_id
326: AND d.application_id = p_application_id
327: AND d.amb_context_code = p_amb_context_code
328: AND d.description_type_code = p_description_type_code

Line 344: FROM xla_conditions c, xla_desc_priorities d

340: AND s.active_flag = 'Y'
341: AND s.level_code = 'H')
342: UNION
343: SELECT c.value_source_type_code source_type_code, c.value_source_code source_code
344: FROM xla_conditions c, xla_desc_priorities d
345: WHERE c.description_prio_id = d.description_prio_id
346: AND d.application_id = p_application_id
347: AND d.amb_context_code = p_amb_context_code
348: AND d.description_type_code = p_description_type_code

Line 382: FROM xla_conditions c, xla_desc_priorities d

378:
379: CURSOR c_desc_condition_der_sources
380: IS
381: SELECT c.source_type_code source_type_code, c.source_code source_code
382: FROM xla_conditions c, xla_desc_priorities d
383: WHERE c.description_prio_id = d.description_prio_id
384: AND d.application_id = p_application_id
385: AND d.amb_context_code = p_amb_context_code
386: AND d.description_type_code = p_description_type_code

Line 392: FROM xla_conditions c, xla_desc_priorities d

388: AND c.source_code is not null
389: AND c.source_type_code = 'D'
390: UNION
391: SELECT c.value_source_type_code source_type_code, c.value_source_code source_code
392: FROM xla_conditions c, xla_desc_priorities d
393: WHERE c.description_prio_id = d.description_prio_id
394: AND d.application_id = p_application_id
395: AND d.amb_context_code = p_amb_context_code
396: AND d.description_type_code = p_description_type_code