APPS.PN_VARIABLE_TERM_PKG dependencies on PN_LEASES

Line 57: FROM pn_leases pl,

53: per.period_id,
54: per.period_num,
55: pl.lease_class_code,
56: pl.org_id
57: FROM pn_leases pl,
58: pn_lease_details_all pld,
59: pn_var_rents_all pvr,
60: pn_locations_all ploc,
61: pn_var_periods_all per

Line 91: pn_leases pl,

87: per.period_num,
88: pl.lease_class_code,
89: pl.org_id
90: FROM pn_var_rents_all pvr,
91: pn_leases pl,
92: pn_lease_details_all pld,
93: pn_var_periods_all per
94: WHERE pl.lease_id = pvr.lease_id
95: AND pld.lease_id = pvr.lease_id

Line 193: l_org_id pn_leases.org_id%type;

189: l_var_rent_id pn_var_rents.var_rent_id%type;
190: l_pre_var_rent_id pn_var_rents.var_rent_id%type;
191: l_context VARCHAR2(2000);
192: l_errmsg VARCHAR2(2000);
193: l_org_id pn_leases.org_id%type;
194: l_term_temp_id pn_payment_terms.term_template_id%TYPE;
195: l_lease_cls_code pn_leases.lease_class_code%TYPE;
196: l_err_flag VARCHAR2(1);
197: l_inv_sch_date DATE;

Line 195: l_lease_cls_code pn_leases.lease_class_code%TYPE;

191: l_context VARCHAR2(2000);
192: l_errmsg VARCHAR2(2000);
193: l_org_id pn_leases.org_id%type;
194: l_term_temp_id pn_payment_terms.term_template_id%TYPE;
195: l_lease_cls_code pn_leases.lease_class_code%TYPE;
196: l_err_flag VARCHAR2(1);
197: l_inv_sch_date DATE;
198: l_inv_start_date DATE;
199: term_count NUMBER;

Line 663: -- pn_term_templates, pn_leases with _ALL table.

659: -- Bug # 3841542
660: -- 21-APR-05 ftanudja o Added area_type_code, area defaulting. #4324777
661: -- 15-JUL-05 ftanudja o R12 changes: add logic for tax_clsfctn_code. #4495054
662: -- 21-JUN-05 hareesha o Bug 4284035 - Replaced pn_var_rents, pn_distributions,
663: -- pn_term_templates, pn_leases with _ALL table.
664: -- 23-NOV-05 pikhar o Passed org_id in pn_mo_cache_utils.get_profile_value
665: -- 13-DEC-05 rdonthul o Changed the l_payment_term_date for bug 5700403
666: -- 15-MAR-07 pikhar o Bug 5930387. Added include_in_var_rent
667: -------------------------------------------------------------------------------

Line 681: l_lease_class_code pn_leases.lease_class_code%TYPE;

677: ,p_var_rent_type IN VARCHAR2
678: ,p_org_id IN NUMBER
679: ) IS
680:
681: l_lease_class_code pn_leases.lease_class_code%TYPE;
682: l_distribution_id pn_distributions.distribution_id%TYPE;
683: l_payment_term_id pn_payment_terms.payment_term_id%TYPE;
684: l_lease_change_id pn_lease_details.lease_change_id%TYPE;
685: l_rowid ROWID;

Line 748: FROM pn_leases_all pl,

744: pl.org_id
745: INTO l_lease_class_code,
746: l_lease_change_id,
747: l_org_id
748: FROM pn_leases_all pl,
749: pn_lease_details_all pld
750: WHERE pl.lease_id = pld.lease_id
751: AND pld.lease_id = p_lease_id;
752: