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_ABATEMENTS_ALL

Line 26: pn_var_abatements_all abt

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
30: AND inv1.period_id = inv2.period_id

Line 50: pn_var_abatements_all abt

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
54: AND inv1.period_id = inv2.period_id

Line 135: pn_var_abatements_all abt

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
139: AND inv1.period_id = inv2.period_id

Line 159: pn_var_abatements_all abt

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
163: AND inv1.period_id = inv2.period_id

Line 436: FROM pn_var_abatements_all

432: CURSOR csr_term_exists IS
433: SELECT 'Y'
434: FROM dual
435: WHERE EXISTS(SELECT null
436: FROM pn_var_abatements_all
437: WHERE payment_term_id = p_payment_term_id
438: AND var_rent_inv_id = p_var_rent_inv_id);
439:
440: l_term_exists VARCHAR2(1) := 'N';