APPS.PN_APPROVE_VARENT_PKG dependencies on PN_VAR_RENTS

Line 58: pn_var_rents_all pvr,

54: pvr.invoice_on,
55: pl.status
56: FROM pn_leases pl,
57: pn_lease_details_all pld,
58: pn_var_rents_all pvr,
59: pn_locations_all ploc
60: WHERE pl.lease_id = pvr.lease_id
61: AND pld.lease_id = pvr.lease_id
62: AND ploc.location_id = pvr.location_id

Line 79: pn_var_rents_all pvr,

75: pvr.rent_num,
76: pvr.invoice_on,
77: pl.status
78: FROM pn_leases pl,
79: pn_var_rents_all pvr,
80: pn_lease_details_all pld
81: WHERE pl.lease_id = pvr.lease_id
82: AND pld.lease_id = pvr.lease_id
83: AND pl.lease_num >= NVL(p_lease_num_from, pl.lease_num)

Line 155: l_var_rent_id pn_var_rents.var_rent_id%type;

151: )temp
152: ORDER BY period_num,invoice_date;
153:
154:
155: l_var_rent_id pn_var_rents.var_rent_id%type;
156: l_rent_num pn_var_rents.rent_num%type;
157: l_invoice_on pn_var_rents.invoice_on%type;
158: l_lease_status pn_leases.status%type;
159: l_rent_type pn_payment_terms.var_rent_type%type;

Line 156: l_rent_num pn_var_rents.rent_num%type;

152: ORDER BY period_num,invoice_date;
153:
154:
155: l_var_rent_id pn_var_rents.var_rent_id%type;
156: l_rent_num pn_var_rents.rent_num%type;
157: l_invoice_on pn_var_rents.invoice_on%type;
158: l_lease_status pn_leases.status%type;
159: l_rent_type pn_payment_terms.var_rent_type%type;
160: l_rent_amt NUMBER;

Line 157: l_invoice_on pn_var_rents.invoice_on%type;

153:
154:
155: l_var_rent_id pn_var_rents.var_rent_id%type;
156: l_rent_num pn_var_rents.rent_num%type;
157: l_invoice_on pn_var_rents.invoice_on%type;
158: l_lease_status pn_leases.status%type;
159: l_rent_type pn_payment_terms.var_rent_type%type;
160: l_rent_amt NUMBER;
161: l_exists VARCHAR2(1) := 'N';

Line 473: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

469: -- Get the details of
470: CURSOR period_FY_cur(p_period_id NUMBER,
471: p_var_rent_id NUMBER) IS
472: SELECT period_id
473: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
474: WHERE pvr.var_rent_id = pvp.var_rent_id
475: AND pvp.period_id = p_period_id
476: AND pvr.var_rent_id = p_var_rent_id
477: AND pvr.proration_rule IN ('FLY', 'FY')