DBA Data[Home] [Help]

APPS.OKL_DEAL_CREAT_PVT dependencies on OKL_LEASE_QUOTES_B

Line 4763: OKL_LEASE_QUOTES_B LSQ

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

Line 9011: FROM okl_lease_quotes_b lsq

9007: WHERE legal_entity_id = cp_legal_entity_id;
9008:
9009: CURSOR c_quote_name(p_chr_orig_system_id1 NUMBER) IS
9010: SELECT lsq.reference_number
9011: FROM okl_lease_quotes_b lsq
9012: WHERE LSQ.parent_object_id = p_chr_orig_system_id1
9013: AND lsq.status = 'CT-ACCEPTED';
9014:
9015: CURSOR c_program_template_name(p_orig_system_id1 NUMBER, p_khr_khr_id NUMBER) IS