APPS.PN_INDEX_AMOUNT_PKG dependencies on PN_LEASE_DETAILS_ALL

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