APPS.PN_APPROVE_VARENT_PKG dependencies on PN_LEASES

Line 20: -- 14-JUL-05 HRodda o Bug 4284035 - Replaced pn_leases with _ALL table.

16: -- 09-Jan-03 DThota o Changed p_period_date to VARCHAR2 from DATE in
17: -- approve_payment_term_batch and put in
18: -- fnd_date.canonical_to_date before p_period_date in
19: -- the WHERE clause of CURSOR csr_get_inv. Bug#2733870
20: -- 14-JUL-05 HRodda o Bug 4284035 - Replaced pn_leases with _ALL table.
21: -- 26-Oct-06 Shabda o Modified cursor csr_get_inv to accomodate true_up invoices
22: -- 27-Oct-06 Shabda o Modified cursor csr_get_inv to accomodate adjustment terms
23: -- for variance, which may not have corresponding forecasted
24: -- terms

Line 56: FROM pn_leases pl,

52: SELECT pvr.var_rent_id,
53: pvr.rent_num,
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

Line 78: FROM pn_leases pl,

74: SELECT pvr.var_rent_id,
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

Line 158: l_lease_status pn_leases.status%type;

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';
162: l_errmsg VARCHAR2(2000);

Line 465: FROM pn_leases_all

461:
462: /* get lease class code */
463: CURSOR get_lease_class(p_lease_ID IN NUMBER) IS
464: SELECT lease_class_code
465: FROM pn_leases_all
466: WHERE lease_ID = p_lease_ID;
467:
468:
469: -- Get the details of