DBA Data[Home] [Help]

APPS.PN_VAR_RENTS_PKG dependencies on PN_LEASES_ALL

Line 65: SELECT org_id FROM pn_leases_all WHERE lease_id = x_lease_id;

61: FROM PN_VAR_RENTS_ALL
62: WHERE VAR_RENT_ID = X_VAR_RENT_ID ;
63:
64: CURSOR org_cur IS
65: SELECT org_id FROM pn_leases_all WHERE lease_id = x_lease_id;
66: l_org_ID NUMBER;
67:
68:
69: l_return_status VARCHAR2(30) := NULL;