APPS.PN_VARIABLE_AMOUNT_PKG dependencies on PN_VAR_DEDUCTIONS

Line 147: FROM pn_var_deductions_all

143: Cursor csr_get_ded (p_line_item_id NUMBER) is
144: SELECT line_item_id,
145: grp_date_id,
146: SUM(deduction_amount) deduction_amt
147: FROM pn_var_deductions_all
148: WHERE line_item_id = p_line_item_id
149: GROUP BY line_item_id,grp_date_id;
150:
151:

Line 161: cum_ded pn_var_deductions.deduction_amount%TYPE);

157: RECORD (cum_actual_vol pn_var_vol_hist.actual_amount%TYPE,
158: cum_for_vol pn_var_vol_hist.forecasted_amount%TYPE,
159: line_item_id pn_var_vol_hist.line_item_id%TYPE,
160: grp_date_id pn_var_vol_hist.grp_date_id%TYPE,
161: cum_ded pn_var_deductions.deduction_amount%TYPE);
162:
163: TYPE cumulative_vol_TYPE IS
164: TABLE OF cumulative_vol_rec
165: INDEX BY BINARY_INTEGER;