APPS.PN_VAR_TRX_PKG dependencies on PN_VAR_VOL_HIST_ALL

Line 2999: pn_var_vol_hist_all sales

2995: ,p_grp_id IN NUMBER) IS
2996: SELECT
2997: SUM(actual_amount) AS calc_prd_actual_volume
2998: FROM
2999: pn_var_vol_hist_all sales
3000: WHERE
3001: sales.period_id = p_prd_id AND
3002: sales.line_item_id = p_line_id AND
3003: sales.grp_date_id = p_grp_id AND

Line 3017: pn_var_vol_hist_all sales

3013: sales.actual_amount
3014: ,sales.start_date
3015: ,sales.end_date
3016: FROM
3017: pn_var_vol_hist_all sales
3018: WHERE
3019: sales.period_id = p_prd_id AND
3020: sales.line_item_id = p_line_id AND
3021: sales.grp_date_id = p_grp_id AND

Line 3138: pn_var_vol_hist_all sales

3134: ,p_grp_id IN NUMBER) IS
3135: SELECT
3136: SUM(actual_amount) AS calc_prd_actual_volume
3137: FROM
3138: pn_var_vol_hist_all sales
3139: WHERE
3140: sales.period_id = p_prd_id AND
3141: sales.line_item_id = p_line_id AND
3142: sales.grp_date_id = p_grp_id AND

Line 3156: pn_var_vol_hist_all sales

3152: sales.actual_amount
3153: ,sales.start_date
3154: ,sales.end_date
3155: FROM
3156: pn_var_vol_hist_all sales
3157: WHERE
3158: sales.period_id = p_prd_id AND
3159: sales.line_item_id = p_line_id AND
3160: sales.grp_date_id = p_grp_id AND

Line 4011: pn_var_vol_hist_all sales

4007: ,p_grp_id IN NUMBER) IS
4008: SELECT
4009: SUM(forecasted_amount) AS calc_prd_forecasted_volume
4010: FROM
4011: pn_var_vol_hist_all sales
4012: WHERE
4013: sales.period_id = p_prd_id AND
4014: sales.line_item_id = p_line_id AND
4015: sales.grp_date_id = p_grp_id;

Line 4028: pn_var_vol_hist_all sales

4024: sales.forecasted_amount
4025: ,sales.start_date
4026: ,sales.end_date
4027: FROM
4028: pn_var_vol_hist_all sales
4029: WHERE
4030: sales.period_id = p_prd_id AND
4031: sales.line_item_id = p_line_id AND
4032: sales.grp_date_id = p_grp_id AND

Line 4148: pn_var_vol_hist_all sales

4144: ,p_grp_id IN NUMBER) IS
4145: SELECT
4146: SUM(forecasted_amount) AS calc_prd_forecasted_volume
4147: FROM
4148: pn_var_vol_hist_all sales
4149: WHERE
4150: sales.period_id = p_prd_id AND
4151: sales.line_item_id = p_line_id AND
4152: sales.grp_date_id = p_grp_id;

Line 4165: pn_var_vol_hist_all sales

4161: sales.forecasted_amount
4162: ,sales.start_date
4163: ,sales.end_date
4164: FROM
4165: pn_var_vol_hist_all sales
4166: WHERE
4167: sales.period_id = p_prd_id AND
4168: sales.line_item_id = p_line_id AND
4169: sales.grp_date_id = p_grp_id AND