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_ABATEMENT_AMOUNT_PKG dependencies on PN_VAR_RENT_INV_ALL

Line 23: pn_var_rent_inv_all inv, --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/

19: RETURN NUMBER IS
20: CURSOR csr_get_amt IS
21: SELECT NVL(SUM(ppi.actual_amount),0)
22: FROM pn_payment_items_all ppi,
23: pn_var_rent_inv_all inv, --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/
24: pn_var_rents_all var , --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/
25: pn_payment_schedules_all pps,
26: pn_var_abatements_all abt
27: WHERE ppi.payment_term_id = abt.payment_term_id

Line 28: AND abt.var_rent_inv_id = (SELECT inv2.var_rent_inv_id FROM pn_var_rent_inv_all inv1, pn_var_rent_inv_all inv2

24: pn_var_rents_all var , --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/
25: pn_payment_schedules_all pps,
26: pn_var_abatements_all abt
27: WHERE ppi.payment_term_id = abt.payment_term_id
28: AND abt.var_rent_inv_id = (SELECT inv2.var_rent_inv_id FROM pn_var_rent_inv_all inv1, pn_var_rent_inv_all inv2
29: WHERE inv1.var_rent_id = inv2.var_rent_id
30: AND inv1.period_id = inv2.period_id
31: AND inv1.invoice_date = inv2.invoice_date
32: AND inv1.var_rent_inv_id = p_var_rent_inv_id

Line 47: pn_var_rent_inv_all inv, --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/

43:
44: CURSOR csr_get_tu_amt IS
45: SELECT NVL(SUM(ppi.actual_amount),0)
46: FROM pn_payment_items_all ppi,
47: pn_var_rent_inv_all inv, --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/
48: pn_var_rents_all var , --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/
49: pn_payment_schedules_all pps,
50: pn_var_abatements_all abt
51: WHERE ppi.payment_term_id = abt.payment_term_id

Line 52: AND abt.var_rent_inv_id = (SELECT inv2.var_rent_inv_id FROM pn_var_rent_inv_all inv1, pn_var_rent_inv_all inv2

48: pn_var_rents_all var , --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/
49: pn_payment_schedules_all pps,
50: pn_var_abatements_all abt
51: WHERE ppi.payment_term_id = abt.payment_term_id
52: AND abt.var_rent_inv_id = (SELECT inv2.var_rent_inv_id FROM pn_var_rent_inv_all inv1, pn_var_rent_inv_all inv2
53: WHERE inv1.var_rent_id = inv2.var_rent_id
54: AND inv1.period_id = inv2.period_id
55: AND inv1.invoice_date = inv2.invoice_date
56: AND inv1.var_rent_inv_id = p_var_rent_inv_id

Line 72: FROM pn_var_rent_inv_all inv

68: -- Get the details of
69: CURSOR is_inv_tu_c(ip_var_rent_inv_id NUMBER
70: ) IS
71: SELECT true_up_amt
72: FROM pn_var_rent_inv_all inv
73: WHERE inv.var_rent_inv_id = ip_var_rent_inv_id;
74:
75: l_abt_amt NUMBER;
76: l_true_up_amt NUMBER;

Line 132: pn_var_rent_inv_all inv, --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/

128: ip_min_grp_dt DATE,
129: ip_max_grp_dt DATE) IS
130: SELECT NVL(SUM(ppi.actual_amount),0) amount
131: FROM pn_payment_items_all ppi,
132: pn_var_rent_inv_all inv, --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/
133: pn_var_rents_all var , --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/
134: pn_payment_schedules_all pps,
135: pn_var_abatements_all abt
136: WHERE ppi.payment_term_id = abt.payment_term_id

Line 137: AND abt.var_rent_inv_id = (SELECT inv2.var_rent_inv_id FROM pn_var_rent_inv_all inv1, pn_var_rent_inv_all inv2

133: pn_var_rents_all var , --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/
134: pn_payment_schedules_all pps,
135: pn_var_abatements_all abt
136: WHERE ppi.payment_term_id = abt.payment_term_id
137: AND abt.var_rent_inv_id = (SELECT inv2.var_rent_inv_id FROM pn_var_rent_inv_all inv1, pn_var_rent_inv_all inv2
138: WHERE inv1.var_rent_id = inv2.var_rent_id
139: AND inv1.period_id = inv2.period_id
140: AND inv1.invoice_date = inv2.invoice_date
141: AND inv1.var_rent_inv_id = ip_var_rent_inv_id

Line 156: pn_var_rent_inv_all inv, --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/

152:
153: CURSOR csr_get_tu_amt IS
154: SELECT NVL(SUM(ppi.actual_amount),0)
155: FROM pn_payment_items_all ppi,
156: pn_var_rent_inv_all inv, --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/
157: pn_var_rents_all var , --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/
158: pn_payment_schedules_all pps,
159: pn_var_abatements_all abt
160: WHERE ppi.payment_term_id = abt.payment_term_id

Line 161: AND abt.var_rent_inv_id = (SELECT inv2.var_rent_inv_id FROM pn_var_rent_inv_all inv1, pn_var_rent_inv_all inv2

157: pn_var_rents_all var , --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/
158: pn_payment_schedules_all pps,
159: pn_var_abatements_all abt
160: WHERE ppi.payment_term_id = abt.payment_term_id
161: AND abt.var_rent_inv_id = (SELECT inv2.var_rent_inv_id FROM pn_var_rent_inv_all inv1, pn_var_rent_inv_all inv2
162: WHERE inv1.var_rent_id = inv2.var_rent_id
163: AND inv1.period_id = inv2.period_id
164: AND inv1.invoice_date = inv2.invoice_date
165: AND inv1.var_rent_inv_id = p_var_rent_inv_id

Line 181: FROM pn_var_rent_inv_all inv

177: -- Get the details of
178: CURSOR is_inv_tu_c(ip_var_rent_inv_id NUMBER
179: ) IS
180: SELECT true_up_amt
181: FROM pn_var_rent_inv_all inv
182: WHERE inv.var_rent_inv_id = ip_var_rent_inv_id;
183:
184: -- Get the details of invoices in a specific period
185: CURSOR get_inv_in_prd(ip_period_id NUMBER

Line 188: FROM pn_var_rent_inv_all

184: -- Get the details of invoices in a specific period
185: CURSOR get_inv_in_prd(ip_period_id NUMBER
186: ) IS
187: SELECT var_rent_inv_id
188: FROM pn_var_rent_inv_all
189: WHERE period_id = ip_period_id;
190:
191: -- Get the details of invoice date
192: CURSOR get_inv_date(ip_inv_id NUMBER

Line 195: FROM pn_var_rent_inv_all

191: -- Get the details of invoice date
192: CURSOR get_inv_date(ip_inv_id NUMBER
193: ) IS
194: SELECT invoice_date
195: FROM pn_var_rent_inv_all
196: WHERE var_rent_inv_id = ip_inv_id
197: AND true_up_amt IS NULL
198: AND adjust_num = 0;
199: -- Get the proration type

Line 348: UPDATE pn_var_rent_inv_all

344:
345: /* Update pn_var_rent_inv with the recurring abatement amount and also
346: UPDATE the actual invoiced amount */
347:
348: UPDATE pn_var_rent_inv_all
349: SET rec_abatement = l_abt_amt,
350: actual_term_status = DECODE(p_var_rent_type,'ACTUAL','N',actual_term_status),
351: variance_term_status = DECODE(p_var_rent_type,'VARIANCE','N',variance_term_status),
352: actual_invoiced_amount = pn_variable_amount_pkg.derive_actual_invoiced_amt(