APPS.PN_VARIABLE_AMOUNT_PKG dependencies on PN_VAR_BKPTS_HEAD

Line 106: FROM pn_var_bkpts_head_all head,

102: det.group_bkpt_vol_end,
103: det.bkpt_rate,
104: head.breakpoint_TYPE,
105: head.line_item_id
106: FROM pn_var_bkpts_head_all head,
107: pn_var_bkpts_det_all det
108: WHERE det.bkpt_header_id = head.bkpt_header_id
109: AND head.line_item_id = p_line_item_id
110: ORDER BY det.period_bkpt_vol_start;

Line 196: g_breakpoint_TYPE pn_var_bkpts_head.breakpoint_TYPE%TYPE;

192: invoice_tbl invoice_TYPE;
193:
194:
195: /* global variables */
196: g_breakpoint_TYPE pn_var_bkpts_head.breakpoint_TYPE%TYPE;
197: g_var_rent_id pn_var_rents.var_rent_id%TYPE;
198: g_period_id pn_var_periods.period_id%TYPE;
199: g_invoice_date pn_var_grp_dates.invoice_date%TYPE;
200: g_group_date pn_var_grp_dates.group_date%TYPE;