APPS.PN_VARIABLE_AMOUNT_PKG dependencies on PN_VAR_RENTS_ALL

Line 1279: FROM pn_var_rents_all

1275: CURSOR csr_get_abt(ip_var_rent_id NUMBER)
1276: IS
1277: SELECT NVL(abatement_amount,0),
1278: negative_rent
1279: FROM pn_var_rents_all
1280: WHERE var_rent_id = ip_var_rent_id;
1281:
1282: /* Get the abatement amount that has been applied to transferred invoices.
1283: Here we only consider those invoices where the adjust num is the MAXimum

Line 1918: FROM pn_var_rents_all

1914: negative_rent
1915: INTO p_cumulative,
1916: p_invoice_on,
1917: p_negative_rent
1918: FROM pn_var_rents_all
1919: WHERE var_rent_id = p_var_rent_id;
1920:
1921: pnp_debug_pkg.log( 'pn_variable_amount_pkg.get_varrent_details : (-) ');
1922:

Line 2074: FROM pn_var_rents_all pvr , pn_var_periods_all pvp

2070:
2071:
2072: CURSOR first_period_cur IS
2073: SELECT pvp.period_id
2074: FROM pn_var_rents_all pvr , pn_var_periods_all pvp
2075: WHERE pvr.var_rent_id = p_var_rent_id
2076: AND pvr.var_rent_id = pvp.var_rent_id
2077: AND proration_rule IN ('FY', 'FLY')
2078: AND pvp.start_date = pvr.commencement_date;

Line 2176: pn_var_rents_all vrent

2172: summ.tot_for_vol,
2173: summ.tot_ded,
2174: decode(vrent.cumulative_vol ,'N','N','T','N','Y')
2175: FROM pn_var_rent_summ_all summ,
2176: pn_var_rents_all vrent
2177: WHERE summ.line_item_id = p_line_item_id
2178: AND summ.group_date = p_group_date
2179: AND summ.var_rent_id = vrent.var_rent_id;
2180:

Line 2303: pn_var_rents_all pvr,

2299: pvr.rent_num,
2300: pl.org_id
2301: FROM pn_leases pl,
2302: pn_lease_details_all pld,
2303: pn_var_rents_all pvr,
2304: pn_locations_all ploc
2305: WHERE pl.lease_id = pvr.lease_id
2306: AND pld.lease_id = pvr.lease_id
2307: AND ploc.location_id = pvr.location_id

Line 2325: FROM pn_var_rents_all pvr,

2321: pvr.invoice_on,
2322: pvr.cumulative_vol,
2323: pvr.rent_num,
2324: pl.org_id
2325: FROM pn_var_rents_all pvr,
2326: pn_leases pl,
2327: pn_lease_details_all pld
2328: WHERE pl.lease_id = pvr.lease_id
2329: AND pld.lease_id = pvr.lease_id