DBA Data[Home] [Help]

APPS.PER_STC_BUS dependencies on PER_BUSINESS_GROUPS

Line 32: -- per_solution_type_cmpts and PER_BUSINESS_GROUPS

28: --
29: -- Declare cursor
30: --
31: -- EDIT_HERE In the following cursor statement add join(s) between
32: -- per_solution_type_cmpts and PER_BUSINESS_GROUPS
33: -- so that the security_group_id for
34: -- the current business group context can be derived.
35: -- Remove this comment when the edit has been completed.
36: cursor csr_sec_grp is

Line 38: from per_business_groups pbg

34: -- the current business group context can be derived.
35: -- Remove this comment when the edit has been completed.
36: cursor csr_sec_grp is
37: select pbg.security_group_id
38: from per_business_groups pbg
39: , per_solution_type_cmpts stc
40: -- , EDIT_HERE table_name(s) 333
41: where stc.component_name = p_component_name
42: and stc.solution_type_name = p_solution_type_name;