APPS.PN_VAR_CHG_CAL_PKG dependencies on PN_VAR_BKPTS_HEAD_ALL

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)