DBA Data[Home] [Help]

APPS.OKL_DEAL_CREAT_PVT dependencies on OKL_LEASE_QUOTES_B

Line 4766: OKL_LEASE_QUOTES_B LSQ

4762: LSQ.ID QUOTE_ID
4763: -- ,LSQ.REFERENCE_NUMBER QUOTE_NUMBER
4764: -- ,LSQT.SHORT_DESCRIPTION QUOTE_DESCRIPTION
4765: FROM
4766: OKL_LEASE_QUOTES_B LSQ
4767: ,OKL_LEASE_QUOTES_TL LSQT
4768: ,OKL_LEASE_OPPORTUNITIES_B LOP
4769: WHERE LOP.ORG_ID = p_auth_org_id
4770: AND LOP.INV_ORG_ID = p_inv_org_id

Line 9106: FROM okl_lease_quotes_b lsq

9102: WHERE legal_entity_id = cp_legal_entity_id;
9103:
9104: CURSOR c_quote_name(p_chr_orig_system_id1 NUMBER) IS
9105: SELECT lsq.reference_number
9106: FROM okl_lease_quotes_b lsq
9107: WHERE LSQ.parent_object_id = p_chr_orig_system_id1
9108: AND lsq.status = 'CT-ACCEPTED';
9109:
9110: CURSOR c_program_template_name(p_orig_system_id1 NUMBER, p_khr_khr_id NUMBER) IS