APPS.OKL_AM_BTCH_EXP_LEASE_LOAN_PVT dependencies on OKL_TRX_QUOTES_V

Line 1215: FROM okl_trx_quotes_v

1211: ) IS
1212: -- Check if Termination or Restructure Quotes Exists
1213: CURSOR k_quotes_csr (p_khr_id IN NUMBER) IS
1214: SELECT ID
1215: FROM okl_trx_quotes_v
1216: WHERE khr_id = p_khr_id
1217: AND qst_code = 'ACCEPTED'
1218: AND (qtp_code LIKE 'TER%' OR qtp_code LIKE 'RES%');
1219:

Line 1935: FROM okl_trx_quotes_v qte

1931: AND tcn.khr_id = khr.ID) -- rmunjulu PERF
1932: AND khr.ID NOT IN (
1933: -- Contracts which have accepted quotes with no transactions
1934: SELECT NVL (qte.khr_id, -9999) khr_id
1935: FROM okl_trx_quotes_v qte
1936: WHERE NVL (qte.accepted_yn, 'N') = 'Y'
1937: AND NVL (qte.consolidated_yn, 'N') = 'N'
1938: AND qte.khr_id = khr.ID -- rmunjulu PERF
1939: AND qte.ID NOT IN (

Line 2006: FROM okl_trx_quotes_v qte

2002: AND tcn.khr_id = khr.ID) -- rmunjulu PERF
2003: AND khr.ID NOT IN (
2004: -- Contracts which have accepted quotes with no transactions
2005: SELECT NVL (qte.khr_id, -9999) khr_id
2006: FROM okl_trx_quotes_v qte
2007: WHERE NVL (qte.accepted_yn, 'N') = 'Y'
2008: AND NVL (qte.consolidated_yn, 'N') = 'N'
2009: AND qte.khr_id = khr.ID -- rmunjulu PERF
2010: AND qte.ID NOT IN (

Line 3796: FROM okl_trx_quotes_v qte

3792: AND tcn.khr_id = khr.ID) -- rmunjulu PERF
3793: AND khr.ID NOT IN (
3794: -- Contracts which have accepted quotes with no transactions
3795: SELECT NVL (qte.khr_id, -9999) khr_id
3796: FROM okl_trx_quotes_v qte
3797: WHERE NVL (qte.accepted_yn, 'N') = 'Y'
3798: AND NVL (qte.consolidated_yn, 'N') = 'N'
3799: AND qte.khr_id = khr.ID -- rmunjulu PERF
3800: AND qte.ID NOT IN (

Line 3852: FROM OKL_TRX_QUOTES_V QTE

3848: AND TCN.tmt_status_code NOT IN ('CANCELED','PROCESSED')--akrangan changed for sla tmt_status_Code cr
3849: AND TCN.khr_id = opp.khr_id)
3850: AND opp.khr_id NOT IN (
3851: SELECT NVL(QTE.khr_id,-9999) khr_id
3852: FROM OKL_TRX_QUOTES_V QTE
3853: WHERE NVL(QTE.accepted_yn,'N') = 'Y'
3854: AND NVL(QTE.consolidated_yn,'N') = 'N'
3855: AND QTE.khr_id = opp.khr_id
3856: AND QTE.id NOT IN (