APPS.OKL_DEAL_CREAT_PVT dependencies on OKL_LEASE_APPLICATIONS_B

Line 4778: FROM OKL_LEASE_APPLICATIONS_B

4774: AND LSQT.LANGUAGE = USERENV('LANG')
4775: AND LSQ.STATUS = 'CT-ACCEPTED'
4776: AND LSQ.REFERENCE_NUMBER = p_quote_number
4777: AND NOT EXISTS (SELECT 1
4778: FROM OKL_LEASE_APPLICATIONS_B
4779: WHERE LEASE_OPPORTUNITY_ID = LOP.ID
4780: AND APPLICATION_STATUS <> 'WITHDRAWN')
4781: AND NOT EXISTS (SELECT 1
4782: FROM OKC_K_HEADERS_B

Line 4794: OKL_LEASE_APPLICATIONS_B LAP

4790: LAP.ID LEASEAPP_ID
4791: --,LAP.REFERENCE_NUMBER LEASEAPP_NUMBER
4792: --,LAPT.SHORT_DESCRIPTION LEASEAPP_DESCRIPTION
4793: FROM
4794: OKL_LEASE_APPLICATIONS_B LAP
4795: ,OKL_LEASE_APPLICATIONS_TL LAPT
4796: WHERE
4797: LAP.ORG_ID = p_auth_org_id
4798: AND LAP.INV_ORG_ID = p_inv_org_id

Line 4809: FROM OKL_LEASE_APPLICATIONS_B

4805: WHERE ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP'
4806: AND ORIG_SYSTEM_ID1 = LAP.ID
4807: AND STS_CODE <> 'ABANDONED')
4808: AND NOT EXISTS (SELECT 1
4809: FROM OKL_LEASE_APPLICATIONS_B
4810: WHERE PARENT_LEASEAPP_ID = LAP.ID
4811: AND APPLICATION_STATUS NOT IN ('WITHDRAWN' , 'CR-REJECTED'));
4812:
4813: l_template_type OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE;

Line 9124: FROM OKL_LEASE_APPLICATIONS_B LAP,

9120: AND vpaso.assoc_object_type_code = 'LC_TEMPLATE');
9121:
9122: CURSOR c_orig_lease_application(p_orig_syststem_id1 NUMBER) IS
9123: SELECT LAP.reference_number
9124: FROM OKL_LEASE_APPLICATIONS_B LAP,
9125: OKL_LEASE_APPLICATIONS_TL LAPT
9126: WHERE LAP.id = LAPT.id
9127: AND LAPT.LANGUAGE = USERENV('LANG')
9128: AND lap.id = p_orig_syststem_id1;