APPS.PER_CIT_BUS dependencies on PER_BUSINESS_GROUPS

Line 28: -- per_cagr_entitlement_items_tl and PER_BUSINESS_GROUPS

24: --
25: -- Declare cursor
26: --
27: -- EDIT_HERE In the following cursor statement add join(s) between
28: -- per_cagr_entitlement_items_tl and PER_BUSINESS_GROUPS
29: -- so that the security_group_id for
30: -- the current business group context can be derived.
31: -- Remove this comment when the edit has been completed.
32: -- Bug 3648630 Starts Here

Line 36: from per_business_groups pbg

32: -- Bug 3648630 Starts Here
33: --
34: /* cursor csr_sec_grp is
35: select pbg.security_group_id
36: from per_business_groups pbg
37: , per_cagr_entitlement_items_tl cit
38: -- , EDIT_HERE table_name(s) 333
39: where cit.cagr_entitlement_item_id = p_cagr_entitlement_item_id;
40: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id; */

Line 43: from per_business_groups pbg

39: where cit.cagr_entitlement_item_id = p_cagr_entitlement_item_id;
40: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id; */
41: cursor csr_sec_grp is
42: select pbg.security_group_id
43: from per_business_groups pbg
44: , per_cagr_entitlement_items_tl cit
45: , per_cagr_entitlement_items ci
46: where cit.cagr_entitlement_item_id = p_cagr_entitlement_item_id
47: and ci.cagr_entitlement_item_id = cit.cagr_entitlement_item_id

Line 107: -- per_cagr_entitlement_items_tl and PER_BUSINESS_GROUPS

103: --
104: -- Declare cursor
105: --
106: -- EDIT_HERE In the following cursor statement add join(s) between
107: -- per_cagr_entitlement_items_tl and PER_BUSINESS_GROUPS
108: -- so that the legislation_code for
109: -- the current business group context can be derived.
110: -- Remove this comment when the edit has been completed.
111: cursor csr_leg_code is

Line 113: from per_business_groups pbg

109: -- the current business group context can be derived.
110: -- Remove this comment when the edit has been completed.
111: cursor csr_leg_code is
112: select pbg.legislation_code
113: from per_business_groups pbg
114: , per_cagr_entitlement_items_tl cit
115: -- , EDIT_HERE table_name(s) 333
116: where cit.cagr_entitlement_item_id = p_cagr_entitlement_item_id
117: and cit.language = p_language;