eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_VAR_CHG_CAL_PKG dependencies on PN_VAR_BKPTS_DET_ALL

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 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;