APPS.BIX_CALL_UPDATE_PKG dependencies on JTF_IH_RESULTS_B

Line 3622: FROM jtf_ih_results_b

3618: END IF;
3619:
3620: SELECT nvl(max(decode(positive_response_flag,'Y',1,0)),0)
3621: INTO l_target_record.agentcall_pr_count(counter)
3622: FROM jtf_ih_results_b
3623: WHERE result_id = l_target_record.result_id(counter);
3624:
3625: /* Add count for US Predictive Abandoned rate */
3626: IF l_source_record.abandon_flag(i) = 'U' and l_source_record.direction(i) = 'OUTBOUND'

Line 5807: from jtf_ih_interactions a, jtf_ih_results_b b

5803: 0,0,0,0,0,
5804: 0,0,0,0,0,
5805: 0,0,0,0,0,
5806: 0,0,0,0,0,0
5807: from jtf_ih_interactions a, jtf_ih_results_b b
5808: where a.result_id=b.result_id
5809: and a.end_date_time between g_collect_start_date and g_collect_end_date
5810: and b.positive_response_flag='Y'
5811: and a.active='N'