DBA Data[Home] [Help]

APPS.PN_INDEX_RENT_PERIODS_PKG dependencies on PN_VAR_PERIODS_ALL

Line 2704: FROM pn_var_periods_all

2700: FROM DUAL
2701: where exists (select BKHD_DEFAULT_ID
2702: from pn_var_bkpts_head_all
2703: where period_id IN (select PERIOD_ID
2704: FROM pn_var_periods_all
2705: where VAR_RENT_ID = l_var_rent_id)
2706: AND BKHD_DEFAULT_ID IS NOT NULL);
2707:
2708: l_amt_due_to_term NUMBER :=0;