APPS.OKL_LEASE_APP_PVT dependencies on OKL_LEASE_OPPORTUNITIES_B

Line 630: 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)

626: l_query_stmt VARCHAR2(100);
627: TYPE l_csr_typ IS REF CURSOR;
628: l_ref_csr l_csr_typ;
629: CURSOR c_get_prefix(c_table_name IN VARCHAR2) IS
630: 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)
631: FROM okl_system_params;
632: l_prefix VARCHAR2(30);
633: l_value VARCHAR(250);
634: BEGIN

Line 1971: FROM OKL_LEASE_OPPORTUNITIES_B LOP

1967:
1968: --Cursor to compare the db values of lease app header with the one in rec
1969: CURSOR lop_db_val_csr(cp_lop_id NUMBER, cp_lapv_rec lapv_rec_type) IS
1970: SELECT LOP.REFERENCE_NUMBER REFERENCE_NUMBER
1971: FROM OKL_LEASE_OPPORTUNITIES_B LOP
1972: WHERE LOP.ID = cp_lop_id
1973: AND NVL(LOP.PROSPECT_ADDRESS_ID, OKL_API.G_MISS_NUM) = NVL(cp_lapv_rec.prospect_address_id, OKL_API.G_MISS_NUM)
1974: AND NVL(LOP.CUST_ACCT_ID, OKL_API.G_MISS_NUM) = NVL(cp_lapv_rec.cust_acct_id, OKL_API.G_MISS_NUM)
1975: AND NVL(LOP.MASTER_LEASE_ID, OKL_API.G_MISS_NUM) = NVL(cp_lapv_rec.master_lease_id, OKL_API.G_MISS_NUM)

Line 2942: FROM OKL_LEASE_OPPORTUNITIES_B LOP

2938: CURSOR lse_app_src_dtls_csr(cp_lap_id NUMBER)
2939: IS
2940: SELECT LSQ.ID LSQ_ID
2941: , LOP.ID LOP_ID
2942: FROM OKL_LEASE_OPPORTUNITIES_B LOP
2943: , OKL_LEASE_QUOTES_B LSQ
2944: WHERE
2945: LSQ.PARENT_OBJECT_ID = LOP.ID
2946: AND LSQ.PARENT_OBJECT_CODE = 'LEASEOPP'

Line 4255: , OKL_LEASE_OPPORTUNITIES_B LOP

4251: SELECT LSQ.ID
4252: , LSQ.REFERENCE_NUMBER
4253: , LSQ.STATUS
4254: FROM OKL_LEASE_QUOTES_B LSQ
4255: , OKL_LEASE_OPPORTUNITIES_B LOP
4256: WHERE LOP.ID = cp_lop_id
4257: AND LSQ.PARENT_OBJECT_CODE = 'LEASEOPP'
4258: AND LSQ.PARENT_OBJECT_ID = LOP.ID
4259: AND LSQ.STATUS = 'CT-ACCEPTED';

Line 5519: FROM OKL_LEASE_OPPORTUNITIES_B LOP

5515: CURSOR src_lse_opp_dtls_csr(cp_lap_id NUMBER)
5516: IS
5517: SELECT LSQ.ID LSQ_ID
5518: , LOP.ID LOP_ID
5519: FROM OKL_LEASE_OPPORTUNITIES_B LOP
5520: , OKL_LEASE_QUOTES_B LSQ
5521: WHERE
5522: LSQ.PARENT_OBJECT_ID = LOP.ID
5523: AND LSQ.PARENT_OBJECT_CODE = 'LEASEOPP'

Line 11843: , OKL_LEASE_OPPORTUNITIES_B LOP

11839: , LOP.REFERENCE_NUMBER LSE_OPP
11840: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
11841: FROM OKL_LEASE_APPLICATIONS_B LAB
11842: , OKL_LEASE_APPLICATIONS_B CLAB
11843: , OKL_LEASE_OPPORTUNITIES_B LOP
11844: , OKC_K_HEADERS_B CHR
11845: , OKC_STATUSES_V CSTS
11846: WHERE LAB.LEASE_OPPORTUNITY_ID = CLAB.LEASE_OPPORTUNITY_ID
11847: AND LOP.ID = LAB.LEASE_OPPORTUNITY_ID

Line 11866: , OKL_LEASE_OPPORTUNITIES_B LOP

11862: , LOP.REFERENCE_NUMBER LSE_OPP
11863: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
11864: FROM OKL_LEASE_QUOTES_B LSQ
11865: , OKL_LEASE_APPLICATIONS_B CLAB
11866: , OKL_LEASE_OPPORTUNITIES_B LOP
11867: , OKC_K_HEADERS_B CHR
11868: , OKC_STATUSES_V CSTS
11869: WHERE LOP.ID = CLAB.LEASE_OPPORTUNITY_ID
11870: AND CHR.ORIG_SYSTEM_ID1 = LOP.ID