APPS.PN_VAR_CHG_CAL_PKG dependencies on PN_VAR_BKPTS_HEAD

Line 228: from pn_var_bkpts_head

224: ORDER BY sales_type_code, item_category_code;
225:
226: cursor c_old_bkpt_head (p_old_periodId NUMBER) is
227: select *
228: from pn_var_bkpts_head
229: where period_id = p_old_periodId;
230:
231: cursor c_old_bkpt_det (p_bkptheadid NUMBER) IS
232: select *

Line 330: SELECT pn_var_bkpts_head_s.nextval into l_bkptheadid from dual;

326: l_last_item_cat_code := c3_rec.item_category_code;
327:
328:
329: FOR c4_rec IN c_old_bkpt_head(c2_rec.period_id) LOOP
330: SELECT pn_var_bkpts_head_s.nextval into l_bkptheadid from dual;
331:
332: INSERT INTO pn_var_bkpts_head_all (
333: bkpt_header_id,
334: last_update_date,

Line 332: INSERT INTO pn_var_bkpts_head_all (

328:
329: FOR c4_rec IN c_old_bkpt_head(c2_rec.period_id) LOOP
330: SELECT pn_var_bkpts_head_s.nextval into l_bkptheadid from dual;
331:
332: INSERT INTO pn_var_bkpts_head_all (
333: bkpt_header_id,
334: last_update_date,
335: last_updated_by,
336: creation_date,

Line 808: FROM pn_var_bkpts_head_all head,

804: bkpt.period_bkpt_vol_end period_bkpt_vol_end, --Chris.T. 10FEB2004
805: bkpt.bkpt_rate bkpt_rate,
806: bkpt.bkpt_header_id bkpt_header_id,
807: head.line_item_id line_item_id
808: FROM pn_var_bkpts_head_all head,
809: pn_var_bkpts_det_all bkpt
810: WHERE head.bkpt_header_id = bkpt.bkpt_header_id
811: AND head.period_id = ip_period_id
812: AND head.line_item_id = NVL(p_line_item_id,line_item_id)