DBA Data[Home] [Help]

APPS.PNRX_RENT_INCREASE_SUMMARY dependencies on PN_RENT_INCREASE_SUMMARY_ITF

Line 39: term_rec pn_rent_increase_summary_itf%ROWTYPE;

35: TYPE cur_typ IS REF CURSOR;
36:
37: c_lease_pn cur_typ;
38: -- term_Rec c_lease_pn%ROWTYPE;
39: term_rec pn_rent_increase_summary_itf%ROWTYPE;
40: term_rec_null pn_rent_increase_summary_itf%ROWTYPE;
41: query_str VARCHAR2 (20000);
42: --declare the 'where clauses here........'
43: lease_number_where_clause VARCHAR2 (4000) := NULL;

Line 40: term_rec_null pn_rent_increase_summary_itf%ROWTYPE;

36:
37: c_lease_pn cur_typ;
38: -- term_Rec c_lease_pn%ROWTYPE;
39: term_rec pn_rent_increase_summary_itf%ROWTYPE;
40: term_rec_null pn_rent_increase_summary_itf%ROWTYPE;
41: query_str VARCHAR2 (20000);
42: --declare the 'where clauses here........'
43: lease_number_where_clause VARCHAR2 (4000) := NULL;
44: ri_number_where_clause VARCHAR2 (4000) := NULL;

Line 563: INSERT INTO pn_rent_increase_summary_itf

559: term_rec.old_rent := rec_cur_carry_forward.old_rent;
560: END LOOP;
561:
562:
563: INSERT INTO pn_rent_increase_summary_itf
564: (name,
565: lease_num,
566: payment_term_proration_rule,
567: lease_class_meaning,