APPS.PN_VAR_CHG_CAL_PKG dependencies on PN_VAR_LINES

Line 171: | Create records in the change calendar PN_VAR_LINES_ALL table from

167: | PROCEDURE COPY_PARENT_LINES
168: |
169: |
170: | DESCRIPTION
171: | Create records in the change calendar PN_VAR_LINES_ALL table from
172: | records in the parent variable rent agreement.
173: |
174: | SCOPE - PUBLIC
175: |

Line 222: from pn_var_lines

218: or end_date between p_start and p_end);
219:
220: cursor c_old_lines (p_old_periodId NUMBER) is
221: select *
222: from pn_var_lines
223: where period_id = p_old_periodId
224: ORDER BY sales_type_code, item_category_code;
225:
226: cursor c_old_bkpt_head (p_old_periodId NUMBER) is

Line 257: SELECT pn_var_lines_s.nextval into l_lineitemid from dual;

253: c3_rec.item_category_code = l_last_item_cat_code then
254: NULL;
255: ELSE
256: l_line_num := l_line_num + 1;
257: SELECT pn_var_lines_s.nextval into l_lineitemid from dual;
258:
259: INSERT INTO pn_var_lines_all (
260: line_item_id,
261: line_item_num,

Line 259: INSERT INTO pn_var_lines_all (

255: ELSE
256: l_line_num := l_line_num + 1;
257: SELECT pn_var_lines_s.nextval into l_lineitemid from dual;
258:
259: INSERT INTO pn_var_lines_all (
260: line_item_id,
261: line_item_num,
262: last_update_date,
263: last_updated_by,

Line 556: pn_var_lines_all b,

552: a.group_date,
553: a.invoice_date invoicing_date,
554: a.reptg_due_date reporting_date
555: from pn_var_grp_dates_all a,
556: pn_var_lines_all b,
557: pn_var_periods_all c
558: where a.var_rent_id = l_var_rent_id
559: and a.period_id = b.period_id
560: and b.period_id = c.period_id;

Line 600: pn_var_lines_all b,

596: d.attribute14 attribute14,
597: d.attribute15 attribute15,
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

Line 830: ,pn_var_lines_all b

826: ,a.bkpt_start_date
827: ,b.item_category_code
828: ,b.sales_type_code
829: FROM pn_var_transactions_all a
830: ,pn_var_lines_all b
831: WHERE a.var_rent_id = ip_var_rent_id
832: AND a.line_item_id = NVL(p_line_item_id,b.line_item_id)
833: AND a.line_item_id = b.line_item_id --24SEP03 Chris.T.
834: ORDER BY b.item_category_code ,b.sales_type_code ,a.group_date; -- 11DEC03 Chris.T.

Line 1850: ,pn_var_lines_all pvl

1846: ,per.partial_period
1847: ,per.start_date
1848: ,per.end_date
1849: FROM pn_var_transactions_all pvt
1850: ,pn_var_lines_all pvl
1851: ,pn_var_periods_all per
1852: ,pn_var_rents_all pvr
1853: WHERE pvt.var_rent_id = p_var_rent_id
1854: AND per.period_id = NVL(p_period_id,per.period_id)

Line 1873: ,pn_var_lines_all pvl

1869: ,per.partial_period
1870: ,per.start_date
1871: ,per.end_date
1872: FROM pn_var_transactions_all pvt
1873: ,pn_var_lines_all pvl
1874: ,pn_var_periods_all per
1875: ,pn_var_rents_all pvr
1876: WHERE pvt.var_rent_id = p_var_rent_id
1877: AND per.period_id = NVL(p_period_id,per.period_id)

Line 2495: ,pn_var_lines_all b

2491: p_start_date DATE,
2492: p_end_date DATE) IS
2493: SELECT a.bkpt_rate
2494: FROM pn_var_transactions_all a
2495: ,pn_var_lines_all b
2496: WHERE a.var_rent_id = p_var_rent_id
2497: AND a.period_id = NVL(p_period_id,a.period_id)
2498: AND a.line_item_id = b.line_item_id
2499: AND b.item_category_code = p_item_category_code

Line 2707: ,pn_var_lines_all b

2703: ,max(a.group_date) max_group_date
2704: ,sum(a.prorated_grp_vol_start) sum_grp_vol_start
2705: ,sum(a.prorated_grp_vol_end) sum_grp_vol_end
2706: FROM pn_var_transactions_all a
2707: ,pn_var_lines_all b
2708: WHERE a.var_rent_id = p_var_rent_id
2709: AND a.group_date <= p_end_date -- end date of the complete period
2710: AND a.line_item_id = b.line_item_id
2711: GROUP BY a.proration_reset_group_id,