APPS.OKL_PRB_UPGRADE_PVT dependencies on OKL_TRX_QUOTES_B

Line 767: l_query_string := l_query_string || ' SELECT khr_id FROM okl_trx_quotes_b '

763: || ' WHERE h.id = l.tas_id AND h.tsu_code IN (''ENTERED'',''ERROR'') AND h.tas_type = ''ARC'' ';
764: ELSIF p_in_transit_category = 'TERMINATION'
765: THEN
766: -- Termination Quote Not Accepted
767: l_query_string := l_query_string || ' SELECT khr_id FROM okl_trx_quotes_b '
768: || ' WHERE partial_yn = ''Y'' and qst_code not IN (''ACCEPTED'',''COMPLETE'',''IN_PROCESS'') ';
769: END IF; -- IF p_in_transit_category
770: l_query_string := l_query_string || ' ) ';
771: END IF; -- IF p_criteria_set = 'REVISION'

Line 906: FROM okl_trx_quotes_b

902: AND opp.assigned_process = TO_CHAR(l_seq_next)
903: AND opp.khr_id IN
904: (
905: SELECT khr_id
906: FROM okl_trx_quotes_b
907: WHERE partial_yn = 'Y'
908: AND qst_code NOT IN ('ACCEPTED','COMPLETE','IN_PROCESS')
909: );
910: log_msg(FND_FILE.LOG, 'Checking: Termination Quote Not Accepted - End: '

Line 932: from okl_trx_quotes_b q

928: AND opp.assigned_process = TO_CHAR(l_seq_next)
929: AND exists
930: (
931: select q.khr_id
932: from okl_trx_quotes_b q
933: where q.qtp_code like 'TER%' -- Termination quote
934: and NVL(q.consolidated_yn,'N') = 'N'
935: and q.partial_yn = 'Y'
936: and q.qst_code = 'ACCEPTED'

Line 954: from okl_trx_quotes_b q, okl_trx_contracts_all t

950: AND opp.assigned_process = TO_CHAR(l_seq_next)
951: AND exists
952: (
953: select q.khr_id
954: from okl_trx_quotes_b q, okl_trx_contracts_all t
955: where q.qtp_code like 'TER%'
956: and NVL(q.consolidated_yn,'N') = 'N'
957: and q.partial_yn = 'Y'
958: and q.khr_id = opp.khr_id