APPS.AMW_COMPLIANCE_ENV_ASSOCS_PVT dependencies on AMW_SETUP_RISK_TYPES_B

Line 118: from amw_setup_risk_types_b

114:
115: -- find the parent of specified setup risk type
116: cursor get_parent_risk_type_c (l_setup_risk_type_id IN NUMBER) is
117: SELECT parent_setup_risk_type_id
118: from amw_setup_risk_types_b
119: where setup_risk_type_id = l_setup_risk_type_id;
120:
121: -- find out is the parent of specified setup risk type is associated this env already
122: cursor is_associated_env_c (l_setup_risk_type_id IN NUMBER) is

Line 135: from amw_setup_risk_types_b b

131: SELECT count(*)
132: from amw_compliance_env_assocs
133: where pk1 in (
134: select b.setup_risk_type_id
135: from amw_setup_risk_types_b b
136: where b.parent_setup_risk_type_id = l_setup_risk_type_id
137: )
138: and object_type = 'SETUP_RISK_TYPE'
139: and compliance_env_id = p_compliance_env_id;