DBA Data[Home] [Help]

APPS.BOM_ALT_DESIGS_POLICY dependencies on ALL_POLICIES

Line 36: from all_policies

32: l_Prod_Schema VARCHAR2(30);
33:
34: cursor c1 is
35: select 1
36: from all_policies
37: where object_owner = p_policy_owner
38: and object_name = 'BOM_ALTERNATE_DESIGNATORS'
39: and policy_name = 'STRUCT_TYPE_ALTS';
40:

Line 42: SELECT 1 FROM All_Policies

38: and object_name = 'BOM_ALTERNATE_DESIGNATORS'
39: and policy_name = 'STRUCT_TYPE_ALTS';
40:
41: CURSOR prod_policy IS
42: SELECT 1 FROM All_Policies
43: WHERE Object_Owner = l_Prod_Schema
44: AND Object_Name = 'BOM_ALTERNATE_DESIGNATORS'
45: AND Policy_Name = 'STRUCT_TYPE_ALTS';
46: