APPS.AMW_LOAD_RC_DATA dependencies on AMW_LOOKUPS

Line 1942: -- FROM AMW_LOOKUPS

1938: start_date <= sysdate AND (end_date IS NULL OR end_date >= sysdate)
1939: AND tag=p_lookup_tag;
1940: --CURSOR c_risk_type IS
1941: -- SELECT lookup_code
1942: -- FROM AMW_LOOKUPS
1943: -- WHERE lookup_type='AMW_RISK_TYPE'
1944: -- AND enabled_flag='Y'
1945: -- AND tag=p_lookup_tag;
1946:

Line 2127: FROM AMW_LOOKUPS

2123: PROCEDURE control_objectives (p_ctrl_obj_flag IN VARCHAR2, p_lookup_tag IN VARCHAR2)
2124: IS
2125: CURSOR c_control_obj IS
2126: SELECT lookup_code
2127: FROM AMW_LOOKUPS
2128: WHERE lookup_type='AMW_CONTROL_OBJECTIVES'
2129: AND enabled_flag='Y'
2130: AND tag=p_lookup_tag;
2131:

Line 2256: FROM AMW_LOOKUPS

2252: PROCEDURE control_assertions (p_ctrl_assert_flag IN VARCHAR2, p_lookup_tag IN VARCHAR2)
2253: IS
2254: CURSOR c_control_assert IS
2255: SELECT lookup_code
2256: FROM AMW_LOOKUPS
2257: WHERE lookup_type='AMW_CONTROL_ASSERTIONS'
2258: AND enabled_flag='Y'
2259: AND tag=p_lookup_tag;
2260:

Line 2450: FROM AMW_LOOKUPS

2446: PROCEDURE control_components (p_ctrl_comp_flag IN VARCHAR2, p_lookup_tag IN VARCHAR2)
2447: IS
2448: CURSOR c_control_comp IS
2449: SELECT lookup_code
2450: FROM AMW_LOOKUPS
2451: WHERE lookup_type='AMW_ASSESSMENT_COMPONENTS'
2452: AND enabled_flag='Y'
2453: AND tag=p_lookup_tag;
2454: