APPS.BIX_EMAILS_SUMMARY_PKG dependencies on DUAL

Line 164: FROM dual;

160:
161: /* No of jobs to be submitted = Number of 4 hours buckets for which we need to collect data */
162: SELECT ceil(g_collect_end_date - g_collect_start_date)
163: INTO l_count
164: FROM dual;
165:
166: g_no_of_jobs := l_count;
167:
168: write_log('Number of workers that need to be instantiated : ' || to_char(l_count));

Line 737: FROM DUAL

733: ,l_two_done_rsln(i) two_rsln_in_period
734: ,l_three_done_rsln(i) three_rsln_in_period
735: ,l_four_done_rsln(i) four_rsln_in_period
736: ,l_intr_thread(i) interaction_threads_in_period
737: FROM DUAL
738: UNION ALL
739: SELECT
740: l_agent_id(i) agent_id
741: ,l_email_account_id(i) email_account_id

Line 753: FROM DUAL

749: ,l_two_done_rsln(i) two_rsln_in_period
750: ,l_three_done_rsln(i) three_rsln_in_period
751: ,l_four_done_rsln(i) four_rsln_in_period
752: ,l_intr_thread(i) interaction_threads_in_period
753: FROM DUAL
754: UNION ALL
755: SELECT
756: l_agent_id(i) agent_id
757: ,l_email_account_id(i) email_account_id

Line 769: FROM DUAL

765: ,l_two_done_rsln(i) two_rsln_in_period
766: ,l_three_done_rsln(i) three_rsln_in_period
767: ,l_four_done_rsln(i) four_rsln_in_period
768: ,l_intr_thread(i) interaction_threads_in_period
769: FROM DUAL
770: UNION ALL
771: SELECT
772: l_agent_id(i) agent_id
773: ,l_email_account_id(i) email_account_id

Line 785: FROM DUAL

781: ,l_two_done_rsln(i) two_rsln_in_period
782: ,l_three_done_rsln(i) three_rsln_in_period
783: ,l_four_done_rsln(i) four_rsln_in_period
784: ,l_intr_thread(i) interaction_threads_in_period
785: FROM DUAL
786: UNION ALL
787: SELECT
788: l_agent_id(i) agent_id
789: ,l_email_account_id(i) email_account_id

Line 801: FROM DUAL) change

797: ,l_two_done_rsln(i) two_rsln_in_period
798: ,l_three_done_rsln(i) three_rsln_in_period
799: ,l_four_done_rsln(i) four_rsln_in_period
800: ,l_intr_thread(i) interaction_threads_in_period
801: FROM DUAL) change
802: ON (
803: bed.agent_id = change.agent_id
804: AND bed.party_id = change.party_id
805: AND bed.email_account_id = change.email_account_id

Line 889: FROM dual ) change

885: USING (
886: SELECT
887: l_root_interaction_id(i) interaction_id,
888: l_curr_depth(i) depth
889: FROM dual ) change
890: ON (bit.interaction_id = change.interaction_id)
891: WHEN MATCHED THEN
892: UPDATE
893: SET bit.depth = change.depth,