APPS.PN_VAR_CHG_CAL_PKG dependencies on PN_VAR_BKPTS_DET

Line 233: from pn_var_bkpts_det

229: where period_id = p_old_periodId;
230:
231: cursor c_old_bkpt_det (p_bkptheadid NUMBER) IS
232: select *
233: from pn_var_bkpts_det
234: where bkpt_header_id = p_bkptheadid;
235:
236: BEGIN
237:

Line 416: INSERT INTO pn_var_bkpts_det_all (

412:
413: -- need to build routine to calculate volumes based on period and group proration.
414: -- use period volumes as control amounts for calculations.
415:
416: INSERT INTO pn_var_bkpts_det_all (
417: bkpt_detail_id,
418: bkpt_detail_num,
419: last_update_date,
420: last_updated_by,

Line 451: pn_var_bkpts_det_s.nextval,

447: attribute14,
448: attribute15,
449: org_id
450: ) values (
451: pn_var_bkpts_det_s.nextval,
452: l_bkdt_num,
453: sysdate,
454: NVL(fnd_profile.value('USER_ID'),0),
455: sysdate,

Line 809: pn_var_bkpts_det_all bkpt

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)
813: ORDER by head.line_item_id,bkpt.bkpt_start_date, bkpt.bkpt_rate, bkpt.group_bkpt_vol_start;