DBA Data[Home] [Help]

APPS.CN_UPGRADE_PE_FORMULA_PKG dependencies on CN_CALC_FORMULAS_ALL

Line 315: FROM cn_calc_formulas_all f,

311:
312: CURSOR l_formula_csr
313: IS
314: SELECT f.calc_formula_id
315: FROM cn_calc_formulas_all f,
316: cn_quotas_all q
317: WHERE f.NAME = l_formula_name
318: AND q.quota_id = p_quota_id
319: AND ((q.org_id = f.org_id) OR (q.org_id IS NULL AND f.org_id IS NULL));

Line 428: FROM cn_calc_formulas_all

424:
425: CURSOR l_discount_option_csr(p_org_id number)
426: IS
427: SELECT calc_formula_id
428: FROM cn_calc_formulas_all
429: WHERE NAME = 'Discount Option Formula'
430: AND org_id = p_org_id;
431: BEGIN
432: OPEN l_quota_csr;