APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on BEN_BATCH_COMMU_INFO

Line 4879: from ben_batch_commu_info bmi,

4875: is
4876: --
4877: cursor c_tot_person_cm is
4878: select count(distinct bmi.person_id)
4879: from ben_batch_commu_info bmi,
4880: ben_benefit_actions bft
4881: where bft.request_id = p_concurrent_request_id
4882: and bft.benefit_action_id = bmi.benefit_action_id;
4883: --

Line 4886: from ben_batch_commu_info bmi1,

4882: and bft.benefit_action_id = bmi.benefit_action_id;
4883: --
4884: cursor c_tot_person_1_cm is
4885: select count(*)
4886: from ben_batch_commu_info bmi1,
4887: ben_benefit_actions bft
4888: where bft.request_id = p_concurrent_request_id
4889: and bft.benefit_action_id = bmi1.benefit_action_id
4890: and not exists ( select 1

Line 4891: from ben_batch_commu_info bmi2

4887: ben_benefit_actions bft
4888: where bft.request_id = p_concurrent_request_id
4889: and bft.benefit_action_id = bmi1.benefit_action_id
4890: and not exists ( select 1
4891: from ben_batch_commu_info bmi2
4892: where bmi2.benefit_action_id = bft.benefit_action_id
4893: and bmi2.person_id = bmi1.person_id
4894: and bmi2.batch_commu_id <> bmi1.batch_commu_id);
4895: --