APPS.PN_VAR_DEFAULTS_PKG dependencies on PN_VAR_CONSTRAINTS_ALL

Line 315: | Create records in the PN_VAR_CONSTRAINTS_ALL table from date range constraints

311: | PROCEDURE CREATE_DEFAULT_CONSTRAINTS
312: |
313: |
314: | DESCRIPTION
315: | Create records in the PN_VAR_CONSTRAINTS_ALL table from date range constraints
316: |
317: | SCOPE - PUBLIC
318: |
319: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 359: from pn_var_constraints_all

355: where var_rent_id = l_var_rent_id
356: and start_date <= p_end
357: and end_date >= p_start
358: and period_id not in (select period_id
359: from pn_var_constraints_all
360: where constr_default_id = p_defid);
361:
362: cursor c2 is
363: select *

Line 369: from pn_var_constraints_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)
369: from pn_var_constraints_all
370: where period_id = p_periodId;
371:
372: BEGIN
373: