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_RENTS_ALL

Line 24: pn_var_rents_all var , --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/

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

Line 48: pn_var_rents_all var , --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/

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

Line 133: pn_var_rents_all var , --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/

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

Line 157: pn_var_rents_all var , --BUG#2452909 /* hrodda_MOAC -changed to tablename_all*/

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

Line 203: FROM pn_var_rents_all

199: -- Get the proration type
200: CURSOR proration_type_c(ip_var_rent_id NUMBER
201: ) IS
202: SELECT proration_rule
203: FROM pn_var_rents_all
204: WHERE var_rent_id = ip_var_rent_id;
205: -- Get the first period
206: CURSOR get_fy_prd_c(ip_var_rent_id NUMBER
207: ) IS