eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_INDEX_AMOUNT_PKG dependencies on PN_LEASE_DETAILS

Line 4339: FROM pn_lease_details_all pld

4335: /* sets date for payment terms that will have todays date.*/
4336:
4337: SELECT pld.lease_termination_date
4338: INTO v_main_lease_termination_date
4339: FROM pn_lease_details_all pld
4340: WHERE pld.lease_id = p_lease_id;
4341:
4342: -- IF g_create_terms_ext_period = 'Y' THEN /*Commented for bug# 11671285*/
4343: SELECT NVL(pld.lease_extension_end_date,pld.lease_termination_date)

Line 4345: FROM pn_lease_details_all pld

4341:
4342: -- IF g_create_terms_ext_period = 'Y' THEN /*Commented for bug# 11671285*/
4343: SELECT NVL(pld.lease_extension_end_date,pld.lease_termination_date)
4344: INTO v_main_lease_termination_date
4345: FROM pn_lease_details_all pld
4346: WHERE pld.lease_id = p_lease_id;
4347: -- END IF; /*Commented for bug# 11671285*/
4348:
4349: /* derive payment defaults for this index lease */

Line 5123: v_lease_termination_date pn_lease_details.lease_termination_date%TYPE;

5119: v_attribute12 pn_term_templates.attribute12%TYPE;
5120: v_attribute13 pn_term_templates.attribute13%TYPE;
5121: v_attribute14 pn_term_templates.attribute14%TYPE;
5122: v_attribute15 pn_term_templates.attribute15%TYPE;
5123: v_lease_termination_date pn_lease_details.lease_termination_date%TYPE;
5124: v_lease_change_id pn_lease_details.lease_change_id%TYPE;
5125: v_lease_class_code pn_leases.lease_class_code%TYPE;
5126: v_distribution_id pn_distributions.distribution_id%TYPE;
5127: v_rowid VARCHAR2 (100);

Line 5124: v_lease_change_id pn_lease_details.lease_change_id%TYPE;

5120: v_attribute13 pn_term_templates.attribute13%TYPE;
5121: v_attribute14 pn_term_templates.attribute14%TYPE;
5122: v_attribute15 pn_term_templates.attribute15%TYPE;
5123: v_lease_termination_date pn_lease_details.lease_termination_date%TYPE;
5124: v_lease_change_id pn_lease_details.lease_change_id%TYPE;
5125: v_lease_class_code pn_leases.lease_class_code%TYPE;
5126: v_distribution_id pn_distributions.distribution_id%TYPE;
5127: v_rowid VARCHAR2 (100);
5128: v_payment_term_id pn_payment_terms.payment_term_id%TYPE;

Line 5133: v_expense_account_id pn_lease_details.expense_account_id%TYPE;

5129: v_freq_divisor NUMBER;
5130: v_converted_amount NUMBER;
5131: v_actual_amount pn_payment_terms.actual_amount%TYPE;
5132: v_gl_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
5133: v_expense_account_id pn_lease_details.expense_account_id%TYPE;
5134: v_receivable_account_id pn_lease_details.receivable_account_id%TYPE;
5135: v_account_class pn_distributions.account_class%TYPE;
5136: v_payment_end_date DATE;
5137: v_num_years NUMBER;

Line 5134: v_receivable_account_id pn_lease_details.receivable_account_id%TYPE;

5130: v_converted_amount NUMBER;
5131: v_actual_amount pn_payment_terms.actual_amount%TYPE;
5132: v_gl_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
5133: v_expense_account_id pn_lease_details.expense_account_id%TYPE;
5134: v_receivable_account_id pn_lease_details.receivable_account_id%TYPE;
5135: v_account_class pn_distributions.account_class%TYPE;
5136: v_payment_end_date DATE;
5137: v_num_years NUMBER;
5138: rec_payment_details pn_payment_terms%ROWTYPE;

Line 5476: FROM pn_leases_all pl, pn_lease_details_all pld

5472: INTO v_lease_class_code
5473: ,v_expense_account_id
5474: ,v_lease_termination_date
5475: ,v_lease_change_id
5476: FROM pn_leases_all pl, pn_lease_details_all pld
5477: WHERE pl.lease_id = pld.lease_id
5478: AND pld.lease_id = p_lease_id;
5479:
5480: EXCEPTION

Line 5945: v_main_lease_commencement_date pn_lease_details.lease_commencement_date%type;

5941: v_current_cpi_value pn_index_lease_periods.current_index_line_value%TYPE;
5942: v_current_cpi_id pn_index_lease_periods.current_index_line_id%TYPE;
5943: v_previous_cpi_value pn_index_lease_periods.previous_index_line_value%TYPE;
5944: v_previous_cpi_id pn_index_lease_periods.previous_index_line_id%TYPE;
5945: v_main_lease_commencement_date pn_lease_details.lease_commencement_date%type;
5946: v_initial_basis_amt NUMBER := 0;
5947: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;
5948: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;
5949: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;

Line 6023: FROM pn_leases_all lease, pn_lease_details_all ldet

6019: CURSOR get_lease_details(p_lease_id NUMBER) IS
6020: SELECT lease_commencement_date,
6021: lease_termination_date,
6022: lease_extension_end_date
6023: FROM pn_leases_all lease, pn_lease_details_all ldet
6024: WHERE lease.lease_id = ldet.lease_id
6025: AND lease.lease_id = p_lease_id;
6026:
6027: CURSOR get_extendable_terms(p_index_period_id NUMBER,l_term_date DATE) IS