APPS.PN_SCHEDULES_ITEMS dependencies on PN_LEASES_ALL

Line 1368: FROM pn_leases_all

1364:
1365:
1366: CURSOR org_cur IS
1367: SELECT org_id
1368: FROM pn_leases_all
1369: WHERE lease_id = p_lease_id;
1370:
1371: CURSOR sched_exists(p_payment_term_id NUMBER,p_sch_dt DATE) IS
1372: SELECT sched.payment_schedule_id

Line 3847: pn_leases_all lease

3843: changes.change_commencement_date amd_comm_date
3844: FROM pn_lease_details_all details,
3845: pn_lease_details_history det_history,
3846: pn_lease_changes_all changes,
3847: pn_leases_all lease
3848: WHERE details.lease_id = p_lease_id
3849: AND det_history.lease_id = p_lease_id
3850: AND changes.lease_id = p_lease_id
3851: AND lease.lease_id = p_lease_id

Line 4230: FROM pn_leases_all

4226: l_sch_str_dt DATE;
4227:
4228: CURSOR get_lease_status(p_lease_id NUMBER) IS
4229: SELECT lease_status
4230: FROM pn_leases_all
4231: WHERE lease_id = p_lease_id;
4232:
4233: CURSOR get_lof_terms(p_lease_id NUMBER) IS
4234: SELECT ppt.payment_term_id,

Line 4779: -- tables pn_lease_details_all and pn_leases_all

4775: ------------------------------------------------------------------------
4776: -- FUNCTION :- GET_LEASE_CHANGE_ID
4777: -- 23-SEP-2002 graghuna o created
4778: -- 10-DEC-2002 graghuna o Modified Cursor lease_dt_hist_cursor. Union to
4779: -- tables pn_lease_details_all and pn_leases_all
4780: -- for Month-to-Month Re-Normalization issue. --MTM-I
4781: ------------------------------------------------------------------------
4782: FUNCTION Get_Lease_Change_Id (p_lease_id IN NUMBER)
4783: RETURN NUMBER

Line 4795: FROM pn_leases_all a, pn_lease_details_all b

4791: FROM pn_lease_details_history
4792: WHERE lease_id = p_lease_id
4793: UNION
4794: SELECT b.lease_change_id, a.lease_status
4795: FROM pn_leases_all a, pn_lease_details_all b
4796: WHERE a.lease_id = b.lease_id
4797: AND a.lease_id = p_lease_id
4798: ORDER BY 1 DESC;
4799:

Line 7024: FROM pn_leases_all pl,

7020: pl.lease_status,
7021: pl.lease_class_code,
7022: pl.lease_num,
7023: pl.name
7024: FROM pn_leases_all pl,
7025: pn_lease_details_all pld
7026: WHERE pl.lease_id = p_lease_id
7027: AND pld.lease_id = pl.lease_id;
7028:

Line 7060: pn_leases_all lease

7056: details.lease_termination_date lease_term_date,
7057: det_history.lease_extension_end_date lease_ext_end_date
7058: FROM pn_lease_details_all details,
7059: pn_lease_details_history det_history,
7060: pn_leases_all lease
7061: WHERE details.lease_id = p_lease_id
7062: AND det_history.lease_id = p_lease_id
7063: AND lease.lease_id = p_lease_id
7064: AND details.lease_change_id = det_history.new_lease_change_id;