502: | PROCEDURE COPY_PARENT_VOLHIST
503: |
504: |
505: | DESCRIPTION
506: | Create records in the change calendar PN_VAR_VOL_HIST_ALL table from
507: | records in the parent variable rent agreement VOL HIST TABLE when group dates
508: | are the same for both the parent and the change calendar periods.
509: |
510: | SCOPE - PUBLIC
598: d.org_id org_id
599: from pn_var_grp_dates_all a,
600: pn_var_lines_all b,
601: pn_var_periods_all c,
602: pn_var_vol_hist_all d
603: where a.var_rent_id = l_chg_var_rent_id
604: and a.period_id = b.period_id
605: and b.period_id = c.period_id
606: and d.period_id = c.period_id
640: to_number(to_char(l_end_date,'YYMMDD'))-
641: to_number(to_char(l_start_date,'YYMMDD')),2);
642: **/
643:
644: INSERT into pn_var_vol_hist_all (
645: vol_hist_id,
646: vol_hist_num,
647: last_update_date,
648: last_updated_by,