APPS.PN_VARIABLE_AMOUNT_PKG dependencies on PN_VAR_VOL_HIST_ALL

Line 15: FROM pn_var_vol_hist_all vh,

11: p_period_id number,
12: p_period_date DATE) IS
13: SELECT SUM(vh.actual_amount) actual_amt,
14: vh.grp_date_id
15: FROM pn_var_vol_hist_all vh,
16: pn_var_grp_dates_all gd
17: WHERE vh.line_item_id = p_line_item_id
18: AND vh.grp_date_id = gd.grp_date_id
19: AND vh.period_id = gd.period_id

Line 35: FROM pn_var_vol_hist_all vh,

31: p_period_id number,
32: p_period_date DATE) IS
33: SELECT SUM(vh.forecasted_amount) forecasted_amt,
34: vh.grp_date_id
35: FROM pn_var_vol_hist_all vh,
36: pn_var_grp_dates_all gd
37: WHERE vh.line_item_id = p_line_item_id
38: AND vh.grp_date_id = gd.grp_date_id
39: AND vh.period_id = gd.period_id

Line 61: FROM pn_var_vol_hist_all vh,

57: p_period_date DATE) IS
58: SELECT SUM(vh.actual_amount) actual_amt,
59: vh.grp_date_id,
60: vh.line_item_id
61: FROM pn_var_vol_hist_all vh,
62: pn_var_grp_dates_all gd
63: WHERE vh.grp_date_id = gd.grp_date_id
64: AND vh.period_id = gd.period_id
65: AND gd.period_id = p_period_id

Line 84: FROM pn_var_vol_hist_all vh,

80: p_min_group_date date) IS
81: SELECT SUM(vh.actual_amount) actual_amt,
82: vh.grp_date_id,
83: vh.line_item_id
84: FROM pn_var_vol_hist_all vh,
85: pn_var_grp_dates_all gd
86: WHERE vh.grp_date_id = gd.grp_date_id
87: AND vh.period_id = gd.period_id
88: AND DECODE(p_invoice_on,'ACTUAL',NVL(gd.actual_exp_code,'N'),

Line 123: FROM pn_var_vol_hist_all

119: SUM(forecasted_amount) cum_for_vol,
120: line_item_id,
121: grp_date_id,
122: group_date
123: FROM pn_var_vol_hist_all
124: WHERE line_item_id = p_line_item_id
125: GROUP BY line_item_id,grp_date_id,group_date
126: ORDER BY line_item_id,group_date;
127:

Line 333: FROM pn_var_vol_hist_all vh,

329: CURSOR csr_min_group_date_adj (p_period_id number,
330: p_line_item_id number,
331: p_invoice_on varchar2) IS
332: SELECT MIN(gd.group_date) min_group_date
333: FROM pn_var_vol_hist_all vh,
334: pn_var_grp_dates_all gd
335: WHERE vh.grp_date_id = gd.grp_date_id
336: AND vh.period_id = gd.period_id
337: AND DECODE(p_invoice_on,'ACTUAL',NVL(gd.actual_exp_code,'N'),

Line 342: FROM pn_var_vol_hist_all vh1

338: 'FORECASTED',NVL(gd.variance_exp_code,'N')) = 'Y'
339: AND gd.period_id = p_period_id
340: AND vh.line_item_id = p_line_item_id
341: AND exists (SELECT null
342: FROM pn_var_vol_hist_all vh1
343: WHERE vh1.period_id = gd.period_id
344: AND vh1.grp_date_id = gd.grp_date_id
345: AND DECODE(p_invoice_on,'ACTUAL' ,NVL( vh1.actual_exp_code,'N'),
346: 'FORECASTED',NVL( vh1.variance_exp_code,'N')

Line 2586: FROM pn_var_vol_hist_all

2582: ip_grp_date_id NUMBER) IS
2583: SELECT 'Y'
2584: FROM dual
2585: WHERE exists (SELECT null
2586: FROM pn_var_vol_hist_all
2587: WHERE line_item_id = ip_line_item_id
2588: AND grp_date_id = ip_grp_date_id);
2589:
2590: /* Cursor to chk if volume history exists for a period AND invoice date */

Line 2597: FROM pn_var_vol_hist_all vh,

2593: ip_rent_TYPE VARCHAR2) IS
2594: SELECT 'Y'
2595: FROM dual
2596: WHERE exists (SELECT null
2597: FROM pn_var_vol_hist_all vh,
2598: pn_var_grp_dates_all gd
2599: WHERE vh.period_id = gd.period_id
2600: AND vh.grp_date_id = gd.grp_date_id
2601: AND gd.period_id = ip_period_id