APPS.PN_VAR_ABATEMENT_AMOUNT_PKG dependencies on PN_PAYMENT_ITEMS_ALL

Line 22: FROM pn_payment_items_all ppi,

18: p_max_grp_dt IN DATE)
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

Line 46: FROM pn_payment_items_all ppi,

42: TRUNC(p_min_grp_dt,'MM') AND TRUNC(p_max_grp_dt,'MM');
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

Line 131: FROM pn_payment_items_all ppi,

127: CURSOR csr_get_amt(ip_var_rent_inv_id NUMBER,
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

Line 155: FROM pn_payment_items_all ppi,

151: TRUNC(ip_min_grp_dt,'MM') AND TRUNC(ip_max_grp_dt,'MM');
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