APPS.BEN_CWG_BUS dependencies on BEN_CWB_WKSHT_GRP

Line 31: , ben_cwb_wksht_grp cwg

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , ben_cwb_wksht_grp cwg
32: where cwg.cwb_wksht_grp_id = p_cwb_wksht_grp_id
33: and pbg.business_group_id = cwg.business_group_id;
34: --
35: -- Declare local variables

Line 101: , ben_cwb_wksht_grp cwg

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , ben_cwb_wksht_grp cwg
102: where cwg.cwb_wksht_grp_id = p_cwb_wksht_grp_id
103: and pbg.business_group_id = cwg.business_group_id;
104: --
105: -- Declare local variables

Line 543: from ben_cwb_wksht_grp cwg

539: l_dummy number;
540: --
541: cursor c_cwg is
542: select 1
543: from ben_cwb_wksht_grp cwg
544: where cwg.cwb_wksht_grp_id <> nvl(p_cwb_wksht_grp_id,-9999)
545: and pl_id = p_pl_id
546: and cwg.ordr_num = p_ordr_num
547: and cwg.business_group_id = p_business_group_id;

Line 613: from ben_cwb_wksht_grp cwg

609: l_dummy number;
610: --
611: cursor c_cwg is
612: select 1
613: from ben_cwb_wksht_grp cwg
614: where cwg.cwb_wksht_grp_id <> nvl(p_cwb_wksht_grp_id,-9999)
615: and pl_id = p_pl_id
616: and upper(cwg.label) = upper(p_label)
617: and cwg.business_group_id = p_business_group_id;