DBA Data[Home] [Help]

APPS.PN_VAR_DEFAULTS_PKG dependencies on PN_VAR_CONSTR_DEFAULTS_ALL

Line 265: select * from pn_var_constr_defaults_all

261: l_new_rentid NUMBER := NULL;
262: l_old_rentid NUMBER := NULL;
263:
264: cursor c_get_consdef is
265: select * from pn_var_constr_defaults_all
266: where var_rent_id = l_old_rentid;
267:
268: BEGIN
269:

Line 364: from pn_var_constr_defaults_all

360: where constr_default_id = p_defid);
361:
362: cursor c2 is
363: select *
364: from pn_var_constr_defaults_all
365: where var_rent_id = l_var_rent_id;
366:
367: cursor c_num (p_periodId NUMBER) is
368: select NVL(max(CONSTRAINT_NUM),0)

Line 1731: FROM pn_var_constr_defaults_all

1727: BEGIN
1728:
1729: SELECT 1
1730: INTO l_constr_found
1731: FROM pn_var_constr_defaults_all
1732: WHERE var_rent_id = p_var_rent_id;
1733:
1734: RETURN l_constr_found;
1735: