DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_WORKFLOW_PVT dependencies on OKL_LEASE_APPLICATIONS_B

Line 137: OKL_LEASE_APPLICATIONS_B

133:
134:
135: CURSOR get_lease_app(lease_app_id IN NUMBER) IS
136: SELECT reference_number, valid_from, valid_to FROM
137: OKL_LEASE_APPLICATIONS_B
138: WHERE id= lease_app_id;
139:
140: BEGIN
141: -- set the attributes

Line 749: OKL_LEASE_APPLICATIONS_B

745:
746:
747: CURSOR get_lease_app(lease_app_id IN NUMBER) IS
748: SELECT reference_number FROM
749: OKL_LEASE_APPLICATIONS_B
750: WHERE id= lease_app_id;
751:
752: CURSOR get_object_name(l_code IN VARCHAR2) IS
753: SELECT meaning from fnd_lookups where

Line 958: FROM OKL_LEASE_APPLICATIONS_B LAP

954: CURSOR lse_app_dtls_csr(cp_lap_id NUMBER)
955: IS
956: SELECT LAP.REFERENCE_NUMBER
957: , LAP.APPLICATION_STATUS
958: FROM OKL_LEASE_APPLICATIONS_B LAP
959: WHERE LAP.ID = cp_lap_id;
960: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
961: BEGIN
962: