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 4337: FROM pn_lease_details_all pld

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

Line 4343: FROM pn_lease_details_all pld

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

Line 5121: v_lease_termination_date pn_lease_details.lease_termination_date%TYPE;

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

Line 5122: v_lease_change_id pn_lease_details.lease_change_id%TYPE;

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

Line 5131: v_expense_account_id pn_lease_details.expense_account_id%TYPE;

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

Line 5132: v_receivable_account_id pn_lease_details.receivable_account_id%TYPE;

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

Line 5474: FROM pn_leases_all pl, pn_lease_details_all pld

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

Line 5943: v_main_lease_commencement_date pn_lease_details.lease_commencement_date%type;

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

Line 6021: FROM pn_leases_all lease, pn_lease_details_all ldet

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