APPS.PN_LEASE_PVT dependencies on PN_LEASE_DETAILS_ALL

Line 1541: , pn_lease_details_all pld

1537: , l_lease_rec.lease_commencement_date
1538: , l_lease_rec.lease_termination_date
1539: , l_lease_rec.parent_lease_id
1540: FROM pn_leases_all pla
1541: , pn_lease_details_all pld
1542: WHERE pla.lease_id = p_lease_id
1543: AND pla.lease_id = pld.lease_id
1544: AND pld.org_id = g_org_id
1545: AND pla.org_id = g_org_id;

Line 11926: FROM pn_lease_details_all

11922: , send_entries
11923: , term_template_id
11924: , lease_extension_end_date
11925: , grouping_rule_id
11926: FROM pn_lease_details_all
11927: WHERE lease_id = p_lease_rec.lease_id;
11928:
11929: l_return_status VARCHAR2 (1);
11930: l_debug_mode VARCHAR2 (1);

Line 16813: FROM pn_leases_all pla, pn_lease_details_all pld

16809: , l_parent_lease_id
16810: , l_termtemp_type
16811: , l_lease_change_id
16812: , l_lease_status
16813: FROM pn_leases_all pla, pn_lease_details_all pld
16814: WHERE pla.lease_id = p_lease_id
16815: AND pla.lease_id = pld.lease_id
16816: AND pld.org_id = pla.org_id
16817: AND pla.org_id = g_org_id;

Line 17836: FROM pn_leases_all pla, pn_lease_details_all pld

17832: , l_parent_lease_id
17833: , l_termtemp_type
17834: , l_lease_change_id
17835: , l_lease_status
17836: FROM pn_leases_all pla, pn_lease_details_all pld
17837: WHERE pla.lease_id = p_lease_id
17838: AND pla.lease_id = pld.lease_id
17839: AND pld.org_id = pla.org_id
17840: AND pla.org_id = g_org_id;

Line 18650: ,pn_lease_details_all PLD

18646: ,PLA.status status
18647: ,PLA.lease_status lease_status
18648: ,PLD.lease_commencement_date lease_commencement_date
18649: FROM pn_leases_all PLA
18650: ,pn_lease_details_all PLD
18651: WHERE PLD.lease_id = PLA.lease_id
18652: AND PLD.org_id = PLA.org_id
18653: AND PLA.lease_id = p_lease_id
18654: AND PLA.org_id = g_org_id;