APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on BEN_BATCH_COMMU_INFO

Line 4944: from ben_batch_commu_info bmi,

4940: is
4941: --
4942: cursor c_tot_person_cm is
4943: select count(distinct bmi.person_id)
4944: from ben_batch_commu_info bmi,
4945: ben_benefit_actions bft
4946: where bft.request_id = p_concurrent_request_id
4947: and bft.benefit_action_id = bmi.benefit_action_id;
4948: --

Line 4951: from ben_batch_commu_info bmi1,

4947: and bft.benefit_action_id = bmi.benefit_action_id;
4948: --
4949: cursor c_tot_person_1_cm is
4950: select count(*)
4951: from ben_batch_commu_info bmi1,
4952: ben_benefit_actions bft
4953: where bft.request_id = p_concurrent_request_id
4954: and bft.benefit_action_id = bmi1.benefit_action_id
4955: and not exists ( select 1

Line 4956: from ben_batch_commu_info bmi2

4952: ben_benefit_actions bft
4953: where bft.request_id = p_concurrent_request_id
4954: and bft.benefit_action_id = bmi1.benefit_action_id
4955: and not exists ( select 1
4956: from ben_batch_commu_info bmi2
4957: where bmi2.benefit_action_id = bft.benefit_action_id
4958: and bmi2.person_id = bmi1.person_id
4959: and bmi2.batch_commu_id <> bmi1.batch_commu_id);
4960: --