DBA Data[Home] [Help]

APPS.CN_COMMISSION_CALC_PVT dependencies on USER_OBJECTS

Line 39: FROM user_objects

35: AND ccf.calc_formula_id = cq.calc_formula_id;
36:
37: CURSOR formula_valid_cr(p_formula_id NUMBER, p_org_id NUMBER) IS
38: SELECT count(*)
39: FROM user_objects
40: WHERE object_name = 'CN_FORMULA_'||abs(p_formula_id)||'_'||abs(p_org_id)||'_PKG'
41: AND (object_type = 'PACKAGE' OR object_type = 'PACKAGE BODY');
42:
43: l_pe_formula pe_formula_cr%ROWTYPE;