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 796: OKL_LEASE_APPLICATIONS_B

792:
793:
794: CURSOR get_lease_app(lease_app_id IN NUMBER) IS
795: SELECT reference_number FROM
796: OKL_LEASE_APPLICATIONS_B
797: WHERE id= lease_app_id;
798:
799: CURSOR get_object_name(l_code IN VARCHAR2) IS
800: SELECT meaning from fnd_lookups where

Line 1030: FROM OKL_LEASE_APPLICATIONS_B LAP

1026: CURSOR lse_app_dtls_csr(cp_lap_id NUMBER)
1027: IS
1028: SELECT LAP.REFERENCE_NUMBER
1029: , LAP.APPLICATION_STATUS
1030: FROM OKL_LEASE_APPLICATIONS_B LAP
1031: WHERE LAP.ID = cp_lap_id;
1032: lse_app_dtls_rec lse_app_dtls_csr%ROWTYPE;
1033: BEGIN
1034: