APPS.OKL_AM_QUOTES_WF dependencies on OKL_QUOTE_PARTIES

Line 2300: FROM okl_quote_parties qp

2296: SELECT qp.party_object1_id1 recipient_id,
2297: qp.party_jtot_object1_code recipient_code,
2298: qp.id party_id,
2299: qp.email_address email_id
2300: FROM okl_quote_parties qp
2301: WHERE qp.qte_id= p_qte_id
2302: AND qp.id> NVL(p_current_party_id, 0)
2303: AND qp.qpt_code LIKE 'RECIPIENT%'
2304: ORDER BY qp.id ASC;

Line 4359: OKL_QUOTE_PARTIES QP,

4355: OTQ.LAST_UPDATED_BY LAST_UPDATED_BY,
4356: OTQ.KHR_ID KHR_ID
4357: FROM OKL_TRX_QUOTES_V OTQ,
4358: OKL_TXL_QUOTE_LINES_B OTL,
4359: OKL_QUOTE_PARTIES QP,
4360: OKC_K_PARTY_ROLES_V PR,
4361: OKC_K_HEADERS_ALL_B AD
4362: WHERE OTQ.ID = c_id
4363: AND pr.id (+) = qp.cpl_id

Line 4826: OKL_QUOTE_PARTIES b

4822: CURSOR get_quote_csr ( p_qte_id IN VARCHAR2)
4823: IS
4824: SELECT a.last_updated_by, a.quote_number, count(*) recs
4825: FROM OKL_TRX_QUOTES_B a,
4826: OKL_QUOTE_PARTIES b
4827: WHERE a.id = p_qte_id
4828: and a.qst_code in ('DRAFTED', 'REJECTED')
4829: and b.qte_id (+) = a.id
4830: GROUP BY a.last_updated_by, a.quote_number;

Line 7171: okl_quote_parties b

7167: CURSOR get_quote_csr ( p_qte_id IN VARCHAR2)
7168: IS
7169: SELECT a.last_updated_by, a.quote_number
7170: FROM OKL_TRX_QUOTES_B a,
7171: okl_quote_parties b
7172: WHERE a.id = p_qte_id
7173: and a.qst_code in ('ACCEPTED')
7174: and b.qte_id (+) = a.id;
7175: