APPS.OKL_DEAL_CREAT_PVT dependencies on OKL_LEASE_APPLICATIONS_B

Line 4775: FROM OKL_LEASE_APPLICATIONS_B

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

Line 4791: OKL_LEASE_APPLICATIONS_B LAP

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

Line 4806: FROM OKL_LEASE_APPLICATIONS_B

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

Line 9029: FROM OKL_LEASE_APPLICATIONS_B LAP,

9025: AND vpaso.assoc_object_type_code = 'LC_TEMPLATE');
9026:
9027: CURSOR c_orig_lease_application(p_orig_syststem_id1 NUMBER) IS
9028: SELECT LAP.reference_number
9029: FROM OKL_LEASE_APPLICATIONS_B LAP,
9030: OKL_LEASE_APPLICATIONS_TL LAPT
9031: WHERE LAP.id = LAPT.id
9032: AND LAPT.LANGUAGE = USERENV('LANG')
9033: AND lap.id = p_orig_syststem_id1;