APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_TRX_QUOTES_ALL_B

Line 544: FROM okl_trx_quotes_all_b

540: IS
541: SELECT date_effective_from
542: ,quote_number
543: ,qtp_code
544: FROM okl_trx_quotes_all_b
545: WHERE id = l_qte_id;
546:
547: -- Cursor to fetch contingency code and stream type name
548: -- applicable only for AR.

Line 669: FROM okl_trx_quotes_all_b qte

665: IS
666: SELECT qte.quote_number quote_number
667: ,qte.date_accepted quote_accepted_date
668: ,qte.qtp_code quote_type
669: FROM okl_trx_quotes_all_b qte
670: ,okl_txl_quote_lines_b tql
671: WHERE qte.id = tql.qte_id
672: AND qte.qst_code in ('ACCEPTED', 'COMPLETE')
673: AND qte.accepted_yn = 'Y'

Line 684: FROM okl_trx_quotes_all_b qte

680: IS
681: SELECT qte.quote_number quote_number
682: ,qte.date_accepted quote_accepted_date
683: ,qte.qtp_code quote_type
684: FROM okl_trx_quotes_all_b qte
685: ,okl_txl_quote_lines_b tql
686: WHERE qte.id = tql.qte_id
687: AND qte.qst_code in ('ACCEPTED', 'COMPLETE')
688: AND qte.accepted_yn = 'Y'

Line 711: ,okl_trx_quotes_all_b qte

707: ,qte.date_accepted quote_accepted_date
708: ,qte.qtp_code quote_type
709: FROM okl_trx_types_b trx_b
710: ,okl_trx_contracts_all rel_trx
711: ,okl_trx_quotes_all_b qte
712: WHERE trx_b.trx_type_class = 'RE_LEASE'
713: AND trx_b.id = rel_trx.try_id
714: AND rel_trx.khr_id_new = p_khr_id
715: AND rel_trx.tsu_code <> 'PROCESSED'

Line 731: ,okl_trx_quotes_all_b qte

727: qte.qtp_code quote_type
728:
729: FROM okl_trx_types_b trx_b
730: ,okl_trx_contracts_all rel_trx
731: ,okl_trx_quotes_all_b qte
732: ,okl_txl_quote_lines_b qtl
733: WHERE trx_b.trx_type_class = 'TERMINATION'
734: AND trx_b.id = rel_trx.try_id
735: AND rel_trx.khr_id = p_khr_id