APPS.OKL_LEASE_APP_PVT dependencies on OKL_LEASE_OPPORTUNITIES_B

Line 588: SELECT DECODE(c_table_name,'OKL_LEASE_QUOTES_B',LSEQTE_SEQ_PREFIX_TXT,'OKL_QUICK_QUOTES_B',QCKQTE_SEQ_PREFIX_TXT,'OKL_LEASE_OPPORTUNITIES_B',LSEOPP_SEQ_PREFIX_TXT,'OKL_LEASE_APPLICATIONS_B',LSEAPP_SEQ_PREFIX_TXT)

584: l_query_stmt VARCHAR2(100);
585: TYPE l_csr_typ IS REF CURSOR;
586: l_ref_csr l_csr_typ;
587: CURSOR c_get_prefix(c_table_name IN VARCHAR2) IS
588: SELECT DECODE(c_table_name,'OKL_LEASE_QUOTES_B',LSEQTE_SEQ_PREFIX_TXT,'OKL_QUICK_QUOTES_B',QCKQTE_SEQ_PREFIX_TXT,'OKL_LEASE_OPPORTUNITIES_B',LSEOPP_SEQ_PREFIX_TXT,'OKL_LEASE_APPLICATIONS_B',LSEAPP_SEQ_PREFIX_TXT)
589: FROM okl_system_params;
590: l_prefix VARCHAR2(30);
591: l_value VARCHAR(250);
592: BEGIN

Line 1929: FROM OKL_LEASE_OPPORTUNITIES_B LOP

1925:
1926: --Cursor to compare the db values of lease app header with the one in rec
1927: CURSOR lop_db_val_csr(cp_lop_id NUMBER, cp_lapv_rec lapv_rec_type) IS
1928: SELECT LOP.REFERENCE_NUMBER REFERENCE_NUMBER
1929: FROM OKL_LEASE_OPPORTUNITIES_B LOP
1930: WHERE LOP.ID = cp_lop_id
1931: AND NVL(LOP.PROSPECT_ADDRESS_ID, OKL_API.G_MISS_NUM) = NVL(cp_lapv_rec.prospect_address_id, OKL_API.G_MISS_NUM)
1932: AND NVL(LOP.CUST_ACCT_ID, OKL_API.G_MISS_NUM) = NVL(cp_lapv_rec.cust_acct_id, OKL_API.G_MISS_NUM)
1933: AND NVL(LOP.MASTER_LEASE_ID, OKL_API.G_MISS_NUM) = NVL(cp_lapv_rec.master_lease_id, OKL_API.G_MISS_NUM)

Line 2900: FROM OKL_LEASE_OPPORTUNITIES_B LOP

2896: CURSOR lse_app_src_dtls_csr(cp_lap_id NUMBER)
2897: IS
2898: SELECT LSQ.ID LSQ_ID
2899: , LOP.ID LOP_ID
2900: FROM OKL_LEASE_OPPORTUNITIES_B LOP
2901: , OKL_LEASE_QUOTES_B LSQ
2902: WHERE
2903: LSQ.PARENT_OBJECT_ID = LOP.ID
2904: AND LSQ.PARENT_OBJECT_CODE = 'LEASEOPP'

Line 4167: , OKL_LEASE_OPPORTUNITIES_B LOP

4163: SELECT LSQ.ID
4164: , LSQ.REFERENCE_NUMBER
4165: , LSQ.STATUS
4166: FROM OKL_LEASE_QUOTES_B LSQ
4167: , OKL_LEASE_OPPORTUNITIES_B LOP
4168: WHERE LOP.ID = cp_lop_id
4169: AND LSQ.PARENT_OBJECT_CODE = 'LEASEOPP'
4170: AND LSQ.PARENT_OBJECT_ID = LOP.ID
4171: AND LSQ.STATUS = 'CT-ACCEPTED';

Line 5431: FROM OKL_LEASE_OPPORTUNITIES_B LOP

5427: CURSOR src_lse_opp_dtls_csr(cp_lap_id NUMBER)
5428: IS
5429: SELECT LSQ.ID LSQ_ID
5430: , LOP.ID LOP_ID
5431: FROM OKL_LEASE_OPPORTUNITIES_B LOP
5432: , OKL_LEASE_QUOTES_B LSQ
5433: WHERE
5434: LSQ.PARENT_OBJECT_ID = LOP.ID
5435: AND LSQ.PARENT_OBJECT_CODE = 'LEASEOPP'

Line 11691: , OKL_LEASE_OPPORTUNITIES_B LOP

11687: , LOP.REFERENCE_NUMBER LSE_OPP
11688: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
11689: FROM OKL_LEASE_APPLICATIONS_B LAB
11690: , OKL_LEASE_APPLICATIONS_B CLAB
11691: , OKL_LEASE_OPPORTUNITIES_B LOP
11692: , OKC_K_HEADERS_B CHR
11693: , OKC_STATUSES_V CSTS
11694: WHERE LAB.LEASE_OPPORTUNITY_ID = CLAB.LEASE_OPPORTUNITY_ID
11695: AND LOP.ID = LAB.LEASE_OPPORTUNITY_ID

Line 11714: , OKL_LEASE_OPPORTUNITIES_B LOP

11710: , LOP.REFERENCE_NUMBER LSE_OPP
11711: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
11712: FROM OKL_LEASE_QUOTES_B LSQ
11713: , OKL_LEASE_APPLICATIONS_B CLAB
11714: , OKL_LEASE_OPPORTUNITIES_B LOP
11715: , OKC_K_HEADERS_B CHR
11716: , OKC_STATUSES_V CSTS
11717: WHERE LOP.ID = CLAB.LEASE_OPPORTUNITY_ID
11718: AND CHR.ORIG_SYSTEM_ID1 = LOP.ID