DBA Data[Home] [Help]

APPS.HXC_TAT_BUS dependencies on PER_BUSINESS_GROUPS

Line 24: -- hxc_time_attributes and PER_BUSINESS_GROUPS

20: --
21: -- Declare cursor
22: --
23: -- EDIT_HERE In the following cursor statement add join(s) between
24: -- hxc_time_attributes and PER_BUSINESS_GROUPS
25: -- so that the security_group_id for
26: -- the current business group context can be derived.
27: -- Remove this comment when the edit has been completed.
28: cursor csr_sec_grp is

Line 30: from per_business_groups pbg

26: -- the current business group context can be derived.
27: -- Remove this comment when the edit has been completed.
28: cursor csr_sec_grp is
29: select pbg.security_group_id
30: from per_business_groups pbg
31: , hxc_time_attributes tat
32: -- , EDIT_HERE table_name(s) 333
33: where tat.time_attribute_id = p_time_attribute_id;
34: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;

Line 96: -- hxc_time_attributes and PER_BUSINESS_GROUPS

92: --
93: -- Declare cursor
94: --
95: -- EDIT_HERE In the following cursor statement add join(s) between
96: -- hxc_time_attributes and PER_BUSINESS_GROUPS
97: -- so that the legislation_code for
98: -- the current business group context can be derived.
99: -- Remove this comment when the edit has been completed.
100: cursor csr_leg_code is

Line 102: from per_business_groups pbg

98: -- the current business group context can be derived.
99: -- Remove this comment when the edit has been completed.
100: cursor csr_leg_code is
101: select pbg.legislation_code
102: from per_business_groups pbg
103: , hxc_time_attributes tat
104: -- , EDIT_HERE table_name(s) 333
105: where tat.time_attribute_id = p_time_attribute_id;
106: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;