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_PAYMENT_SCHEDULES_ALL

Line 25: pn_payment_schedules_all pps,

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
29: WHERE inv1.var_rent_id = inv2.var_rent_id

Line 49: pn_payment_schedules_all pps,

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
53: WHERE inv1.var_rent_id = inv2.var_rent_id

Line 134: pn_payment_schedules_all pps,

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
138: WHERE inv1.var_rent_id = inv2.var_rent_id

Line 158: pn_payment_schedules_all pps,

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
162: WHERE inv1.var_rent_id = inv2.var_rent_id