APPS.PN_VAR_RENT_CALC_PKG dependencies on PN_VAR_VOL_HIST_ALL

Line 217: pn_var_vol_hist_all

213: EXISTS
214: (SELECT
215: vol_hist_id
216: FROM
217: pn_var_vol_hist_all
218: WHERE
219: line_item_id = p_line_id AND
220: grp_date_id = p_grp_id AND
221: vol_hist_status_code = pn_var_rent_calc_pkg.G_SALESVOL_STATUS_APPROVED);

Line 2184: FROM pn_var_vol_hist_all

2180: SELECT 1 as vol_exists
2181: FROM DUAL
2182: WHERE exists(
2183: SELECT vol_hist_id
2184: FROM pn_var_vol_hist_all
2185: WHERE grp_date_id in(
2186: SELECT grp_date_id
2187: FROM pn_var_grp_dates_all
2188: WHERE var_rent_id = ip_var_rent_id

Line 4729: FROM pn_var_vol_hist_all

4725: SELECT 1 as vol_exists
4726: FROM DUAL
4727: WHERE exists(
4728: SELECT vol_hist_id
4729: FROM pn_var_vol_hist_all
4730: WHERE grp_date_id in(
4731: SELECT grp_date_id
4732: FROM pn_var_grp_dates_all
4733: WHERE var_rent_id = ip_var_rent_id

Line 8845: WHERE EXISTS (SELECT NULL from pn_var_vol_hist_all vol

8841: SELECT distinct gd1.invoice_date,gd1.period_id,decode(temp.inv_dt,NULL,'N','Y')
8842: FROM pn_var_grp_dates_all gd1,
8843: (SELECT gd.invoice_date inv_dt
8844: FROM pn_var_grp_dates_all gd
8845: WHERE EXISTS (SELECT NULL from pn_var_vol_hist_all vol
8846: WHERE vol_hist_status_code = p_status
8847: AND vol.period_id = gd.period_id
8848: AND vol.invoicing_date= gd.invoice_date
8849: )

Line 8894: AND EXISTS (select NULL from pn_var_vol_hist_all vol

8890: (SELECT period_id FROM pn_var_periods_all vp
8891: WHERE period_num=1
8892: AND var_rent_id=p_vrent_id
8893: AND partial_period='Y'
8894: AND EXISTS (select NULL from pn_var_vol_hist_all vol
8895: where vol_hist_status_code = p_status
8896: and vol.period_id = vp.period_id
8897: and var_rent_id=p_vrent_id
8898: )

Line 8913: WHERE EXISTS(select NULL from pn_var_vol_hist_all vol

8909: FROM pn_var_grp_dates_all gd1,
8910: pn_var_periods_all vp,
8911: (SELECT gd.invoice_date inv_dt
8912: FROM pn_var_grp_dates_all gd
8913: WHERE EXISTS(select NULL from pn_var_vol_hist_all vol
8914: where vol_hist_status_code = p_status
8915: and vol.period_id = gd.period_id
8916: and vol.invoicing_date= gd.invoice_date
8917: )