APPS.BIX_CALL_LOAD_PKG dependencies on JTF_IH_RESULTS_B

Line 3535: FROM jtf_ih_results_b

3531: END IF;
3532:
3533: SELECT nvl(max(decode(positive_response_flag,'Y',1,0)),0)
3534: INTO l_target_record.agentcall_pr_count(counter)
3535: FROM jtf_ih_results_b
3536: WHERE result_id = l_target_record.result_id(counter);
3537:
3538: /* Add count for US Predictive Abandoned rate */
3539: IF l_source_record.abandon_flag(i) = 'U' and l_source_record.direction(i) = 'OUTBOUND'

Line 5823: from jtf_ih_interactions a, jtf_ih_results_b b

5819: 0,0,0,0,0,
5820: 0,0,0,0,0,
5821: 0,0,0,0,0,
5822: 0,0,0,0,0,0
5823: from jtf_ih_interactions a, jtf_ih_results_b b
5824: where a.result_id=b.result_id
5825: and b.positive_response_flag='Y'
5826: and a.end_date_time BETWEEN g_collect_start_date AND g_collect_end_date
5827: and a.active='N'