APPS.PN_INDEX_AMOUNT_PKG dependencies on PN_LEASE_DETAILS_ALL

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 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 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