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 4641: FROM pn_var_vol_hist_all

4637: SELECT 1 as vol_exists
4638: FROM DUAL
4639: WHERE exists(
4640: SELECT vol_hist_id
4641: FROM pn_var_vol_hist_all
4642: WHERE grp_date_id in(
4643: SELECT grp_date_id
4644: FROM pn_var_grp_dates_all
4645: WHERE var_rent_id = ip_var_rent_id

Line 8790: WHERE EXISTS (SELECT NULL from pn_var_vol_hist_all vol

8786: SELECT distinct gd1.invoice_date,gd1.period_id,decode(temp.inv_dt,NULL,'N','Y')
8787: FROM pn_var_grp_dates_all gd1,
8788: (SELECT gd.invoice_date inv_dt
8789: FROM pn_var_grp_dates_all gd
8790: WHERE EXISTS (SELECT NULL from pn_var_vol_hist_all vol
8791: WHERE vol_hist_status_code = p_status
8792: AND vol.period_id = gd.period_id
8793: AND vol.invoicing_date= gd.invoice_date
8794: )

Line 8839: AND EXISTS (select NULL from pn_var_vol_hist_all vol

8835: (SELECT period_id FROM pn_var_periods_all vp
8836: WHERE period_num=1
8837: AND var_rent_id=p_vrent_id
8838: AND partial_period='Y'
8839: AND EXISTS (select NULL from pn_var_vol_hist_all vol
8840: where vol_hist_status_code = p_status
8841: and vol.period_id = vp.period_id
8842: and var_rent_id=p_vrent_id
8843: )

Line 8858: WHERE EXISTS(select NULL from pn_var_vol_hist_all vol

8854: FROM pn_var_grp_dates_all gd1,
8855: pn_var_periods_all vp,
8856: (SELECT gd.invoice_date inv_dt
8857: FROM pn_var_grp_dates_all gd
8858: WHERE EXISTS(select NULL from pn_var_vol_hist_all vol
8859: where vol_hist_status_code = p_status
8860: and vol.period_id = gd.period_id
8861: and vol.invoicing_date= gd.invoice_date
8862: )