DBA Data[Home] [Help]

APPS.PN_INDEX_RENT_PERIODS_PKG dependencies on PN_VAR_PERIODS_ALL

Line 2560: FROM pn_var_periods_all

2556: FROM DUAL
2557: where exists (select BKHD_DEFAULT_ID
2558: from pn_var_bkpts_head_all
2559: where period_id IN (select PERIOD_ID
2560: FROM pn_var_periods_all
2561: where VAR_RENT_ID = l_var_rent_id)
2562: AND BKHD_DEFAULT_ID IS NOT NULL);
2563:
2564: l_amt_due_to_term NUMBER :=0;